LabVIEW break down when write data to excel

[weschen]

when i write the data to excel file,the LabVIEW break down.It's the "Excel_Save_workbook.vi" issue,but i don't know how solve the issue.my excel is 2016,LabVIEW is 2013.PS:when i read the excel file,it work ok.

[GerdW]

Hi weschen,

for me your VI runs without errors.

when i write the data to excel file,the LabVIEW break down.

What is a "break down" with respect to LabVIEW?

It's the "Excel_Save_workbook.vi" issue,but i don't know how solve the issue.

Which issue?

According to the attached image the VI shows no errors.

[weschen]

when run to the "Excel_Save_workbook.vi",it will quit the LabVIEW. So I don't get any error remind message.

[GerdW]

Again: your VI runs fine for me… (LV2017 + Excel2010)

[Bob_Schor]

Your version of LabVIEW is three years older than your version of Excel, software made by another company that did not consult NI to maintain "compatibility" with their older software.

If you are using Office 2016, I recommend you run LabVIEW 2016.  If you are using LabVIEW 2013, I recommend you use Office 2013.

Bob Schor

[Ben]

Dig into your code where the file is being saved and find out where the method is being used to save the workbook. I have managed to right-click and browse to the new version to get it to work with different versions of office.

I do not recall the details but some browsing should get you there.

Ben

[weschen]

1. I use the LV2018 and Excel2016,It's still have the issue.

2. I have reinstall the RGT package,it's still have the issue.

3. I try it on other computer(LV2013+Excel2016),It's work fine.

[Bob_Schor]

---

@weschen wrote:

1. I use the LV2018 and Excel2016,It's still have the issue.

Please respond to the following questions (we're trying to understand what you see, and how to help you):

1. Are you running LV2018 (32-bit) or LV2018 (64-bit)?
2. Can you explain what you mean by "it's still have the issue"?  
   1. Does the simple VI you attached in your first post show a "broken arrow", indicating an Error Condition before you try to run it?  If so, this is a well-known situation that we can explain how to fix.
   2. Please attach an Error Out terminal to the end of the Error Line before you try to run it.  When you do run it, what happens?  Tell us if an Error is reported, and give us the details (a screen-shot of the Error message is OK).

Bob Schor

[weschen]

1. My LabVIEW is 2018(32bit),Excel 2016.

2. when run into the workbook invoke node,it's quit the LabVIEW.

[weschen · Accepted solution]

The root reason is i have install two software for open excel(Microsoft Office 2016 and WPS Office 2019).After I had uninstall the WPS Office 2019,Now the VI is running normal(Excel 2016 with LV2011,LV2013,LV2015,LV2018 all is OK).