Excel XLSX API Library to Your Java App
Use Document Solutions for Excel, Java Edition to open, update, and save an Excel workbook from your Java application.
Document Solutions for Excel, Java Edition is a high-speed Java Excel spreadsheet API library that that enables you to programmatically create, edit, import, and export Excel XSLX spreadsheets from Java applications. Develop in Java for Windows, Linux, and Mac and deploy to the Cloud, including Azure, AWS, and AWS Lambda. The interface-based API is modeled on Excel’s document object model, which means you can import, calculate, query, generate, and export any spreadsheet scenario, create full reports, sort/filter tables, sort/filter pivot tables, dashboard reports, add charts, sparklines, conditional formats, import and export Excel templates and also convert spreadsheets to PDF, HTML, or an Image type.
In this blog post, MESCIUS Product Marketing Specialist Mackenzie Albitz takes you through the steps for adding an Excel API to your Java application, including:
Creating a Java Application Including the Java Excel API
Creating Excel Tables Using the ITable Interface, which includes…
Initializing Table Data
Adding the Excel Tables
Applying Table Formulas
Setting the Table’s Row Height and Column Width
Saving the Java Excel Workbook
