Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Mon Oct 11, 2010 8:44 am

Hi,

I might be going blind but i couldnt see any demo's for sorting.

Is this implemented in spire.XLS?

cantyco
 
Posts: 3
Joined: Fri Sep 24, 2010 1:31 pm

Mon Oct 11, 2010 9:21 am

Hello,

Thank you for your inquiry.
Spire.XLS can not support for sorting the data in current release. you need to sort the data yourself before inserting data to the spreadsheet.
Here is a link for your reference,
http://msdn.microsoft.com/en-us/library/w56d4y5z.aspx
By other way, you can place the data to the data table and sort it.
Please let me know if you have any questions and concerns.

Best Regards
User avatar

Flash
 
Posts: 56
Joined: Thu Jun 29, 2006 2:34 pm

Mon Oct 11, 2010 9:51 am

Hi,

I thought that might be the case. The only issue with this is that if you are wanting to sort by a formula, you can't unless you generate the information what the formula equals before hand.

Would be a nice feature for a future release.

cantyco
 
Posts: 3
Joined: Fri Sep 24, 2010 1:31 pm

Mon Oct 11, 2010 3:29 pm

Hello,

Thank you for your good suggestion.

We will think of this feature and add it to Spire.XLS in the future release.
Please let me know if you have any questions and concerns.

Best Regards
User avatar

Flash
 
Posts: 56
Joined: Thu Jun 29, 2006 2:34 pm

Return to Spire.XLS