Cannot copy row height and column width

[zhenlei1970]

Hello,

I want to copy range from one sheet to another:

var wk=workbook.CreateEmptySheet();
workbook.Worksheets[0].Copy(workbook.Worksheets[0].Range[1, 1, x - 1, y - 1], wk.Range[1, 1, x - 1, y - 1],true, true,true,true);

The content was copied correctly. However the height of rows and the width of columns were not copied. Is there a way to copy range with column width and row height?

Thanks

Lei

[Amber.Gu]

Hi,

Thanks for your inquiry.
Sorry to tell you that there is no direct way to copy the cell range with column width and row height. But you could get the column width and row height of the cell range first, then assign them to the new cell range. Please refer to the code below.

Code: Select all

            var wk = workbook.CreateEmptySheet();

            //copy the content of the cell range
            workbook.Worksheets[0].Copy(sheet.Range[1, 1, x-1, y-1], wk.Range[1, 1, x-1, y-1], true, true, true, true);

            //copy the column width and row height of the cell range
            for (int i = 0; i < x-1 ;i++ )
            {
                wk.Rows[i].RowHeight = sheet.Rows[i].RowHeight;               
            }
            for (int j = 0; j < y-1 ;j++ )
            {
                wk.Columns[j].ColumnWidth = sheet.Columns[j].ColumnWidth;
            }

If the code couldn't solve your issue, to help us investigate it accurately, please offer us your input Excel file and your desired result file. You could upload them here or send us(support@e-iceblue.com) via email.

Best wishes,
Amber
E-iceblue support team

[Amber.Gu]

Hi,

Greetings from E-iceblue.
Have you tried the code I offered you last time? Does it solve your issue?
Could you please give us some feedback at your convenience?

Best wishes,
Amber
E-iceblue support team