Excel datagrid

[gmuller@vonet.ch]

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

[Suvi.Wu]

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