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.

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