Hi everybody, I'm currently trying, after some data gathering, to put everything into a .xls file. I also need to append DE_testnumber_year (DE-XXXYY) to the file name, so the final file should be someting like DEXXXYY_nameoffile. I tried to realise this in the VI i attached. The drawbacks i encountered are : _ the user can't chose where his file will be saved ( i can't get the system directory to appear AND to chose a part of the file name) _ The data is gathered in my 1D array but when i open the file created (when i dont put any input in the "path" of Write to Spreadsheet) it is empty _ Even when i write a full path directory (which i think is correct) i get an error Do you see what's wrong with this code? Is there another way to do what i'm looking for? Thanks, Clement Z. PS : sorry for the mess this VI is, it's my testing VI

Hi Clement, Concerning the 1D array data, i don't get how i could do it differently than using the "default if unwired" mode. Use a shift register - in your outer while loop… That might be because i misunderstood the block VI : does it not create a file if the path does not lead to an existing one ? You have to ensure the file path exists before you can write a file into that path. Make sure the folder(s) exist(s)! On your filename creation problem: NEVER use strings to build paths! Use path constants and path functions!

LabVIEW

help with write to spreadsheet file

Solved!

Author

Hi,

English is not my mother tongue so i did not get the transpose input at first sight.

Thank you for your help throughout this post, it was very instructive, i think my problems are now solved.

Clement Z.

Message 11 of 11

(671 Views)

LabVIEW

help with write to spreadsheet file

Re: help with write to spreadsheet file