Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.
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.