Its the strangest thing. All my calls to SetColumnWidthPixel do work when my spreadsheet is generated, but the SetRowHeightPixel calls seem to do nothing at all. I am trying to set rows to various sizes, but when my worksheet generates in Excel, every single row is the default height of 17 pixels.
// Create the cells collection for the worksheet and apply some initial formatting
Cells cells = sheet.Cells;
// Column widths
cells.SetColumnWidthPixel(0, 20);
cells.SetColumnWidthPixel(1, 80);
for (j = 2; j < 13; j++)
cells.SetColumnWidthPixel(j, 64);
cells.SetColumnWidthPixel(j, 512);
cells.SetColumnWidthPixel(j + 1, 20);
// Row heights
cells.SetRowHeightPixel(0, 20);
for (j = 1; j < 37; j++)
cells.SetRowHeightPixel(j, 12);
for (j = 37; j < 128; j++)
cells.SetRowHeightPixel(j, 15);
Any idea what could be going on?
Thanks,
Christine Coder
Hi Christine Coder,
Thanks for providing us details.
Well, I tested your code and it works fine. Which version of Aspose.Cells for .NET you are using?
Could you try the attached version.
Thank you.