Spire.Office for Java 7.9.6 がリリースされました

Workbook workbook = new Workbook();
workbook.loadFromFile("TEST.xlsx");
        Worksheet sheet1 = workbook.getWorksheets().get(0);
        //copy all objects(such as text, shape, image...) from sheet2 to sheet1
        for(int i=1;i<workbook.getWorksheets().getCount(); i++){
            Worksheet sheet2 = workbook.getWorksheets().get(i);
sheet2.copy((CellRange) sheet2.getMaxDisplayRange(),sheet1,sheet1.getLastRow()+1,sheet2.getFirstColumn(),true);
        }
        workbook.saveToFile("output.xlsx", ExcelVersion.Version2013);

Workbook workbook = new Workbook();
workbook.loadFromFile("Test.xlsx");
        Worksheet sheet = workbook.getWorksheets().get(0);
sheet.getCellRange("C4").setFormula("=DAYS(A8,A1)");
workbook.saveToFile(""RES.xlsx"");

public void DrawMarker(PdfUnorderedMarkerStyle style, String outputFile) {
    PdfDocument doc = new PdfDocument();
    PdfNewPage page = (PdfNewPage) doc.getPages().add();
    PdfMarker marker = new PdfMarker(style);
    String listContent = "Data Structure\n"
            + "Algorithm\n"
            + "Computer Newworks\n"
            + "Operating System\n"
            + "C Programming\n"
            + "Computer Organization and Architecture";
    PdfUnorderedList list = new PdfUnorderedList(listContent);
    list.setIndent(2);
    list.setTextIndent(4);
    list.setMarker(marker);
    list.draw(page, 100, 100);
    doc.saveToFile(outputFile, FileFormat.PDF);
    doc.close();
}
public void PdfMarker_CustomImage() throws Exception {
    String outputFile = "PdfMarker_CustomImage.pdf";
    String inputFile_Img = "sample.png";
    PdfDocument doc = new PdfDocument();
    PdfNewPage page = (PdfNewPage) doc.getPages().add();
    PdfMarker marker = new PdfMarker(PdfUnorderedMarkerStyle.Custom_Image);
    marker.setImage(PdfImage.fromFile(inputFile_Img));
    String listContent = "Data Structure\n"
            + "Algorithm\n"
            + "Computer Newworks\n"
            + "Operating System\n"
            + "C Programming\n"
            + "Computer Organization and Architecture";
    PdfUnorderedList list = new PdfUnorderedList(listContent);
    list.setIndent(2);
    list.setTextIndent(4);
    list.setMarker(marker);
    list.draw(page, 100, 100);
    doc.saveToFile(outputFile, FileFormat.PDF);
    doc.close();
}
public void PdfMarker_CustomTemplate() throws Exception {
    String outputFile = "PdfMarker_CustomTemplate.pdf";
    String inputFile_Img = "sample.png";
    PdfDocument doc = new PdfDocument();
    PdfNewPage page = (PdfNewPage) doc.getPages().add();
    PdfMarker marker = new PdfMarker(PdfUnorderedMarkerStyle.Custom_Template);
    PdfTemplate template = new PdfTemplate(210, 210);
    marker.setTemplate(template);
    template.getGraphics().drawImage(PdfImage.fromFile(inputFile_Img), 0, 0);
    String listContent = "Data Structure\n"
            + "Algorithm\n"
            + "Computer Newworks\n"
            + "Operating System\n"
            + "C Programming\n"
            + "Computer Organization and Architecture";
    PdfUnorderedList list = new PdfUnorderedList(listContent);
    list.setIndent(2);
    list.setTextIndent(4);
    list.setMarker(marker);
    list.draw(page, 100, 100);
    doc.saveToFile(outputFile, FileFormat.PDF);
    doc.close();
}
public void PdfMarker_CustomString() throws Exception {
    String outputFile = "PdfMarker_CustomString.pdf";
    PdfDocument doc = new PdfDocument();
    PdfNewPage page = (PdfNewPage) doc.getPages().add();
    PdfMarker marker = new PdfMarker(PdfUnorderedMarkerStyle.Custom_String);
    marker.setText("AAA");
    String listContent = "Data Structure\n"
            + "Algorithm\n"
            + "Computer Newworks\n"
            + "Operating System\n"
            + "C Programming\n"
            + "Computer Organization and Architecture";
    PdfUnorderedList list = new PdfUnorderedList(listContent);
    list.setIndent(2);
    list.setTextIndent(4);
    list.setMarker(marker);
    list.draw(page, 100, 100);
    doc.saveToFile(outputFile, FileFormat.PDF);
    doc.close();