LabVIEW
Error 1821, when exporting waveform to spreadsheet
Hello!
I can see you are building your path in some strange way - try to get familiar with Build Path function:)
https://zone.ni.com/reference/en-XX/help/371361J-01/glang/build_path/
I cannot actually understand what are you trying to do? Write Delimeted Spreadsheet should already write your data to the file, you don't have to write it again in Flat Sequence structure - maybe try to delete the whole flat sequence (or use Diagram Disable Structure to temporary turn it off) and check whether it works for you.
Marcin
Ahh, OK, now I think I understand that you want to write three different set of data? First in write to spreadsheet file function, second and third in flat sequence structure?
Try to clean up this fragment a little, because what I see is that you are writing to file, then reading again and then again writing...
What actually do you want to have in your CSV file? Waveform contains array of Y values, dt and t0. I think CSV file isn't the good choice here. Have you considered to save only Y values for example?
I meant remove the whole content of the flat sequence structure 🙂
As to the Not a Path - see the example which is on the website. You have to remove slash: instead of \Resumen.csv it should be Resumen.csv
Have you deleted all the flat sequence code? Think what is currently happening in your code:
- You create spreadsheet file and write there some data
- You don't close the file, you are not sure whether LabVIEW has internally closed the file and you are writing to it immediately
- Then you are reading the same data from the file and write it again
- Then you repeat step 2 and step 3.
Try to rebuild the whole saving code - starting from small pieces. First try to use only Write to Spreadsheet Delimeted File and then develop functionality - it is the easiest way of debugging.
Marcin
Why do you want to write the waveform to the file, then read it and then write it again? I cannot see the reason of such an action...
Write to Spreadsheet File function is pretty complicated because of its simplicity 🙂 It is a high level function and you don't have full control of its behaviour. Actually it should close the file immediately but I can say it is not doing so - to be sure, just wait 100 ms after this function and then you can safely assume that the file is closed.
But think about the content of the file!
You have written there some data using Write to Spreadsheet File function, then you write there some other data as a waveform - the file content is completely mixed and then you try to export waveform from the file. But how this function should know where the waveform begins? where it ends? If you want to write waveform to the file just keep it simple one waveform = one file. It will save you a lot of work. Don't mix data in a file unless you are really sure what you are doing!
