We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Data import fails when string value starts with '='

We are exporting data to Excel using XlsIO library. The string values in data table may start with equal sign. The import fails, XlsIO thinks this is a formula and tries to parse it. 
Is there a way to turn off the formula parsing without actually modifying data and inserting apostrophe at the first position?
Please see the attached project.
Thanks for advice,

1 Reply

RA Rajesh A Syncfusion Team December 4, 2013 12:59 PM UTC

Hi Rory Kingan,

      Thank you for using the Syncfusion products.

We are not able to reproduce the reported issue “Data import fails when string value starts with '='”. We have created the sample for your reference and attached the same in below link. Please let us know if this helps you.

Sample Link: Sample.zip

Note: we couldn’t find the Sample project in your post.

Please let us know if you have any clarification.



Live Chat Icon For mobile
Up arrow icon