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.
Thanks for your suggestion. I will overload ImportDataColumn method to allow you import a column from a data view.
Sorry for misrepresenting Overload with (OverRide!) and Thanks for the Correction !
Do u know when this modification will be available ?
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.
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.