We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

SetRowHeightPixel not working

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?

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.