Generate xlsx file based on xlsm template file

[Jules Giulian]

Hello,

I have an .xlsm file (macro enabled) containing one macro inside it.
This macro is used to calculate the value for come cells.

I need to use this .xlsm file as a template, to generate an .xlsx file.

Could you please tell me how to achieve this?

I did a test, using Apache POI.
I generate the .xlsx file, but when I try to open the file, it gives me this error:
"Excel cannot open the file because the file format or file extension is not valid. Verify that the file has not been corrupted, and that the file extension matched the format of the file"

Here is the sample code:

                InputStream is = null;
		XSSFWorkbook wb_template = null;
		SXSSFWorkbook swb = null;
		XSSFWorkbook wb = null;
		Sheet sh = null;
		try {
			
			is = this.getClass().getResourceAsStream("Template_Macro.xlsm");
			wb_template = new XSSFWorkbook(is);

			swb = new SXSSFWorkbook(wb_template);
			swb.setCompressTempFiles(true);

			wb = swb.getXSSFWorkbook();
			sh = wb.getSheetAt(0);

		} catch (IOException e) {
			System.err.println("Error reading themplate");
			e.printStackTrace(System.err);
		}
//more code here

// output is an xlsx file
FileOutputStream fos;
		try {
			fos = new FileOutputStream(createTemporaryFile(".xlsx"));
			wb.write(fos);
			fos.flush();
			fos.close();
			// wb.dispose();
			wb.close();
		} catch (FileNotFoundException e) {
			e.printStackTrace(System.err);
		} catch (IOException e) {
			e.printStackTrace(System.err);
		} catch (Exception e) {
			e.printStackTrace(System.err);
		}