Export data to excel does nothing - Windows 10

[nickbike]

This snippet does absolutely nothing on my computer

[JÞB]

What is on the clipboard?

Wrong method to get the data to Excel friend 

[nickbike]

---

@JÞB wrote:

What is on the clipboard?

Wrong method to get the data to Excel friend 

---

Ah yes, sorry. I had both the Export to Clipboard and Export to Excel methods in there. To simplify I just deleted one of them. Neither method works. 

[JÞB]

---

@nickbike wrote:

---

@JÞB wrote:

What is on the clipboard?

Wrong method to get the data to Excel friend 

---

Ah yes, sorry. I had both the Export to Clipboard and Export to Excel methods in there. To simplify I just deleted one of them. Neither method works. 

---

Please show your code that doesn't work. 

[ikaiser]

Just in case this is helpful: Using Jeff's snippet, both methods work here as well. I am using LabVIEW 18.0f2 32-bit, Excel 365 MSO (16.0.11001.20064, 32-bit), and Windows 10 1067 (14393.2248) 64-bit.

[nickbike]

---

@JÞB wrote:

---

@nickbike wrote:

---

@JÞB wrote:

What is on the clipboard?

Wrong method to get the data to Excel friend 

---

Ah yes, sorry. I had both the Export to Clipboard and Export to Excel methods in there. To simplify I just deleted one of them. Neither method works. 

---

Please show your code that doesn't work. 

---

Neither of the code snippets below work on my computer. When I execute either of these snippets, nothing happens and no error is returned in the error cluster.

[RavensFan]

You talk about Excel 365.

Do you actually have Excel installed on this PC?  Or is this one of those cloud-based versions where you are getting to Excel through a browser?

[nickbike]

---

@RavensFan wrote:

You talk about Excel 365.

Do you actually have Excel installed on this PC?  Or is this one of those cloud-based versions where you are getting to Excel through a browser?

---

Good question. Excel 2016 MSO (16.0.9126.2336) 32-bit is actually installed on this machine.

And let me walk back a key point that I just realized. The Export to Clipboard IS working. I thought the Export to Clipboard had previously (on my old PC) opened Notepad and showed the data that was exported. It does not do that, I just tested this on an old PC and it only does the export, you have to manually paste the data into another program. I hope that clears that up and that was my mistake in recalling the behavior of Export to Clipboard.

However, the Export to Excel is still not working. In that case using the programmatic method OR the Right-Click menu the export is not happening. I just tried this on an old machine with Windows 7, LabVIEW 2017 and Excel 2010 and when you use the programmatic method OR the Right-Click menu Excel is opened and the data is pasted.

The most frustrating part is there is no indication from the error cluster or anywhere that it didn't work. I have tried having Excel open before executing the method and it still does not work. 

At this point it seems to be a problem with my particular company's more recent computer builds. To even further complicate things I just checked with another LabVIEW developer that got a new computer a few weeks ago and has LV 2018 installed and they are NOT having this Export to Excel issue. My favorite bug, the one that gives no error and is not present on seemingly identical systems. 

[Bob_Schor]

Hah!  I never knew about this Invoke Node before.  I prefer using the RGT, but this actually worked when I tried it (Windows 10, LabVIEW 2016, Office 365 (this is a new PC for me -- I've never used Office 365 before, and don't yet know if I like it ...).

Bob Schor

[nickbike]

---

@RavensFan wrote:

You talk about Excel 365.

Do you actually have Excel installed on this PC?  Or is this one of those cloud-based versions where you are getting to Excel through a browser?

---

That's a good question. I do have Excel 2016 installed. I even tried to have Excel open already.

I also want to correct a mistake I made. I thought the Invoke node and the Right-click Export to Clipboard popped up Notepad on my old computer. I just tested it on a similar old computer and it didn't do that. It only copies the data to the clipboard it does not open and paste. I tried it on my current computer and the Export to Clipboard invoke node and right-click menu do work. I'm sorry for this mistake.

However, the original issue, Export to Excel, does not work either through the Invoke Node or through the Right-Click menu. The worse part is that there is no error reported. And even worse, I have a colleague that just got a new computer, LabVIEW 2018 and Excel 2016 and this works fine on his computer.