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