Spire.XLS is a professional Excel .NET library that can be used to any type of .NET( C#, VB.NET, ASP.NET, .NET Core) application and Java (J2SE and J2EE) application.

Wed Jan 19, 2011 3:38 am

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:

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