importDataTable without formula

[verrex]

I am using the ImportDataTable function and in my dataTable I have some text that starts with the = symbol, for example "=asdf".

This throws an error because it tries to turn that into a formula when it should be just straight text.

Is there a way to import a dataTable or dataColumn and not have it try and convert the text to a formula, or can I set the format of the cells before I import to not look for a formula?

[Vinoth Kumar K]

Hi Verrex,

Thanks for using Syncfusion products.

1. You cannot import the text that start with "=". But you can import it by giving double quote to that text. Example "=Hai".
2. You cannot set the format of the cell befor you import.

Please refer to the sample in the below link which illustrates the above.
http://websamples.syncfusion.com/samples/XlsIO.Web/6.1.0.34/F70649/main.htm

Please let us know if you have any other concerns. We will be glad to assist you.

Regards,
Vinoth