Measure the Width and Height of the Cell Value in Unit of Pixels

Sometimes you need to calculate the width and height of a cell’s value to fit the value inside the cell. Aspose.Cells provides Cell.getWidthOfValue() and Cell.getHeightOfValue() methods for this purpose. By using these methods, you can calculate the width and height of the cell value and then set the column width and row height of that cell, respectively; this will adjust the cell to fit the value.

Alternatively, you can also autofit rows and columns of your cells or a range of cells using Aspose.Cells APIs.

The following code explains the use of Cell.getWidthOfValue() and Cell.getHeightOfValue() methods.

Advanced topics

• Get Text Width of Cell Value