We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Column width and Row height

Thread ID:





13220 Apr 22,2004 07:39 PM Apr 25,2004 09:12 AM Windows Forms 1
Tags: XlsIO
Asked On April 22, 2004 07:39 PM

I would like to get the column and row sizes from Excel in the form that it presents to the user, which is number of characters (as opposed to points, etc.). Your hover help states that these numbers are in points, but when I actually retrieve them for a particular cell, they do appear to be number of characters (row is exact, column appears to be a little large). When I ask for these settings for the workbook.Columns[1].ColumnWidth, I get bad values (-1.xxxxE308) I repeat, number of characters is preferable, since that results in our system showing the same width (significant digits for our auto-round) on different size screens. I just want to make sure I can still get to this later. Please clarify what is happening. Thanks, Greg

Replied On April 25, 2004 09:12 AM

I''ve looked into this again. It appears that on the terminology, we were both half-right. Excel uses average character width for column width, and points for row height. See http://support.microsoft.com/?kbid=213422 And for the really odd numbers (-1.7976931348623157E+308) I''m getting from Column and Row indexing Column[0].ColumnWidth, etc., they actually work in my program, so it must be some type of datatype/display issue. -Greg


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.