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
Can you set the width of cell to a fixed value (e.g. for laying out a standard reporting template)?
Thanks
Barry
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.