EXCEL Files under LINUX - XL2APL does not work under 18.2
6 posts
• Page 1 of 1
EXCEL Files under LINUX - XL2APL does not work under 18.2
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
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.
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?
P.S. What is "ImportSheets", it doesn't seem to be part of XL2APL?
-
Morten|Dyalog - Posts: 462
- Joined: Tue Sep 09, 2008 3:52 pm
Re: EXCEL Files under LINUX - XL2APL does not work under 18.
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
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.
Hi Morten,
Are there any news on the issue regarding XL2APL?
BR Florian
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.
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
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.
Hi Richard,
Thank you for the update.
Kind regards,
Florian
Thank you for the update.
Kind regards,
Florian
- bilekflo
- Posts: 28
- Joined: Wed Mar 12, 2014 10:07 pm
6 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 0 guests
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group