I want to read a macro enabled excel file (XLSM file format) from application server using ABAP in background. I have already tried reading using opendataset statement and converting it to internal table but no luck. I am able to read XLSX files successfully using this methodology (xlsx2abap) i am currently using but not XLSM files.
Can anyone please suggest a way to do it? Thanks in advance.