Export XSLFO to XLSM via Java

Convert XSLFO file to XLSM by using on premise Java API within any Java J2SE, J2EE, J2ME applications

Aspose.Total for Java is a comprehensive suite of components that enables developers to easily integrate XSLFO to XLSM conversion feature in their Java applications. This two-step process is made possible by using Aspose.PDF for Java and Aspose.Cells for Java.

Aspose.PDF for Java is a powerful PDF manipulation API that enables developers to render XSLFO 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 XSLFO.

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, converting, and manipulating spreadsheets. It also supports a variety of formats such as XLSX, XLSM, XLSB, XLS, CSV, and ODS.

By using Aspose.Total for Java, developers can easily integrate XSLFO to XLSM conversion feature in their Java applications. This two-step process is made possible by using Aspose.PDF for Java and Aspose.Cells for Java. Aspose.PDF for Java enables developers to render XSLFO to XLSX and Aspose.Cells for Java enables developers to convert XLSX to XLSM.

Aspose.Total for Java is a comprehensive suite of components that enables developers to easily integrate XSLFO to XLSM conversion feature in their Java applications. It provides a wide range of features such as creating, editing, converting, and manipulating PDF documents and spreadsheets. It also supports a variety of formats such as PDF, XPS, TIFF, HTML, XSLFO, XLSX, XLSM, XLSB, XLS, CSV, and ODS.

Convert XSLFO File to XLSM via Java

Open XSLFO file using Document class
Convert XSLFO to XLSX by using save method
Load XLSX document by using Workbook class
Save the document to XLSM format using save method

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);

view raw convert-pdf-to-excel.java hosted with ❤ by GitHub

Convert Protected XSLFO to XLSM via Java

If your XSLFO 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);

view raw convert-protected-pdf-to-excel.java hosted with ❤ by GitHub

Convert XSLFO File to XLSM with Watermark via Java

While converting XSLFO 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);