Hello everyone.
I have data in the CSV file.
ELBO;ELBO-17375;90;80;4;0;1,5;109
TUBI;TUBE-8732;0;150;6;0;11,54;184,01
ELBO;ELBO-17375;90;200;8;0;20;17
REDU;REDU-17378-K;0;200;10;8;7,2;2
ELBO;ELBO-17375;90;150;6;0;8,1;25
TUBI;TUBE-8732;0;25;3,5;0;2,15;40,11
ELBO;ELBOW-36-42-81;90;25;3,5;0;0,2;9
TUBI;TUBE-8732;0;200;8;0;41,63;153,06
TUBI;TUBE-8732;0;250;8;0;52,28;262,35
ELBO;ELBO-17375;90;250;8;0;31;25
TUBI;TUBE-8732;0;80;4;0;6,36;716,17
To sort the data in the correct order I am using Microsoft.Office.Interop.Excel
The data code is approximate.
Range range = sheets["A1", string.Concat("L", count)];
Range ranges = sheets[string.Concat("B1:B", count), Missing.Value];
sheets.Sort.SortFields.Add(ranges, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
ranges = sheets[string.Concat("C1:C", count), Missing.Value];
sheets.Sort.SortFields.Add(ranges, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
ranges = sheets[string.Concat("D1:D", count), Missing.Value];
sheets.Sort.SortFields.Add(ranges, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
ranges = sheets[string.Concat("E1:E", count), Missing.Value];
sheets.Sort.SortFields.Add(ranges, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
ranges = sheets[string.Concat("F1:F", count), Missing.Value];
sheets.Sort.SortFields.Add(ranges, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
sheets.Sort.SetRange(range);
sheets.Sort.Orientation = XlSortOrientation.xlSortColumns;
sheets.Sort.SortMethod = XlSortMethod.xlPinYin;
sheets.Sort.Apply();
The output is as follows
ELBO ELBO-17375 90 80 4 0 1,5 109
ELBO ELBO-17375 90 150 6 0 8,1 25
ELBO ELBO-17375 90 200 8 0 20 17
ELBO ELBO-17375 90 250 8 0 31 25
ELBO ELBOW-36-42-81 90 25 3,5 0 0,2 9
REDU REDU-17378-K 0 200 10 8 7,2 2
TUBI TUBE-8732 0 25 3,5 0 2,15 40,11
TUBI TUBE-8732 0 80 4 0 6,36 716,17
TUBI TUBE-8732 0 150 6 0 11,54 184,01
TUBI TUBE-8732 0 200 8 0 41,63 153,06
TUBI TUBE-8732 0 250 8 0 52,28 262,35
Sorting is sequentially one column after another.
Is it possible to do the same sort without excel?
Maybe there are some libraries for these sorts?
Thanks