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

ImportDataColumn is not importing all the columns

Thread ID:





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


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 11:05 AM UTC

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.

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