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
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.
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.