提供了编程的基础技术教程

zl程序教程

您现在的位置是：首页 >  后端

当前栏目

Spire.Office 7.9.6 for Java--2022-09-22

JAVA -- for 2022 22 Office 09 SPIRE
2023-09-14 09:04:12 时间

谷歌搜会惊喜发现破解版：Spire.Office for Java is a combination of Enterprise-Level Office Java APIs offered by E-iceblue. It includes Spire.Doc for Java, Spire.XLS for Java, Spire.Presentation for Java, Spire.PDF for Java and Spire.Barcode for Java.

Developers can use Spire.Office for Java to perform a wide range of office document operations in Java applications, such as opening, creating, modifying, converting and printing Word, Excel, PowerPoint and PDF documents, generating and scanning 1D&2D barcodes.

As an independent Office Java library, Spire.Office for Java doesn't need Microsoft Office to be installed on either the development or target systems.

Spire.XLS for Java
CategoryIDDescription
New featureSPIREXLS-4002Supports using Worksheet.getMaxDispalyRange() method to get all cell ranges, including objects such as pictures and shapes.
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);
New featureSPIREXLS-4026Supports the =Days() function.
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"");
BugSPIREXLS-3980Fixes the issue that the content format was incorrect after converting xml file to Excel.
BugSPIREXLS-3995Fixes the issue that the chart title was incorrect after converting Excel to SVG.
BugSPIREXLS-4014Fixes the issue that the content format was incorrect after converting Excel file to PDF.
BugSPIREXLS-4020Fixes the issue that the application threw "StringIndexOutOfBoundsException" when converting Excel file to PDF.
BugSPIREXLS-4054Fixes the issue that the application threw "NullPointerException" when getting the chart DataRange.
BugSPIREXLS-4070Fixes the issue that the application threw "FileSystemException" when calling Files.deleteIfExists() to delete the file that was detected by the isPasswordProtected() method.
BugSPIREXLS-2862Fixes the issue that the line feed was incorrect when converting Excel document to PDF.
BugSPIREXLS-2986Fixes the issue that the page margin was incorrect when converting Excel document to PDF.
SPIREXLS-3019
BugSPIREXLS-4043Fixes the issue that the table layout was incorrect when converting Excel document to HTML.
BugSPIREXLS-4072Fixes the issue that the application threw "java.lang.NullPointerException" when modifying the selected value of the filter in the PivotTable.
BugSPIREXLS-4073Fixes the issue that the table cell's borders lost when converting Excel document to PDF.
BugSPIREXLS-4075Fixes the issue that the text direction of X-axis was incorrect when converting chart to image.
BugSPIREXLS-4012Fixes the issue that the document size was not reduced after removing the pictures in header/footer.
BugSPIREXLS-4105Fixes the issue that the application threw "Unknown char:%" when loading an Excel file.
Spire.PDF for Java
CategoryIDDescription
New feature-Supports creating unordered lists in PDF.
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();
Adjustment-Adjusts the internal security of signed timestamps.
BugSPIREPDF-4780Fixes the issue that caused long running time and high memory consumption during converting PDF to Tiff.
BugSPIREPDF-5387Fixes the issue that the application threw "Read failure" when loading PDF file.
BugSPIREPDF-5390Fixes the issue that the bold font was lost when converting PDF to Excel
BugSPIREPDF-5402Fixes the issue that the memory overflowed when converting PDF to Excel
BugSPIREPDF-5419Fixes the issue that the application threw "java.lang.NullPointerException" when converting PDF to Excel
BugSPIREPDF-5422Fixes the issue that the extracted table's contents were incomplete
BugSPIREPDF-5423Fixes the issue that the contents were overlapped after flattening combo box fields
BugSPIREPDF-5438Fixes the issue that arabic characters displayed incorrectly when converting PDF to PDFA3A
BugSPIREPDF-5446Fixes the issue that the application threw "java.lang.NullPointerException" when converting PDF to image
Spire.Doc for Java
CategoryIDDescription
BugSPIREDOC-7704Fixes the issue that the application thrown "IllegalArgumentException" after setting the private fonts in otf format when converting Word to PDF.
BugSPIREDOC-7841Fixes the issue that embedding private fonts failed when converting Word to PDF.
BugSPIREDOC-8242Fixes the issue that the content alignment became inconsistent when converting DOC to DOCX2007.

相关文章