Problem with writing spreadsheet

[dony_92]

Hello,

Guys can anbody help me with this thing, I have problem with writing spreadsheet file. I am upload picture of my program in LabVIEW.

When I run program everything working as well and excel file is filled with data I saw size of file how rising. But when I want to open file to check I got this message in "pic2". 

So can anbody help me what should I do ? Is problem in my LabVIEW or ? 

Many thanks in advance.

[GerdW · Accepted solution]

Hi dony,

easy answer: don't use the suffix "xlsx" for your spreadsheet file. Use "csv" instead -  because that is what you create!

[crossrulz]

You cannot write an xlsx file.  That is some propriatary format that Microsoft uses.  Since you are use a comma as your delimiter, save your file at a csv.

[dony_92]

Thank you a lot ! Its working now.

But check this now, from 38 row start to write. What could be this until 38 ?

[dony_92]

Thank you a lot ! Its working now.

But check this now, from 38 row start to write. What could be this until 38 ?

[GerdW]

Garbage…

Have you overwritten some older (already existing) file?

Please provide as much information as possible!

[dony_92]

No I make new excel file and change format from .xslx to .csv as Test.csv. Take this as file path and run program, but when I open again same thing, is there any chance for example to make some loop and to write every 5 minute value, maybe this garbage is generated until my signal is come to the write spreadsheet ?

[crossrulz]

Since you are just constantly adding on the file, you are just seeing Excel's attempt at fixing the file from before.  You really should have your program create a new file each time it is ran.

[crossrulz]

---

@dony_92 wrote:

No I make new excel file and change format from .xslx to .csv as Test.csv.

---

Don't do that.  When you create an Excel file, it has stuff in the file that just looks like garbage (it really is data that Excel needs in order to read what is in the xlsx file).  What's wrong with just letting your program create the file?