topic Re: Excel Insert worksheet in LabVIEW

Excel Insert worksheet

breemb — Thu, 20 Oct 2011 15:28:53 GMT

I am having trouble trying to insert an excel worksheet from one workbook into another workbook. None of the excel functions seem to work for me and I am having a problem trying to find a good example. Basically what my program does is it will collect temperature data from an appliance over an hours time and then spit this data to an excel template which already has an implemented graph and a formula chart. The graph that I am using is an older excel graph which cannot be changed. After the data is added to the excel spreadsheet, the excel graph will update with the new data and I run a few macros to process the data and save to the formula chart. The issue though is, I don't know upfront how many tests I need to run so I want to add a spreadsheet template (which has the embedded graph and chart) to the end of the workbook and follow the same data process from above. This will happen for as many tests as I need to run. Can anyone help me with this issue.

Re: Excel Insert worksheet

CptZizu — Thu, 20 Oct 2011 15:57:17 GMT

I'm working on the attached vi, which in its current state will copy a sheet from an excel file to another bringing along the formatting, etc. It copies fine, however I'm having trouble closing out Excel after the vi executes (which isn't a huge problem but I would like to solve it).

Can anyone shed some light as to why that is happeining?

Re: Excel Insert worksheet

ben64 — Thu, 20 Oct 2011 16:02:58 GMT

I can't open your VI since I'm using LV2009 but the way to close Excel is to use the _Application Quit method.

Ben64

Re: Excel Insert worksheet

CptZizu — Thu, 20 Oct 2011 16:04:40 GMT

Isn't that what this is? Or am I using it in a wrong way?

Re: Excel Insert worksheet

ben64 — Thu, 20 Oct 2011 16:08:29 GMT

We can't see from your picture what is referenced to the _Application quit method and also why you are using it twice. Is there an error reported?

Ben64

Re: Excel Insert worksheet

CptZizu — Thu, 20 Oct 2011 16:10:25 GMT

I've opened 2 excel references, the original where I'd like the second excel sheet to merge into, and the one with the sheet to be merged. Attached should be the whole vi so you can get a better idea.

Edit: I do not get an error reported

Re: Excel Insert worksheet

CptZizu — Thu, 20 Oct 2011 16:16:06 GMT

Would it work to open Excel once, and choose different workbooks within that (for the different files)? This is my first project with activeX so I have a bit of a learning curve, and I do appreciate the help.

Re: Excel Insert worksheet

ben64 — Thu, 20 Oct 2011 16:21:57 GMT

I think you should definitely use only one Excel._Application reference. A difference I noted is that in one of my vi I use the _Workbook.Close method before closing the application.

Ben64

Re: Excel Insert worksheet

CptZizu — Thu, 20 Oct 2011 18:13:03 GMT

Thanks for the help ben64. I've revised it to use only one Excel._Application reference, and added the _Workbook.Close method, but Excel stays open as one of the processes (the application itself is hidden). Still works like a charm, just doesn't want to close out of Excel.

Re: Excel Insert worksheet

ben64 — Thu, 20 Oct 2011 18:15:22 GMT

Are you sure there is no error reported in the error cluster?

Ben64

Re: Excel Insert worksheet

CptZizu — Thu, 20 Oct 2011 19:10:39 GMT

No error.