DATA AHEAD toolkit support Discussions

cancel
Showing results for 
Search instead for 
Did you mean: 

Open Create Workbook error if worksheet name has space

I'm using XLR8 to read data from existing .xls files.  The files have only one worksheet, but the worksheet name is 2 words "Calibration Data" When I run Open/Create from the toolkit and receive error code 5002.  I've tried leaving the worksheet name empty to default to the first sheet, but have the same problem. 

 

This is part of a programming language transposition project and needs be backwards compatible with the old files in field. 

 

Using LabVIEW 2015/2017 windows 10. 

https://www.youracclaim.com/badges/7af733bc-832f-47fe-aaa6-9df19dddd73b/public_url
0 Kudos
Message 1 of 2
(3,034 Views)

Hi bley1988,

 

did you select the correct instance of "Open Create Workbook", ie. the xls-version, not the standard option xlsx, because that would lead to the error 5002 you've mentioned.

 

Regards,

Data Ahead

Kudos are welcome...
0 Kudos
Message 2 of 2
(3,017 Views)