Free Support Forum - aspose.com

Sort Excel Column or ImportDataColumn that takes a DataView

Hi,

We have a datatable with all the available data, not sorted, not column ordered.
Column Ordering mean, if i have column1,column2,column3,column4 in datatable
I need to rearange the columns --> column4,column2,column1…

We need to bind this data to the Excel, After

1. Sorting the Data and

2. Re-Ordering the Columns.

3. Bind to Excel

My problem, here is,
1. If I create a DataView, I can sort the Data, but cannot
do the column ordering.

2. If I do ExcelCell.ImportDataColumn, which takes only a DataTable (which is not sorted !)

SO, If we have a overriding method ImportDataColumn which takes a DataView
that will solve our problem

OR If we can sort the Excel cell itself (using column name), after binding , will
also solve our Problem.

Pls. Help

Gopi

Hi Gopi,

Thanks for your suggestion. I will overload ImportDataColumn method to allow you import a column from a data view.

Thanks Laurence,

Sorry for misrepresenting Overload with (OverRide!) and Thanks for the Correction !

Do u know when this modification will be available ?

Gopi

It will be availabe at the start of next week.

Cool… That’s really fast ! and we really appreciate all you Guys hard work and quick response. Real good Customer Support.

Thanks,

Gopi

Hi Gopi,

Please download and try v3.4.1 at www.aspose.com/downloads. This new method is supported now.

Works like a Charm ! Thanks you Guys. Wonderful Work.

Gopi