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.

ImportDataColumn is not importing all the columns

Thread ID:





102103 Dec 25,2011 11:14 PM Dec 28,2011 06:05 AM ASP.NET Web Forms (Classic) 1
Tags: XlsIO
Nomitha Angadi
Asked On December 25, 2011 11:14 PM


I am generating an excel sheet by importing data from collection and need to align the numerical data as right aligned and string data to be aligned as left aligned,

i am importing the data as columns from the collection and aligning respective column to right or left aligned(using dataRange.CellStyleName), but the aligmnet is not setting for the individual columns, but setting for the entire sheet. Can you please share if any sample/example available for the same?

Sridhar [Syncfusion]
Replied On December 28, 2011 06:05 AM

Hi Nomita,

Thank you for using Syncfusion Products.

We have tried the sample at our side for ImportDataColumn at our side and we could see the string values are left aligned and the numbers are right aligned in the generated excel file(by default in XlsIO). We have verified the sample with our latest version We have attached the sample in this forum for your reference.

Please try the sample at your side and let us know if this helps you. If you still face the issue, please get back to us with the simplified sample to proceed further on this.

Please let us know if you require any further clarifications.




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.