Header + data to spreadsheet file

[appala]

Hi All,

I am trying to write header + data as shown in the image

It works fine, but the problem is at the start of each array it is creating one tab as shown in the "output file.jpg"

could you tell what mistake i have done

Thanks

[Santhosh M · Accepted solution]

Hi Appala,

In write spreadsheet file.vi converts array input to string by using Array To Spreadsheet String.vi default it convert array to string with Tab delimiter so you getting tab in spreadsheet file. I am attaching one jpg file that will work.

[appala]

Hi Santhosh

It worked

Thanks

Message Edited by appala on 03-25-2009 03:19 AM

[MrDoc]

Hi,

I have a similar problem.

I have a header generating sub vi and then this and data are to be written to a spreadsheet.

If I only write the header it works.  If I allow the vi to run and get data, I get no header.

Also all data is entered in the first cell, and the file is not a excel file.

I am using a comma as a delimiter.

I am not that experienced in Labview yet, but I don't see a problem with this.

  

[RavensFan]

It would be best if you started a new thread and posted your actual VI.  It is hard to debug a shrunken image of your block diagram.  And the assortment of broken wires don't tell us anything either.

Write to Spreadsheet file doesn not create an Excel File.  It creates a text file that is delimited in a way that a spreadsheet program like Excel can open or import.

If all the data is being entered into a single file, you probably do not have the import process in Excel looking at the correct delimiter.  I find with Excel you have to explicitly tell it to use a comman when you import the data.

[MrDoc]

Your replay tells me what I need to know. 

No where did I find that the file is not saved as an Excel type file.

If I open Excel and then the file it's a bit differenct than if I open the file using Excel.

Sorry for the bad pics, but I don't have a way to make a jpeg.

[appala]

Hi MrDoc

Could you post the vi's

so that we can understand your problem distinctly

Regards

[RavensFan]

---

MrDoc wrote:

Your replay tells me what I need to know. 

No where did I find that the file is not saved as an Excel type file.

If I open Excel and then the file it's a bit differenct than if I open the file using Excel.

Sorry for the bad pics, but I don't have a way to make a jpeg.

---

Did you see some place that said that it DID save it as an Excel file?

To make a jpeg, put your screenshots into Microsoft Paint.  Then you can Save As to a JPEG.  Then attach that file to your message.