LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Labview writing to wrong excel file

Hi, I have a program (which I don't currently have access to to post), but essentially I'm using an excel package I found online which has many tools such as write single numeric, write single string, etc. I've been trying to run multiple VIs using open file dialogs for the excel paths and they all open properly but when the data starts writing from the different hardware (serial ports), they're writing into each others excel files and one of the programs stopped execution. Is it possible to write into multiple excel spreadsheets at the same time, or has that been known to cause problems? Thanks in advance.

0 Kudos
Message 1 of 6
(3,597 Views)

@dsconfer wrote:

Hi, I have a program (which I don't currently have access to to post), but essentially I'm using an excel package I found online which has many tools such as write single numeric, write single string, etc. I've been trying to run multiple VIs using open file dialogs for the excel paths and they all open properly but when the data starts writing from the different hardware (serial ports), they're writing into each others excel files and one of the programs stopped execution. Is it possible to write into multiple excel spreadsheets at the same time, or has that been known to cause problems? Thanks in advance.


define "spreadsheet".

Do you mean an Excel file?

Do you mean a worksheet inside an Excel file?

 

It is definitely possible to do both.

0 Kudos
Message 2 of 6
(3,592 Views)

Hi dsconfer,

 

you should ask the author of that "excel package you found online"…

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 3 of 6
(3,591 Views)

Yes, it's an excel file with the data and graphs on sheets. They're loaded from templates (with built in conversions for temperatures and such) and then it prints into those templates. Each program has a seperate template, but for some reason they're opening the correct ones but it's not printing into the correct spreadsheets. One program will print into anothers template. They're completely seperate excel spreadsheets, but they're not printing correctly. But so long as it's possible I'm sure I can figure it out. 

 

 

Also, I'll try to get ahold of the author. Thank you for the replies.

0 Kudos
Message 4 of 6
(3,588 Views)

Without knowing what the code is it's impossible to pinpoint the problem. It should be entirely possible with the functions built in within labview, so it sounds like the VIs you're using are mixing their references.

 

Regards,
Ben C
---

---
0 Kudos
Message 5 of 6
(3,586 Views)

I thought so - I'm just not sure why they're mixing references when they're all using their own open file dialogs to reference the paths. I'll look more into it. Thank you.

0 Kudos
Message 6 of 6
(3,582 Views)