CODEWITHSUNDEEP
javaexcelapache-poixlsxxlsm
Anamika Jain
Anamika Jain

Reputation: 1

Can we convert xlsm to xlsx using POI apache

It is possible to convert xlsm file to xlsx file using Apache poi. I am trying to writing a xlsm file but after writing i want it to be converted into xlsx file. can you give me any solution.

Upvotes: 0

Views: 1825

Answers (2)

Hamster_NL
Hamster_NL

Reputation: 153

xlsm means that the Excel Workbook containts macros (VBA code)

If you want to save that workbook as an xlsx (an Excel Workbook WITHOUT macros), Excel will notice and will REMOVE all VBA code.

So, there's no point in saving as xlsm to an xlsx (as all VBA code will be removed), unless you have no VBA code in your xlsm (and then there's no point to using a xlsm in the first place).

Upvotes: 1

pnuts
pnuts

Reputation: 59460

With Excel save .xlsm version as .xlsx .

Upvotes: 0

Related Questions