Message-ID: <281460608.10409.1711724360209.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_10408_279712213.1711724360209" ------=_Part_10408_279712213.1711724360209 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Worksheet.StandardWidth

Worksheet.StandardWidth

Description

Sets or returns the default column width, in points (1/72 of an inch= ).=20
C#
=20
public double StandardWidth{ get; set; }
= =20
=20
vb.net
=20
Public Property StandardWidth() As Double
= =20
=20

Examples

=20
C#
=20
          //--- Get StandardWidth
          ws.StandardWidth =3D 100;

          //--- Set StandardWidth
          double colWidth =3D ws.StandardWidth;
        
=20
vb.net
=20
          '--- Get StandardWidth
          ws.StandardWidth =3D 100

          '--- Set StandardWidth
          Dim colWidth As Double =3D ws.StandardWidth
        
=20
=20

Remarks

=20

The maximum width of an Excel column is defined (by Excel) as 255 charac= ters in the workbook's 'Normal' font. Because of this, workbooks with diffe= rent normal fonts may have different maximum values for this property.

Depending on your version of Excel, the default normal font is either 10= pt Arial (Excel 2003 and earlier) or 11pt Calibri (Excel 2007 and later). B= oth of those have a character width of about 5.25 points, so the default ma= ximum value for StandardWidth is 1338.

No matter your workbook's normal font, ExcelWriter will constrain this p= roperty to a valid range.

Because Excel uses character widths instead of points internally you may= see some small error when reading values from this property, usually of le= ss than a point.

------=_Part_10408_279712213.1711724360209--