LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Getting error 3001 when using Excel Easy Table.vi

Solved!
Go to solution
Solution
Accepted by Snood1

Hello Joel,

 

Sorry about that. Here is the LV 8.6 version


Jim St
National Instruments
RF Product Support Engineer
Message 11 of 12
(1,048 Views)

Thanks, Jim.  I did try adding the "Excel Get Worksheet" VI to set the Worksheet name and it worked.  It seemed weird to me that I would have to always set the worksheet name before adding a table to the worksheet, so I did a little investigating.  It turns out that because of the way I was using a functional global to store the report reference, I wasn't updating the global with the modified reference that had the renamed sheets "Report" and "Summary."  I was using the non-updated reference that still had "Sheet1," "Sheet2," "Sheet3."  Once I made sure that I was storing the updated reference in the global (and then read it out) everything worked.

 

This wasn't an issue when I was using the LabVIEW 8.5 version of the RGTK (1.1.2) but when I upgraded to the 8.6 version (1.1.4) I needed to make this change since the report ref was changed to an LVclass type.

0 Kudos
Message 12 of 12
(1,033 Views)