topic Re: Excel to LabVIEW in LabVIEW

Excel to LabVIEW

Mac98 — Thu, 03 May 2018 04:41:00 GMT

I can't run both of them at the same time. There will always be an error. And i cant seem to solve it. Does anyone knows how to solve?

Re: Excel to LabVIEW

LV_user1 — Thu, 03 May 2018 05:22:33 GMT

Can you post your vi in lower version so that I can open it.

Also, when you are saying cannot run both at the same time do you mean you can not access two excel files at the same time?

Re: Excel to LabVIEW

PazhanivelVenkatt — Thu, 03 May 2018 05:42:51 GMT

Share your Excel Driver VI

Not able to View your LOW LEVEL VI's

I Guess you are holding the reference of the excel file in shift reg and calling different excel files without closing the session, it wont properly. try to Make the driver in such a way that it can open two work books at a time.

Re: Excel to LabVIEW

Bob_Schor — Thu, 03 May 2018 12:06:38 GMT

You are using "Excel" functions (SV Open Excel, SV Open XLS, SV Open Worksheet, SV Cells) that are not part of NI LabVIEW. Are these possibly part of a third-party add-on? If so, you need to ask the third party what is going on. If these are routines that you wrote to do low-level Excel processing using NI's Report Generation Toolkit, then post them, as well, and we can try to figure it out.

Bob Schor

Re: Excel to LabVIEW

Mac98 — Tue, 08 May 2018 03:58:31 GMT

I saw someone use it on Youtube and i downloaded his program. the difference is in his program it was only 1 excel file going in. but i need 2 of it so i thought why not just duplicate the program but change the excel file going in.

https://www.youtube.com/watch?v=qIWcMPuDvBU&t=213s

Re: Excel to LabVIEW

RTSLVU — Tue, 08 May 2018 14:34:19 GMT

I am guessing that the sub-vi's that were not included use the LV Excel Report Generation Toolkit.

The toolkit uses ActiveX to automate Excel and only on instance of ActiveX can control Excel at a time.

You need to make your program more sequential in the way it access Excel.

Re: Excel to LabVIEW

Mac98 — Wed, 09 May 2018 02:25:31 GMT

Here are the sub VI's and i dont understand what u mean

Re: Excel to LabVIEW

PazhanivelVenkatt — Wed, 09 May 2018 06:48:44 GMT

Use SV Open XL once and use the Output to Open different workbook (SV Open XLS) and close the workbook and related reference once read.

Re: Excel to LabVIEW

Mac98 — Wed, 09 May 2018 07:55:38 GMT

@PazhanivelVenkatt wrote:

Use SV Open XL once and use the Output to Open different workbook (SV Open XLS) and close the workbook and related reference once read.

problem is i need to open two excel at the same time. but the block diagram i showed above can only open one at a time

Re: Excel to LabVIEW

PazhanivelVenkatt — Wed, 09 May 2018 09:05:21 GMT

Excel is an application (One instance will support multiple workbooks), Your two files are two workbooks can be opened together in one excel application.

Re: Excel to LabVIEW

Mac98 — Wed, 09 May 2018 09:14:50 GMT

@PazhanivelVenkatt wrote:

Excel is an application (One instance will support multiple workbooks), Your two files are two workbooks can be opened together in one excel application.

But when i run my program, i will run into the error attached below.

Re: Excel to LabVIEW

Ken_Naylor — Wed, 09 May 2018 12:32:54 GMT

Your VI modified as Palanivel suggested. Ran without errors

(Picture posted rather than LabVIEW vi to avoid version mismatch and its a very small amendment)

Ken