create excel file from 2D array

[SAED123]

Hello all,

can someone guide me if I'm on the right way or not I have problem with the excel file the data not in the same row??

thanks a lot 

[Artem.SPb]

For work with real Excell you need report generation toolkit.
Without it you can use "Write Delimited Spreadsheet VI" and then convert this file into real xls format

[Jean.L]

Hello Saed123,

Just remove the string constant "/n". The default separator is already a tabulation. That should work for your excel file.

Regards,

[SAED123]

@

 Jean.L

can you explain more cause i don't understand what do you mean??

Thanks-

[Jean.L]

Just remove the string constant.

Regards,

[Bob_Schor]

The file you attached, "backup_1.xls", is not an "Excel" file, despite having the (logically-incorrect) extension .xls.  If you examine it with a Text editor, you can see that it is all text, but with a very strange format:

• The first line is in tab-delimited format:  "Freq<tab>phase<tab>Z<CR><LF>", where <tab> is the Tab character, 0x8, <CR> is Carriage Return, 0xD, and <LF> is Line Feed, 0xA.  The pair <CR><LF> is the usual PC "End-of-line" Ascii string.
• The remaining lines of numeric data are just messed up.  They are almost in the same Tab-delimited format as the header, except each number as an extra <CR> after it.  So if the data were the numbers 1, 2 and 3, the line would read "1<CR><Tab>2<CR><Tab>3<CR><CR><LF>".

How did this code get written?  If it was written by LabVIEW, then someone wrote a bad "logging" routine (and put extra <CR> characters after the numbers).  Otherwise, you have the makings of a nice Tab-delimited "Spreadsheet" (not Excel) file that LabVIEW can easily read using Read Delimited Spreadsheet".  Note that this file format is closely related to the Comma-Separated Variables (or .csv) format, which Excel "appropriates" by forcing an Excel-like Icon for these files (and causing confusion in people such as yourself who think these text files are "Excel").

Bob Schor

[SAED123]

Jean.L 

i remove it but nothing happend 

regards

[Jean.L]

Here is the vi I modified to make it work.

Could you confirme it's ok?

Regards,

[SAED123]

sorry Jean.L still no changing 

---

@Jean.L wrote:

Here is the vi I modified to make it work.

Could you confirme it's ok?

Regards,

---

[GerdW]

Hi Saed,

did you do any of the suggestions on your own?

Try this:

I don't claim to create "efficient" code, but that should work!

Note that subtle change of the filepath constant…