Log in to AnswerLog in to Follow
2018-06-27 00-09-40
Edwin Siruma
71Views
8Comments
[Advanced Excel] Possible to support the XLSM file format?
Question
Forge
excel-png
Service icon
Advanced Excel
Forge component by Carlos Freitas

I am trying to import XLSM format file and I receive this error. Possible to include it as one of the supported files for Advanced Excel?

Thank you.

-Edwin

1
0
30 Aug 2019
2022-07-06 03-36-19
Hanno
mvp_badge
MVP

Hi Edwin

I will investigate and get back to you soon.

Hanno

0
0
30 Aug 2019

Hi Hanno, news?


Regards

Carmine

0
0
15 Jun

Hi,
i have the same problem.
I'm working in Advanced Excel with xlsm file and all work well, i can write cells without errors, but when i use Workbook_GetBinaryData and from the UI i download the file excel says that the format is not valid. If i rename the file in .xlsx excel open it with all the data inside

0
0
15 Jun

Hi, try use the Mime-Type "application/vnd.ms-excel.sheet.macroEnabled.12" for xlsm file types.

0
0
16 Jun

Hi Huarlem, 

thanks for the reply.

 I am using Outsyatems 11 and the "Download" widget does not have the mime-type attribute. How can I do this in Outsysems 11?

Regards 

Carmine

0
0
16 Jun

Hi Carmine, which version of Service Studio are you using?

I'm using the Beta version and 11.14.16, try this one.

0
0
17 Jun

Hi Huarlem,

are you using a traditional web application?  (Here i can enter the Mime-type).

I attach an example oml. Using Advance excel and I get the following error:

"The file cannot be opened because the format is not valid"



My Outsystems version is 11.53.3


Regards


Export.oml

0
0
17 Jun

Yes, I'm using the traditional web.

I looked at your oml but couldn't get a solution.

Are you trying to open the file in the same version of MSOffice it was created on?

I got it to work using an xlsm file created in my Excel and downloading it with the Mime-Type "application/vnd.ms-excel.sheet.macroEnabled.12", maybe it has something to do with the difference between MSOffice versions.

0
0
17 Jun
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.