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.
Unfortunately, activation email could not send to your email. Please try again.

importDataTable without formula

Thread ID:

Created:

Updated:

Platform:

Replies:

70649 Dec 21,2007 02:19 PM Dec 26,2007 05:54 PM ASP.NET Web Forms (Classic) 1
loading
Tags: XlsIO
verrex
Asked On December 21, 2007 02:19 PM

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 [Syncfusion]
Replied On December 26, 2007 05:54 PM

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



CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;