Hücre Değeri Genişliğini ve Yüksekliğini Piksel Biriminde Ölçün

Aşağıdaki kod Cell.get_width_of_value() ve Cell.get_height_of_value() yöntemlerinin nasıl kullanılacağını açıklar.

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")

Gelişmiş Konular