What is the unit of row height and column width in Excel?

24 Jun 20263 minutes to read

By default, XlsIO uses points as the unit of measurement for both row height and column width.

Use SetColumnWidth
and SetRowHeight to set dimensions in points.

Use GetColumnWidth and GetRowHeight to retrieve dimensions in points.

If you need pixel values, XlsIO provides pixel based APIs: GetColumnWidthInPixels, GetRowHeightInPixels, SetColumnWidthInPixels, SetRowHeightInPixels.

//Set column width in points
sheet.SetColumnWidth(1, 20);

//Get column width in points
var widthPoints = sheet.GetColumnWidth(1);
Console.WriteLine("Column width in points: " + widthPoints);

//Set column width in pixels
sheet.SetColumnWidthInPixels(1, 160);

//Get column width in pixels
var widthPixels = sheet.GetColumnWidthInPixels(1);
Console.WriteLine("Column width in pixels: " + widthPixels);

//Set row height in points
sheet.SetRowHeight(1, 15);

//Get row height in points
var heightPoints = sheet.GetRowHeight(1);
Console.WriteLine("Row height in points: " + heightPoints);

//Set row height in pixels
sheet.SetRowHeightInPixels(1, 40);

//Get row height in pixels
var heightPixels = sheet.GetRowHeightInPixels(1);
Console.WriteLine("Row height in pixels: " + heightPixels);
//Set column width in points
sheet.SetColumnWidth(1, 20);

//Get column width in points
var widthPoints = sheet.GetColumnWidth(1);
Console.WriteLine("Column width in points: " + widthPoints);

//Set column width in pixels
sheet.SetColumnWidthInPixels(1, 160);

//Get column width in pixels
var widthPixels = sheet.GetColumnWidthInPixels(1);
Console.WriteLine("Column width in pixels: " + widthPixels);

//Set row height in points
sheet.SetRowHeight(1, 15);

//Get row height in points
var heightPoints = sheet.GetRowHeight(1);
Console.WriteLine("Row height in points: " + heightPoints);

//Set row height in pixels
sheet.SetRowHeightInPixels(1, 40);

//Get row height in pixels
var heightPixels = sheet.GetRowHeightInPixels(1);
Console.WriteLine("Row height in pixels: " + heightPixels);
'Set column width in points
sheet.SetColumnWidth(1, 20)

'Get column width in points
Dim widthPoints As Integer = sheet.GetColumnWidth(1)
Console.WriteLine("Column width in points: " & widthPoints)

'Set column width in pixels
sheet.SetColumnWidthInPixels(1, 160)

'Get column width in pixels
Dim widthPixels As Integer = sheet.GetColumnWidthInPixels(1)
Console.WriteLine("Column width in pixels: " & widthPixels)

'Set row height in points
sheet.SetRowHeight(1, 15)

'Get row height in points
Dim heightPoints As Integer = sheet.GetRowHeight(1)
Console.WriteLine("Row height in points: " & heightPoints)

'Set row height in pixels
sheet.SetRowHeightInPixels(1, 40)

'Get row height in pixels
Dim heightPixels As Integer = sheet.GetRowHeightInPixels(1)
Console.WriteLine("Row height in pixels: " & heightPixels)