Test1 does not run

[PaulMansour]

VALUE ERROR: Undefined name: WB
Test1[23] wb←##.Main.WB'calendar' 1
                     ∧
                      wb←XL.WB'calendar' 1
VALUE ERROR: Undefined name: WSRelType
WSREL[5] fmt←WSRelType∘{⍺(⍺ ⍵ S'{}s/sheet{}.xml')}
             ∧

[PaulMansour]

Morten's recent commit fixes the first error above, but not the second one. WSRelType does not exist.

[mkromberg]

I have committed a work-around for this problem, the underlying problem is that array source files (.apla) are not being loaded by ]acre.openproject. If the source code is loaded with ]link.create, the examples work.

[PaulMansour]

Ah, ok, will investigate why acre is not reading the vars.

…

Sent from my iPhone On Dec 29, 2019, at 12:32 PM, Morten Kromberg <[email protected]> wrote:  I have committed a work-around for this problem, the underlying problem is that array source files (.apla) are not being loaded by ]acre.openproject. If the source code is loaded with ]link.create, the examples work. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<#1?email_source=notifications&email_token=AEO6T7LZHYG76V5AXW5MJU3Q3DUKLA5CNFSM4J6VU2TKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEHZFRMY#issuecomment-569530547>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AEO6T7KBFY2PRRO4KYWT75LQ3DUKLANCNFSM4J6VU2TA>.

[PaulMansour]

Ok, making a little progress. I now get down to Build.Main were the second line of code is:

folder←(0=≢name)⌷name'tempXLSX'

This produces an enclosed, nested vector, not a simple vector, which in turn causes this error:

RANK ERROR: Invalid file or directory name
CreateXLSXDirectory[8] 3 ⎕NDELETE name

[PaulMansour]

Ok, once this is fixed, the test runs to completion. However the resulting XL file gives error warnings when I try to open in excel, which attempts a repair. Once that is done there is no data in the spreadsheet.

[PaulMansour]

A very simple test also gives same error:

TestSimpleSheet←{
     xl←##.Main.XL
     fn←(739⌶0),'/XL2APLSimpleSheet'
     v←4 3⍴⍳12
     wb←xl.WB fn 1             
     _←wb xl.WSAdd'SheetA' 'B2' ''v  
     _←##.Main.Build.Main wb
     0
 }

[mkromberg]

OK, my bad - when hard-coding one of those variables I types "workspace" instead of "worksheet". My subsequent test was, ah, insufficient. Should be OK now.

[PaulMansour]

1. My simple test (and Test1) does not run. This error still occurs (for the reason researched and stated above):

RANK ERROR: Invalid file or directory name
CreateXLSXDirectory[8] 3 ⎕NDELETE name

2. When this error is hacked around, the resulting spreadsheet has data in it (now that the "worksheet" typo is fixed), but still is corrupted somehow. Excel gives a warning error and apparently repairs it on startup.

3. Test1 does not return a zero or a one or anything at all.

[PaulMansour]

Does this error only happen for me on my machine?

RANK ERROR: Invalid file or directory name
CreateXLSXDirectory[8] 3 ⎕NDELETE name

[peterblair1]

In my test of this, I can write one sheet by assigning wb.Sheets←s1 but not multiple sheets with wb.Sheets←s1 s2 s3. What would cause that?

[PaulMansour]

In my test of this, I can write one sheet by assigning wb.Sheets←s1 but not multiple sheets with wb.Sheets←s1 s2 s3. What would cause that?

Unfortunately I am not in a position to answer this -- I have not looked at it in a long time. The original author is not working on it. I intend to substantially review, document and rewrite this project in the coming year.