Spire.XLS for .NET is a professional Excel .NET library that can be used to any type of .NET( C#, VB.NET, ASP.NET, .NET Core) application, both ASP.NET web sites and Windows Forms application.

Tue Apr 03, 2012 1:36 am

Hello,
I open an Excel file and places it in a datagrid.

If it does not contain formula, it reads all the columns properly, if a column contains a formula, it matters to me the formula as text and not as a value.

Thank you in advance.

Muller Guy

gmuller@vonet.ch
 
Posts: 8
Joined: Wed Mar 23, 2011 10:58 am

Tue Apr 03, 2012 9:12 am

Hello Muller Guy,

Thanks for your inquiry.

When you using the method sheet.ExportDataTable(sheet.AllocatedRange, true, true), setting the last parameter to true, the formula will display as value instead of text. Please have a kind try.

In case of any ambiguity, please feel free to contact us.

Kind Regards
Suvi
e-iceblue support
User avatar

Suvi.Wu
 
Posts: 154
Joined: Thu Oct 20, 2011 2:53 am

Return to Spire.XLS