DATA AHEAD toolkit support Discussions

cancel
Showing results for 
Search instead for 
Did you mean: 

XLR8 tool kit and LabView 2020

Solved!
Go to solution
Highlighted

Does anyone know if the latest XLR8 tool kit works with LabView 2020? I am migrating a development system, and upgrading to LabView 2020. There seems to be some problems with XLR8 - I'm getting errors when opening files and corrupt files when creating new ones. 

 

E.g. opening a file (xlsx) created in Excel 365, I get: 

 

Error 5002

XLR8.lvlib:Sub_No_Refnum_Custom_Error.vi<ERR>
Sheet could not be found in workbook. Please make sure the sheet name is spelled correctly.

Naturally, I checked the sheet name but nothing is wrong there. 

 

If I create a new file, add some data to a sheet and close it (save=true), there is no error but file is corrupt and only 26 bytes. If I save it without closing, there is the same 5002 error as above (guessing file maybe is closed and reopened in this operation). 

 

Looking into the .Net references for Sheets of the reference bundle when creating a file, this array seems to be empty. The WBK and CurSheet references look like they contain the correct names of the sheets I added, number of sheets and index of active sheet. 

 

I'd be really grateful if anyone has experience of XLR8 with LV 2020 (and possible pointers on how to make it work). 

0 Kudos
Message 1 of 3
(95 Views)
Highlighted
Solution
Accepted by topic author ulfmalm

This problem was solved after some more googling on the error codes. Turns out it had nothing to do with LabView 2020, but with the language settings of the new machine I installed on. 

 

Preferred language in Windows 10 was set to "English (Sweden)". This created some codepage problem in the SharpZipLib used in NPOI. Changing the preferred language to "English (United States)" solved the issue. 

 

From what I understand, the NPOI version used in XLR8 is 2.1, which is from 2014. This version uses SharpZipLib 0.86, where the zip codepage doesn't default to utf8. Updating to newer NPOI (and newer SharpZipLib) should solve this in XLR8. 

0 Kudos
Message 2 of 3
(51 Views)
Highlighted

Hello

 

thanks for the ticket and especially for the workaround.

 

We are currently in the process to update XLR8 to a current version of NPOI. We hope to release an update sometime in Q1-2021. We will keep you informed about the further progress.

 

Regards,

DATA AHEAD

Kudos are welcome...
0 Kudos
Message 3 of 3
(43 Views)