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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

importDataTable without formula

Thread ID:





70649 Dec 21,2007 07:19 PM UTC Dec 26,2007 10:54 PM UTC ASP.NET Web Forms (Classic) 1
Tags: XlsIO
Asked On December 21, 2007 07:19 PM UTC

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 10:54 PM UTC

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.

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



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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon 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.Close Icon