Aspose.Cells for Java 17.02.0 发行说明

 // Create an instance of HTMLLoadOptions

HTMLLoadOptions loadOptions = new HTMLLoadOptions();

// Set the AutoFitColsAndRows property to true

loadOptions.setAutoFitColsAndRows(true);

// Create an instance of Workbook and load HTML while passing

// the object of HTMLLoadOptions class created above

Workbook book = new Workbook(dir + "sample.htm", loadOptions);

 public class WarningCallback implements IWarningCallback

{

	public void warning(WarningInfo warningInfo)

    {

        if (warningInfo.getWarningType() == WarningType.DUPLICATE_DEFINED_NAME)

        {

            System.out.println("Duplicate Defined Names Found as " + warningInfo.getDescription());

        }

    }

}

 // Create an instance of LoadOptions class

LoadOptions options = new LoadOptions();

// Set the WarningCallback property to custom class

options.setWarningCallback(new WarningCallback());

// Load a sample spreadsheet in an instance of Workbook while 

// passing the object of LoadOptions class as defined above

Workbook book = new Workbook(dir + "sample.xlsx", options);

 // Create an instance of Workbook and load a sample

Workbook book = new Workbook(dir + "sample.xlsx");

// Retrieve the cells collection of the first worksheet in the sample

Cells cells = book.getWorksheets().get(0).getCells();

// Create an instance of TxtLoadOptions

TxtLoadOptions options = new TxtLoadOptions();

// Specify the separator

options.setSeparator(',');

// Split the data in range B2:B4

cells.textToColumns(1, 1, 3, options);

 // 创建一个 Workbook 实例并加载一个示例

工作簿 book = new Workbook(dir + "sample.xlsx");

// 检索电子表格中使用的字体列表

字体 []字体 = book.getFonts();

// 迭代列表并写入字体名称

对于 (int i = 0; i< fonts.length; i ++)

{

	Font font = fonts[i];

	System.out.println(font.getName());

}

 // Create an instance of Workbook and load a sample

Workbook book = new Workbook(dir + "sample.xlsx");

// Create an instance of TxtSaveOptions

TxtSaveOptions options = new TxtSaveOptions();

// Set TrimLeadingBlankRowAndColumn property to true

options.setTrimLeadingBlankRowAndColumn(true);

// Export to CSV format while removing the leading blank rows & columns

book.save(dir + "output.csv", options);