Excel datagrid

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

Excel datagrid

Postby gmuller@vonet.ch » 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

Re: Excel datagrid

Postby Suvi.Wu » 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: 156
Joined: Thu Oct 20, 2011 2:53 am

Return to Spire.XLS

Who is online

Users browsing this forum: No registered users and 0 guests