EXCEL Files under LINUX - XL2APL does not work under 18.2

[bilekflo]

Dear colleagues,
I am using Dyalog 18.2 at openSUSE 15.

I installed the .NET Core 3.1. It works.

Then I used the XL2APL from Richard Park from Github
However I failed to open the excel file with following error:

ImportSheets '/home/ybi/apl2/report-20230228.xlsx'
VALUE ERROR: Undefined name: ZipArchiveMode
OpenExcelFile[6] ⎕NEW ZipArchive(fs ZipArchiveMode.Read)

Any ideas what can be done about this?
Are there now any other methods to handle EXCEL under LINUX available?

Best regards,
Florian

[Morten|Dyalog]

Hi Florian! The XL2APL code needs a couple of tweaks to get it to work with .NET Core. I made a little progress (https://github.com/rikedyp/XL2APL/pull/1), but have now run into a problem that I need to talk to a developer about, I hope to have more news early next week.

P.S. What is "ImportSheets", it doesn't seem to be part of XL2APL?

[bilekflo]

Hi Morten,

Thank you for taking a look into this issue.
ImportSheets is a simple function:

wbi←ImportSheets wb
⍝ .-------------------------------------------------------------------------------.
⍝ | Import Excel Sheets |
⍝ '-------------------------------------------------------------------------------'
wbi←XL2APL.Main.GetWorkbookInfo wb
wbi∘XL2APL.Main.GetSheetData¨wbi.SheetNames

to load the worksheets of the EXCEL-file. It was presented in one of Richards videos.

BR Florian

[bilekflo]

Hi Morten,

Are there any news on the issue regarding XL2APL?
BR Florian

[RichardP|Dyalog]

Hi Florian
This appears to have hit bugs in the .NET Core / new .NET bridge in the interpreter. We are working to resolve the issues, and will let you know when they are available to use by installing the latest release of Dyalog.

Thanks, and sorry for the delay
Rich Park

[bilekflo]

Hi Richard,

Thank you for the update.

Kind regards,
Florian