Hi, I was asked to develop an app that will modify the contents of an excel that I upload, and it all works fine for .xlsx files. BUT the problem is that I have to work with only .xlsm files, I tried saving them as .xlsx but i still get the same error "Excel cannot be open the file 'filename.xlsx' because the file format or file extension is not valid ..." I am using Advanced Excel I followed the steps from https://www.youtube.com/watch?v=-EC47THu5KY&t=370s , I even changed the mime type to "application/vnd.ms-excel.sheet.macroEnabled.12" when I download it but it won't help.
Hi @Niranjan Kumar
I managed to do it, it works exactly like in the video the solution was to select the spreadsheet by the name and not index and it worked, should I delete the post? Thank you!
Great!
I could have been more helpful if OML was attached. Thanks for the solution, by the way.
- Niranjan
Hi @Teodor Octavian Orian,
Excels files with macros can't be updated with this forge component. They might need to add that feature in future.