EXCEL Files under LINUX - XL2APL does not work under 18.2

Using (or providing) Microsoft.NET Classes

EXCEL Files under LINUX - XL2APL does not work under 18.2

Postby bilekflo on Fri Mar 24, 2023 12:28 pm

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
bilekflo
 
Posts: 28
Joined: Wed Mar 12, 2014 10:07 pm

Re: EXCEL Files under LINUX - XL2APL does not work under 18.

Postby Morten|Dyalog on Sat Mar 25, 2023 8:23 am

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?
User avatar
Morten|Dyalog
 
Posts: 462
Joined: Tue Sep 09, 2008 3:52 pm

Re: EXCEL Files under LINUX - XL2APL does not work under 18.

Postby bilekflo on Mon Mar 27, 2023 8:01 am

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
 
Posts: 28
Joined: Wed Mar 12, 2014 10:07 pm

Re: EXCEL Files under LINUX - XL2APL does not work under 18.

Postby bilekflo on Sat Apr 01, 2023 8:53 am

Hi Morten,

Are there any news on the issue regarding XL2APL?
BR Florian
bilekflo
 
Posts: 28
Joined: Wed Mar 12, 2014 10:07 pm

Re: EXCEL Files under LINUX - XL2APL does not work under 18.

Postby RichardP|Dyalog on Tue Apr 04, 2023 8:55 am

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
RichardP|Dyalog
 
Posts: 35
Joined: Fri Oct 12, 2018 3:05 pm

Re: EXCEL Files under LINUX - XL2APL does not work under 18.

Postby bilekflo on Fri Apr 07, 2023 8:46 pm

Hi Richard,

Thank you for the update.

Kind regards,
Florian
bilekflo
 
Posts: 28
Joined: Wed Mar 12, 2014 10:07 pm


Return to Microsoft.NET

Who is online

Users browsing this forum: Google [Bot] and 0 guests