Last updated on June 15, 2022 by Nayyer Shahbaz
Blog Home

Convert XLSB to PDF in Java

XLS to PDF
Learn how to convert Excel to PDF Online

An (XLSB) Binary file format is a collection of records and structures that specify Excel workbook content. The content may include unstructured or semi-structured tables of numbers, text, or both numbers and text, formulas, external data connections, charts, and images. On the other end, PDF provides the capability to view content on any platform without compromising fidelity. Therefore owing to this capability, we are going to discuss the details on how to programmatically convert XLSB to PDF using Java SDK.

Excel to PDF Conversion API

Aspose.Cells Cloud SDK for Java is our award-winning solution providing the capabilities to create, edit and convert popular Excel files to PDF, HTML, TIFF, CSV, and various other supported file formats. Now in order to use the SDK, we are going to add the following reference in pom.xml of the maven build type.

  1. <repositories>
  2. <repository>
  3. <id>AsposeJavaAPI</id>
  4. <name>Aspose Java API</name>
  5. <url>https://repository.aspose.cloud/repo/</url>
  6. </repository>
  7. </repositories>
  8. <dependencies>
  9. <dependency>
  10. <groupId>com.aspose</groupId>
  11. <artifactId>aspose-cells-cloud</artifactId>
  12. <version>22.5</version>
  13. </dependency>
  14. </dependencies>
<repositories>
    <repository>
        <id>AsposeJavaAPI</id>
        <name>Aspose Java API</name>
        <url>https://repository.aspose.cloud/repo/</url>
    </repository>
</repositories>
<dependencies>
    <dependency>
        <groupId>com.aspose</groupId>
        <artifactId>aspose-cells-cloud</artifactId>
        <version>22.5</version>
    </dependency>
</dependencies>

Now in order to use Cloud SDK, you need to register an account over Aspose Cloud and lookup/create Client ID and Client Secret at Cloud Dashboard.

Convert Excel to PDF in Java

In the following section, we are going to discuss the details on how to convert an XLSB to PDF format and save the output in Cloud storage.

  • Create an instance of CellsApi while providing client credentials as input arguments
  • Specify the name of input XLSB, resultant format, and output file name
  • Upload the input XLSB to cloud storage using uploadFile(…) method
  • Finally, call the method cellsWorkbookGetWorkbook(…) to initiate the conversion operation
// for more examples, please visit https://github.com/aspose-cells-cloud/aspose-cells-cloud-java
try
{
// Get ClientID and ClientSecret from https://dashboard.aspose.cloud/
String clientId = "bbf94a2c-6d7e-4020-b4d2-b9809741374e";
String clientSecret = "1c9379bb7d701c26cc87e741a29987bb";
// create an instance of CellsApi using client credentials
CellsApi api = new CellsApi(clientId,clientSecret);
// name of input XLSB workbook
String name = "myDocument.xlsb";
// password details if workbook in encrypted
String password = null;
// Specifies whether set workbook rows to be autofit.
Boolean isAutoFit = true;
// Specifies whether only save table data. Only use pdf to excel.
Boolean onlySaveTable = true;
// resultant file format
String format = "PDF";
// load file from local system
File file = new File("c://Users/shahbnay/Downloads/"+name);
// upload input XLSB to cloud storage
api.uploadFile("input.xlsb", file, "Internal");
// perform document conversion operation
File response = api.cellsWorkbookGetWorkbook(name, password,format,
isAutoFit, onlySaveTable, null,"Internal", "Resultant.pdf","Internal", null);
// print success message
System.out.println("XLSB sucessfully converted to PDF format !");
}catch(Exception ex)
{
System.out.println(ex);
}
view raw convert-xlsb-to-pdf.java hosted with ❤ by GitHub

The sample files used in the above example can be downloaded from

XLS to PDF
Image 1:- XLSB to PDF conversion preview

XLSB to PDF using cURL Commands

In this section, we are going to use cURL commands to load XLSB from cloud storage and convert it to PDF format. So as a pre-requisite, we need to first generate a JWT access token based on client credentials.

  1. curl -v "https://api.aspose.cloud/connect/token" \
  2. -X POST \
  3. -d "grant_type=client_credentials&client_id=bbf94a2c-6d7e-4020-b4d2-b9809741374e&client_secret=1c9379bb7d701c26cc87e741a29987bb" \
  4. -H "Content-Type: application/x-www-form-urlencoded" \
  5. -H "Accept: application/json"
curl -v "https://api.aspose.cloud/connect/token" \
-X POST \
-d "grant_type=client_credentials&client_id=bbf94a2c-6d7e-4020-b4d2-b9809741374e&client_secret=1c9379bb7d701c26cc87e741a29987bb" \
-H "Content-Type: application/x-www-form-urlencoded" \
-H "Accept: application/json"

Once the JWT token is generated, please execute the following command to perform the conversion.

  1. curl -v -X GET "https://api.aspose.cloud/v3.0/cells/input.xlsb?format=PDF&isAutoFit=false&onlySaveTable=false&outPath=Converted.pdf&checkExcelRestriction=true" \
  2. -H "accept: application/json" \
  3. -H "authorization: Bearer <JWT Token>"
curl -v -X GET "https://api.aspose.cloud/v3.0/cells/input.xlsb?format=PDF&isAutoFit=false&onlySaveTable=false&outPath=Converted.pdf&checkExcelRestriction=true" \
-H  "accept: application/json" \
-H  "authorization: Bearer <JWT Token>"

Conclusion

In this article, we have discussed the details regarding the conversion of Excel to PDF using Java code snippets. Similarly, we have also explored the option to convert XLS to PDF using cURL commands. You may consider exploring product documentation to learn about other exciting features offered by the API.

If you encounter any issues while using the APIs, please feel free to contact us via the product support forum.

Related Articles

We highly recommend visiting the following links to learn more about:

This entry was posted in Aspose.Cells Cloud Product Family and tagged , , , , . .