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 and Java (J2SE and J2EE) application.

Tue Apr 03, 2012 1:36 am

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

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
e-iceblue support
User avatar

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

Return to Spire.XLS