Measure the Width and Height of the Cell Value in Unit of Pixels
Sometimes you need to calculate the width and height of cell value to fit the cell value inside the cell. Aspose.Cells for Python via .NET provides Cell.get_width_of_value() and Cell.get_height_of_value() methods for this purpose. By using these methods you can calculate width and height of the cell value and then set the width of the column and height of the row of that cell respectively and this will then adjust or fit the cell value inside the cell.
Alternatively, you can also autofit rows and columns of your cell or range of cells using Aspose.Cells for Python via .NET APIs.
The following code explains the use of Cell.get_width_of_value() and Cell.get_height_of_value() methods.
from aspose.cells import Workbook | |
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
# The path to the documents directory. | |
dataDir = RunExamples.GetDataDir(".") | |
# Create workbook object | |
workbook = Workbook() | |
# Access first worksheet | |
worksheet = workbook.worksheets[0] | |
# Access cell B2 and add some value inside it | |
cell = worksheet.cells.get("B2") | |
cell.put_value("Welcome to Aspose!") | |
# Enlarge its font to size 16 | |
style = cell.get_style() | |
style.font.size = 16 | |
cell.set_style(style) | |
# Calculate the width and height of the cell value in unit of pixels | |
widthOfValue = cell.get_width_of_value() | |
heightOfValue = cell.get_height_of_value() | |
# Print both values | |
print("Width of Cell Value: " + str(widthOfValue)) | |
print("Height of Cell Value: " + str(heightOfValue)) | |
# Set the row height and column width to adjust/fit the cell value inside cell | |
worksheet.cells.set_column_width_pixel(1, widthOfValue) | |
worksheet.cells.set_row_height_pixel(1, heightOfValue) | |
# Save the output excel file | |
workbook.save(dataDir + "output_out.xlsx") |