XlsIO ExcelEngine: Excel like header sorting

[ov]

Is it possible to do excel like sorting with Syncfusion xlsio engine?

I have attached the included excel sorting file,

if you select all the data by clicking on the top left and go to Data tab | Sort, you can see all the user predefined sorting values.

Is it possible with Syncfusion XlsIO library?

I saw this example of data sorting but it is not excel-like. It is only sorting the data internally and all predefined sorting values are missing from the excel file.

http://mvc.syncfusion.com/demos/web/xlsio/datasorting

Attachment: ExcelSortingExample_b79c98ac.zip

[Sridhar Sukumar]

Hi ov, 

 

Yes. It is possible to do Excel like sorting with XlsIO. We have shown the value based sorting in our online demo. But you can also sort the data based on the cell color and the font color using XlsIO. 

 

We have prepared a sample as per your requirement which can be downloaded from the following link. 

 

Sample link:  

https://www.syncfusion.com/downloads/support/directtrac/general/ze/DataSorting_XlsIO1582457309.zip 

 

To know more about Data Sorting in XlsIO, kindly refer the following UG documentation link.  

 

UG documentation link: https://help.syncfusion.com/file-formats/xlsio/worksheet-cells-manipulation#data-sorting 

 

Please let us know if you have any concerns. 

 

Regards 

Sridhar S 

[ov]

Probably I haven't explained well.

I tried the sample provided above and it is still missing the user predefined values.

If you look at the attached picture, the sorting values are missing from generated excel file.

Attachment: MissingExcelSortingValues_7624e280.zip

[Sridhar Sukumar]

Hi ov,