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.

Thu Jul 18, 2019 7:59 am

Hi today i tryed out the sorting function from spire an i have an issue.
can you help me to fix this?

Code: Select all

var workbook = new Workbook();
workbook.Worksheet.Add();
workbook.Worksheet.Add();

//this will be sort the second column in a worksheet
var first = workbook.Worksheets[0];
workbook.DataSorter.SortColumns.Add(1, OrderBy.Descending);
workbook.DataSorter.Sort(first.Range[1,1,10,10]);

//this will also sort the first column but in the second worksheet
var second workbook.Worksheets[1];
workbook.DataSorter.SortColumn.Add(5, OrderBy.Ascending);
workbook.DataSorter.Sort(second.Range[1,1,10,10]);


Semjasa
 
Posts: 36
Joined: Wed Dec 19, 2018 11:50 am

Thu Jul 18, 2019 9:14 am

Hello,

Thanks for your inquiry.
To help us look into your issue accurately, please provide more details about your issue, such as any screenshot or error message. Thanks in advance.

Sincerely,
Lisa
E-iceblue support team
User avatar

Lisa.Li
 
Posts: 1261
Joined: Wed Apr 25, 2018 3:20 am

Mon Jul 22, 2019 5:45 am

Hello,

Greetings from E-iceblue.
Could you please let us know how is your issue going? Thanks in advance for your feedback and time.

Sincerely,
Lisa
E-iceblue support team
User avatar

Lisa.Li
 
Posts: 1261
Joined: Wed Apr 25, 2018 3:20 am

Mon Jul 29, 2019 7:23 am

Excuse me, I had a vacation.

this solves my problem. NICE you are so fast!!!

Semjasa
 
Posts: 36
Joined: Wed Dec 19, 2018 11:50 am

Mon Jul 29, 2019 7:29 am

Hello,

Glad to hear that! If you encounter any issue related to our products in the future, just feel free to contact us.
Wish you all the best!

Sincerely,
Lisa
E-iceblue support team
User avatar

Lisa.Li
 
Posts: 1261
Joined: Wed Apr 25, 2018 3:20 am

Return to Spire.XLS