Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Wed Jan 19, 2011 3:38 am

Hello,
When I launch an Excel workbook, I find that the default columnwidth and rowheight don't match my need.
May I set the default columnwidth and rowheight?
Thanks! :P :mrgreen:

moonsky
 
Posts: 9
Joined: Mon Dec 13, 2010 7:39 am

Wed Jan 19, 2011 7:30 am

Thank you for your inquiry!
Of course you can. You may set the sheet.DefaultColumnWidth and sheet.DefaultRowHeight properties of the sheet with the following code: sheet.DefaultColumnWidth = 10;//1(point) = 0.3528 mm
sheet.DefaultRowHeight = 10;
e-iceblue support
User avatar

iceblue support
 
Posts: 240
Joined: Tue Dec 21, 2010 2:56 am

Return to Spire.XLS