save data to excel

[tominsek]

hi, 

i need to save data to excel or csv or anything by identical shape of the multicolumn listbox. the columns needs to be included. What should i do?

[yaroxim837]

Hello!

To save data from a multicolumn listbox with its column structure intact, you need to write a script that iterates through its contents. First, you would read the column headers and write them as the first row in your Excel worksheet or CSV file. Then, you would loop through each row and column of the listbox, extracting the data for each cell and writing it to the corresponding cell in your Excel sheet or as a comma-separated string in a CSV file, thus preserving the identical shape. 

[ZYOng]

Use Column Header Strings[] property.

[GerdW]

Hi Tim,

---

@tominsek wrote:

i need to save data to excel or csv or anything by identical shape of the multicolumn listbox.

---

You use the WriteSpreadsheetFile functions…

(You already have string array data available for your MCLB.)

---

@tominsek wrote:

the columns needs to be included. What should i do?

---

I guess you mean to include the column headers…

Write the headers once when you create the file.

Write the MCLB content (items) after you wrote the header…

---

@tominsek wrote:

What should i do?

---

What's wrong with the code in your images?

Do you encounter any errors or problems?

[tominsek]

yaroxim 837

do you maybe have some example how to do that and what should i include?

[tominsek]

hi gerdw,

can you send me an example?

yes i get data written like this(image)

[tominsek]

ZYOng

If i make like this, its not okay because data are written like that (image)

[GerdW]

Hi Tim,

---

@tominsek wrote:

can you send me an example?

yes i get data written like this(image)

---

I guess "yaroxim" probably is just (AI-generated) SPAM…

When the data doesn't appear in the right order then you did something wrong.

Unfortunately you didn't post any code so far: why don't you attach your VI (or a simplified VI) with some example data?

Are there any "end of line" chars in your MCLB items?

[tominsek]

hi gerdw, 

here is my vi, if you can take a look and alert me to irregularities.

below is photo of my MCLB

i read data from SQL to MCLB and from that MCLB when button is pressed i saved them to excel thats it.

[GerdW]

Hi Tim,

mind to downconvert for LV2019? Thanks!