data is entered in columns A,B,C of excel. Suddenly its all in column A

[cope]

My labview application sends my data of force, distance and time to columns a,b and c of excel.  Suddenly it is showing up only in column a seperated by comas.  How can I fix this?

[Havarti]

Cope,

I am just guessing because you didn't describe your vi at all but you are probably using the Write to Spreadsheet vi, correct?  You need to connect a tab constant to the delimiter input of the VI.  This will cause the tabs to be placed between each element of data and should open up right in excel.  If this isn't the correct solution attach your vi or explain more how your vi works.

Brian

[devchander]

Either you are saving it without a proper delimiter

Or you are reading it without specifying delimiter/specifying wrong delimiter to

read elements form the file

[cope]

The IT guy who wrote this program is long gone and I just use the equiment.  I don't have any programing experience with labview although I know enough to be dangerous, which is very little. The program runs a sled with a load cell attached to measure pulling or pushing force. It sends force, distance traveled and time to excel.  The program sends this to columns A, B and C in excel.  I have used this program for several years and it always worked ok.  Just the other day it started to put the data in one column seperated by comas, it never did this before.  I also have 6 labview programs (which must all run through the same main program) and all six have the same data problem and before last week they all worked ok.  No changes were made, at least not knowingly.  I looked at the VI heirarchy but can't identify the portion that writes to excel.

Cope

[cope]

Hi Everyone,

OK I just solved the problem.  The delimiter issue is correct.  However it was not in the Labview program.  I have six programs that all of a sudden strated having column problems in excel.  When I run the program I click on an exicute button. A box appears where wI write the file name to save the data.   The file name has to have a excel identifier after the file name.  For example  teat.csv.  If I leave off the .csv the file will not open in excel.    Instead of using test.csv we used test.cvs.  This small error caused the delimiter problem. 

Thanks for you help.


Cope