セル範囲をトリムする方法

using IronXL;

WorkBook workBook = WorkBook.Create(ExcelFileFormat.XLSX);
WorkSheet workSheet = workBook.DefaultWorkSheet;

workSheet["A2"].Value = "A2";
workSheet["A3"].Value = "A3";

workSheet["B1"].Value = "B1";
workSheet["B2"].Value = "B2";
workSheet["B3"].Value = "B3";
workSheet["B4"].Value = "B4";

// Retrieve column
RangeColumn column = workSheet.GetColumn(0);

// Apply trimming
Range trimmedColumn = workSheet.GetColumn(0).Trim();

Imports IronXL

Private workBook As WorkBook = WorkBook.Create(ExcelFileFormat.XLSX)
Private workSheet As WorkSheet = workBook.DefaultWorkSheet

Private workSheet("A2").Value = "A2"
Private workSheet("A3").Value = "A3"

Private workSheet("B1").Value = "B1"
Private workSheet("B2").Value = "B2"
Private workSheet("B3").Value = "B3"
Private workSheet("B4").Value = "B4"

' Retrieve column
Private column As RangeColumn = workSheet.GetColumn(0)

' Apply trimming
Private trimmedColumn As Range = workSheet.GetColumn(0).Trim()