Skip to Main Content
Forums

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Convert .xltm to .xlsm using apache poi

981207Nov 25 2016 — edited Nov 25 2016

Dear All,

i am using jdeveloper version of 12.1.3.0 and poi version of 3.9.

I have a template named Test.xltm in my database.On click of download button i want to convert the Test.xltm to Test.xlsm.

Default extension given is Test .xls and it is downloading without any issues.

But when i change the filename (Test.xlsm) in business logic, i am getting invalid file format or file corrupted while opening the file .

Below is my code :

String filename=Test.xls;

ExternalContext econtext = facesContext.getExternalContext();
HttpServletResponse response = (HttpServletResponse) econtext.getResponse();

Sheet sheet;

response.setContentType("application/force-download");

response.setHeader("Content-Disposition", "attachment;filename=\"" + filename + "\"");

BlobDomain template = (BlobDomain) ExcelRowvo.getAttribute("Template");  ----> getting .xltm template

InputStream is = template.getInputStream();

Workbook workbook = new XSSFWorkbook(OPCPackage.create(filename));  ----->creating .xlsm file

sheet = workbook.getSheetAt(0);

is.read();

please tell me how to write .xltm to .xlsm for downloading the file as Test.xlsm

Thanks

Comments

Nik
Hi
/proc - special file system for managing/monitoring system. Realy this files don't have space on the disk.

/proc/kcore - file for mapping physical memory.


You can't give more space after removing this file, but can get more problem.

This file will present after reboot.


Regards.
1 person found this helpful
Dude!
Like all other files below /proc the kcore file is only a virtual file. It contains the RAM the kernel can allocate. Therefore this should not be touched or read. It is nothing to worry about. This file doesn't use actual disk space and only exists virtually. On 64-bit systems the size of /proc/kcore is even 128TB because that's the absolute limit of what 64-bit systems can allocate.
1 person found this helpful
Dude!
You cannot remove the /proc/kcore file:

[root@ol1 ~]# rm /proc/kcore
rm: remove regular file `/proc/kcore'? y
rm: cannot remove `/proc/kcore': Operation not permitted
1 person found this helpful
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 23 2016
Added on Nov 25 2016
#application-development-in-java, #jdeveloper-and-adf
1 comment
842 views