Unfreeze pane after merge workbook

[stseplukhin]

Hello,
I have two xlsx files with a freeze pane in an each file. When I try merge these files as described in (Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Excel-Merge-Merge-Excel-Files-into-One-with-C-VB.NET.html) I get the resulting xlsx file without the freeze panes. Is it normal behavior or is it bug?

Thanks!

[Annika.Zhou]

Hello,

Thank you for your inquiry.
Please refer to the code below to keep freeze panes after merging files. If there is any question, please provide your input Excel files for further investigation.

Code: Select all

            List<string> files = new List<string>();
            files.Add(@"test1.xlsx");
            files.Add(@"test2.xlsx");

            Workbook newbook = new Workbook();
            newbook.Version = ExcelVersion.Version2013;
            //Clear all worksheets
            newbook.Worksheets.Clear();

            int rowIndex;
            int colIndex;

            //Create a workbook
            Workbook tempbook = new Workbook();
            int num = 0;
            foreach (string file in files)
            {
                //Load the file
                tempbook.LoadFromFile(file);
                foreach (Worksheet sheet in tempbook.Worksheets)
                {
                    //Copy sheet in a workbook
                    newbook.Worksheets.AddCopy(sheet, WorksheetCopyType.CopyAll);
                    if (sheet.IsFreezePanes)
                    {
                        //Get freezepanes and set to newbook
                        sheet.GetFreezePanes(out rowIndex, out colIndex);
                        newbook.Worksheets[num].FreezePanes(rowIndex + 1, colIndex+1);
                    }
                    num++;
                }
            }

            //Save the file
            newbook.SaveToFile("out.xlsx", ExcelVersion.Version2013);

Sincerely,
Annika
E-iceblue support team

[Annika.Zhou]

Hello,

Greetings from e-iceblue.
How is your issue going? Can you give us some feedback at your convenience? Thanks in advance.

Sincerely,
Annika
E-iceblue support team