ワークシート内の空白の行と列を削除する

空白の行を削除するためのC#コード

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(".")
# Open an existing excel file.
wb = Workbook(dataDir + "SampleInput.xlsx")
# Create a Worksheets object with reference to
# The sheets of the Workbook.
sheets = wb.worksheets
# Get first Worksheet from WorksheetCollection
sheet = sheets[0]
# Delete the Blank Rows from the worksheet
sheet.cells.delete_blank_rows()
# Save the excel file.
wb.save(dataDir + "mybook.out.xlsx")

空白の列を削除するためのC#コード

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(".")
# Open an existing excel file.
wb = Workbook(dataDir + "SampleInput.xlsx")
# Create a Worksheets object with reference to
# The sheets of the Workbook.
sheets = wb.worksheets
# Get first Worksheet from WorksheetCollection
sheet = sheets[0]
# Delete the Blank Columns from the worksheet
sheet.cells.delete_blank_columns()
# Save the excel file.
wb.save(dataDir + "mybook.out.xlsx")