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

Aşağıdaki kod, Cell.GetWidthOfValue() ve Cell.GetHeightOfValue() yöntemlerinin kullanımını açıklar.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
// Create workbook object
Workbook workbook = new Workbook();
// Access first worksheet
Worksheet worksheet = workbook.Worksheets[0];
// Access cell B2 and add some value inside it
Cell cell = worksheet.Cells["B2"];
cell.PutValue("Welcome to Aspose!");
// Enlarge its font to size 16
Style style = cell.GetStyle();
style.Font.Size = 16;
cell.SetStyle(style);
// Calculate the width and height of the cell value in unit of pixels
int widthOfValue = cell.GetWidthOfValue();
int heightOfValue = cell.GetHeightOfValue();
// Print both values
Console.WriteLine("Width of Cell Value: " + widthOfValue);
Console.WriteLine("Height of Cell Value: " + heightOfValue);
// Set the row height and column width to adjust/fit the cell value inside cell
worksheet.Cells.SetColumnWidthPixel(1, widthOfValue);
worksheet.Cells.SetRowHeightPixel(1, heightOfValue);
// Save the output excel file
workbook.Save(dataDir + "output_out.xlsx");

Gelişmiş Konular