Please help Sorting Excel file

[Mohammad]

Hi

I want a c#.net code example of sorting excel file based on column no (n), Using ExcelEngine,IWorkbook,Iworksheet.

Thanks

[Administrator]

Hi Mohammad,

ExcelRW does not provide any support for sorting the data. You would need to sort the data yourself before inserting into the spreadsheet.

Please let me know if you have any questions.

Thanks,

Stephen.

>Hi
>
> I want a c#.net code example of sorting excel file based on column no (n), Using ExcelEngine,IWorkbook,Iworksheet.
>
>Thanks

[Administrator]

Will this be added ?

Not having the ability to define a sort is a serious drawback.

I want to export a grid to a spreadsheet, but the sort will not be the same as the grid.

>Hi Mohammad,
>
>ExcelRW does not provide any support for sorting the data. You would need to sort the data yourself before inserting into the spreadsheet.
>
>Please let me know if you have any questions.
>
>Thanks,
>
>Stephen.
>
>
>>Hi
>>
>> I want a c#.net code example of sorting excel file based on column no (n), Using ExcelEngine,IWorkbook,Iworksheet.
>>
>>Thanks

[Administrator]

Hi,

Sorry for the delay in getting back to you.

A possible solution to this problem would be to export the grid data to a datatable and then sort it and then export the datatable to excel.

http://www.syncfusion.com/support/kb/grid/Default.aspx?ToDo=view&questId=103

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatadataviewclasssorttopic.asp

However, this approach would only work if you are interested in exporting the contents of the grid without the formatting. Please clarify the following

1) The type of grid that you are using

2) Does the formatting have to be exported?

Thanks,

Stephen.