Free Support Forum - aspose.com

Setting cell width

Can you set the width of cell to a fixed value (e.g. for laying out a standard reporting template)?

Thanks

Barry


This message was posted using Page2Forum from Formatting Rows & Columns - Aspose.Cells for .NET

Hi,

See the following sample code that will set the standard width and standard height for all the cells of the first worksheet.

Sample code:

Workbook workbook = new Workbook();
Cells cells = workbook.Worksheets[0].Cells;
//Set the standardwidth of cell
cells.StandardWidth = 9;
//Set the standardheight of cell
cells.StandardHeight = 20;

workbook.Save(“e:\test\outBook.xls”);


Thank you.