Getting error 3001 when using Excel Easy Table.vi

[Snood1]

When making a call to Excel Easy Table.vi (Report Generation Toolkit) I get a 3001 error.

I have attached an example VI to demonstrate the problem.  Please run "Add Table Example.vi" in the attached zip.  This sample program is made up of VIs from a larger program, so it made more sense to create a sample program and only include the required VIs than include the entire large program.  So that is why the Report class wire comes from a functional global VI.

What is a bit strange is that Excel Easy Table is used to write a summary table at the top of the spreadsheet successfully in "Initialize Report.vi."  It is only when I then make the additional call to Excel Easy Table in Add Table Example that I get the 3001 error.  If you have any ideas why I'm getting the 3001 error, please let me know.

I'm using LabVIEW 8.6 and RGTK 1.1.4.

Thanks,

Joel

[smercurio_fc]

Are you using 64-bit?

[Snood1]

Nope, just 32-bits for this engineer. 

[Jim_S]

Hello Snood1,

I tried to open this example VI you have posted but unfortunately, I don't have OpenG on my computer in order to run this. Is it possible to narrow the scope of this example so that it only includes the excel VIs? This will make it easier for me to get down to the bottom of the issue. I appreciate it.

[Snood1]

Oh yeah, I did include the OpenG in the zip, but now I see that that one has dependencies which I didn't include.    I will need to make some mods to my example VI to get around the OpenG VI(s), but probably won't be able to do it until Monday.  Look for another response after the weekend.

-Joel

[Snood1]

Well I was able to get to this before the weekend after all.  I hope this is ok, but it was easier to me to just include all the OpenG dependencies.  (There were only two.)  So I added those to the zip.  Does that work?

-Joel

[Jim_S]

Hello Joel,

I did some testing from the VIs you posted and I was able to reproduce the error. I tried to narrow down which VI that caused this and I haven't been able to yet. From what I can tell though it does seem to produce the excel file without any issues. Did you notice this on your set up? It is a little hard for me to tell if it worked perfect because I had to remove the OpenG code out of it in order to test it. If it did omit any data, please tell me which part so I can narrow this down further.

[Snood1]

Good, glad you could reproduce the error.  Hopefully you will be able to determine where the error occurs.  And you are correct, the Excel file does get generated.  As you probably guessed, I'm trying to create an xls with test results.  I first write some summary information to the xls (during initialization of the report), and that gets created without error.  But then when I try to write a table of result column headers {"Test ID", "Test Name", "Lower Limit", etc.} that's when I get the 3001 error.

-Joel

[Jim_S]

Hey Joel,

I figured out why this error was occuring. After comparing how you were adding the columns in the Report Write Info Table.vi in the Initialize Report.vi to just using the Excel Easy table VI, you hadn't provided a reference to which worksheet it needed to write the data to. I changed your code to include this reference and it worked perfectly without any errors. I have attached a .zip file with those changes so you can look at it.

FYI: Don't try to use this code as a direct replacement with yours. In order for me to reproduce the error, I had to modify several VIs in order to get it to run.

I hope this information helps you with it.

[Snood1]

Hi Jim,

Can you provide these in LabVIEW 8.6 format?  I don't have LabView 9.0.

Thanks,

Joel