Move entire column

[trozzi1957]

I have a need to change the order of columns on a worksheet. How can I do this.

[Marcia.Zhou]

Hello,

Thanks for your inquiry!

Please refer to the following code to achieve your needs. Here I also attached my test file for your reference. If there is any question, just feel free to contact us.

Code: Select all

            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"E:\testdoc\exc3.xlsx");
            Worksheet worksheet = workbook.Worksheets[0];
            int[] neworder = new int[] { 4, 1, 2, 0, 5, 3, 6 };
            Worksheet newSheet = workbook.Worksheets.Add("temp");
            newSheet.CopyFrom(worksheet);
            for(int i= 0; i < neworder.Count(); i++)
            {
                newSheet.Columns[i].Copy(worksheet.Columns[neworder[i]], true, true);
            }
            workbook.Worksheets.Remove(newSheet);
            workbook.SaveToFile("res.xlsx", Spire.Xls.FileFormat.Version2013);           
            Process.Start("res.xlsx");


Sincerely,
Marcia
E-iceblue support team

[Marcia.Zhou]

Hello,

Hope you are doing well!

Has the issue been solved now? Could you please give us some feedback at your convenience?

Thanks in advance.

Sincerely,
Marcia
E-iceblue support team