LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Trouble with Writing to spreadsheet file

Hi there, I encountered some problem while trying to write to a spreadsheet file. But when I tried to open the file, nothing was written there. Would appreciate your help,thanks.Untitled.png
Untitled.png

0 Kudos
Message 1 of 16
(3,866 Views)

Share Actual Vi/Snippet instead of Image.

 Did you got any error?

Are you sure data is being generated before writing to a file (can probe and check)

----------------------------------------------------------------------------------------------------------------
Palanivel Thiruvenkadam | பழனிவேல் திருவெங்கடம்
LabVIEW™ Champion |Certified LabVIEW™ Architect |Certified TestStand Developer

Kidlin's Law -If you can write the problem down clearly then the matter is half solved.
-----------------------------------------------------------------------------------------------------------------
0 Kudos
Message 2 of 16
(3,862 Views)

Hi, sorry about that. Here's the VI.

0 Kudos
Message 3 of 16
(3,858 Views)
To be sure that you are writing some data to file, check by keeping an indicator/probe to the array input.
- Also make sure the file path is correct and you have read/write permission to that file.
Thanks
uday
0 Kudos
Message 4 of 16
(3,856 Views)

I checked piece of your code by feeding inputs of my own, it works fine.

Make sure about your data, whether any data is being transfered to input node of Spreadsheet VI.

 

----------------------------------------------------------------------------------------------------------------
Palanivel Thiruvenkadam | பழனிவேல் திருவெங்கடம்
LabVIEW™ Champion |Certified LabVIEW™ Architect |Certified TestStand Developer

Kidlin's Law -If you can write the problem down clearly then the matter is half solved.
-----------------------------------------------------------------------------------------------------------------
0 Kudos
Message 5 of 16
(3,835 Views)

Now that I tried creating a new file in a new location and there's this pop-out. However, I'm sure that I've saved it to the correct location.

0 Kudos
Message 6 of 16
(3,829 Views)
As suggested in error description just copy the file path and paste in file explorer or in run command and check if the file path is correct.
-One more easier method is right click on path constant browse for path and point to file.
Thanks
uday
0 Kudos
Message 7 of 16
(3,823 Views)

You dont need to create a file, Write to spreadsheet file will create new file by default, if the file is not present

----------------------------------------------------------------------------------------------------------------
Palanivel Thiruvenkadam | பழனிவேல் திருவெங்கடம்
LabVIEW™ Champion |Certified LabVIEW™ Architect |Certified TestStand Developer

Kidlin's Law -If you can write the problem down clearly then the matter is half solved.
-----------------------------------------------------------------------------------------------------------------
0 Kudos
Message 8 of 16
(3,814 Views)

Hi,

where exactly do you have your VI running? Which target system do you use?

 

Is it by any chance a RT target (like cRIO, myRIO)? You know those are "stand alone" computers on their own with NO access to your PCs harddrive?

Best regards,
GerdW


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

Hi PalanivelT, I've tried all the suggestions, everything seems fine, but, still not able to read into spreadsheet file. I've also tried changing my input data to random number, still nothing is write in.

0 Kudos
Message 10 of 16
(3,807 Views)