Aspose.Total for Java is a comprehensive suite of components that enables developers to easily integrate PCL to XLSM conversion feature in their Java applications. This suite consists of two components, Aspose.PDF for Java and Aspose.Cells for Java.
Aspose.PDF for Java is a powerful PDF manipulation API that enables developers to render PCL to XLSX. It provides a wide range of features such as creating, editing, converting, and manipulating PDF documents. It also supports a variety of formats such as PDF, XPS, TIFF, HTML, and many more. With this API, developers can easily render PCL to XLSX in a few lines of code.
Aspose.Cells for Java is a powerful spreadsheet programming API that enables developers to convert XLSX to XLSM. It provides a wide range of features such as creating, editing, formatting, and manipulating spreadsheets. It also supports a variety of formats such as XLSX, XLSM, XLSB, CSV, and many more. With this API, developers can easily convert XLSX to XLSM in a few lines of code.
By using Aspose.Total for Java, developers can easily integrate PCL to XLSM conversion feature in their Java applications in two-step process. Firstly, by using Aspose.PDF for Java, developers can render PCL to XLSX. In the second step, developers can convert XLSX to XLSM by using Spreadsheet Programming API Aspose.Cells for Java. This suite of components provides developers with a comprehensive set of tools to easily integrate PCL to XLSM conversion feature in their Java applications.
Convert PCL File to XLSM via Java
Conversion Requirements
You can easily use Aspose.Total for Java directly from a Maven based project and include Aspose.PDF for Java and Aspose.Cells for Java in your pom.xml.
// supports PDF, CGM, EPUB, TeX, PCL, PS, SVG, XPS, MD, MHTML, XML, and XSLFO file format | |
// load PDF with an instance of Document | |
Document document = new Document("template.pdf"); | |
// save document in XLSX format | |
document.save("XlsxOutput.xlsx", SaveFormat.Xlsx); | |
// load the XLSX file in an instance of Workbook | |
Workbook book = new Workbook("XlsxOutput.xlsx"); | |
// supports CSV, XLSB, XLSM, XLT, XLTX, XLTM, XLAM, TSV, TXT, ODS, DIF, MD, SXC, and FODS file format | |
// save XLSX as CSV | |
book.save("output.csv", SaveFormat.AUTO); |
Convert Protected PCL to XLSM via Java
If your PCL document is password protected, you cannot convert it to XLSM without the password. Using the API, you can first open the protected document using a valid password and convert it after it. In order to open the encrypted file, you can initialize a new instance of the Document class and pass filename and password as arguments.
// supports PDF, CGM, EPUB, TeX, PCL, PS, SVG, XPS, MD, MHTML, XML, and XSLFO file format | |
// open PDF document | |
Document doc = new Document("input.pdf", "Your@Password"); | |
// save PDF as XLSX format | |
document.save("XlsxOutput.xlsx", SaveFormat.Xlsx); | |
// load the XLSX file in an instance of Workbook | |
Workbook book = new Workbook("XlsxOutput.xlsx"); | |
// supports CSV, XLSB, XLSM, XLT, XLTX, XLTM, XLAM, TSV, TXT, ODS, DIF, MD, SXC, and FODS file format | |
// save XLSX as CSV | |
book.save("output.csv", SaveFormat.AUTO); |
Convert PCL File to XLSM with Watermark via Java
While converting PCL file to XLSM, you can also add watermark to your output XLSM file format. In order to add a watermark, create a new Workbook to open the converted XLSX file. Select Worksheet via its index, create a Shape and use its addTextEffect function, set colors, transparency and more. After that you can save your XLSX document as XLSM with Watermark.
// supports PDF, CGM, EPUB, TeX, PCL, PS, SVG, XPS, MD, MHTML, XML, and XSLFO file format | |
// load PDF with an instance of Document | |
Document document = new Document("template.pdf"); | |
// save document in XLSX format | |
document.save("XlsxOutput.xlsx", SaveFormat.Xlsx); | |
// load the XLSX file in an instance of Workbook | |
Workbook book = new Workbook("XlsxOutput.xlsx"); | |
// get the first default sheet | |
Worksheet sheet = book.getWorksheets().get(0); | |
// add Watermark | |
Shape wordart = sheet.getShapes().addTextEffect(MsoPresetTextEffect.TEXT_EFFECT_1, "CONFIDENTIAL", | |
"Arial Black", 50, false, true, 18, 8, 1, 1, 130, 800); | |
// get the fill format of the word art | |
FillFormat wordArtFormat = wordart.getFill(); | |
// set the color | |
wordArtFormat.setOneColorGradient(Color.getRed(), 0.2, GradientStyleType.HORIZONTAL, 2); | |
// set the transparency | |
wordArtFormat.setTransparency(0.9); | |
// make the line invisible | |
LineFormat lineFormat = wordart.getLine(); | |
lineFormat.setWeight(0.0); | |
// supports CSV, XLSB, XLSM, XLT, XLTX, XLTM, XLAM, TSV, TXT, ODS, DIF, MD, SXC, and FODS file format | |
// save XLSX as CSV | |
book.save("output.csv", SaveFormat.AUTO); |