测量单元格值的宽度和高度，单位为像素。
Contents
[
Hide
]
有时候您需要计算单元格值的宽度和高度，以使单元格值适应单元格。Aspose.Cells for Python via .NET提供了这个目的的Cell.get_width_of_value()和Cell.get_height_of_value()方法。通过使用这些方法，您可以计算单元格值的宽度和高度，然后分别设置该单元格的列宽和行高，从而调整或适应单元格值。
另外，您也可以使用Aspose.Cells for Python via .NET的API自动调整单元格或单元格范围的行和列。
以下代码解释了使用Cell.get_width_of_value()和Cell.get_height_of_value()方法的用法。
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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") |