write to excel 2013 file

[mangood]

dear member

 i have this LV 2012 VI that has two inputs and two outputs

i want to record them in EXcel file

as following in each row

seed1 seeed2 mean variance

and in my case thier will be about 200,000,000 rows in the excel file

 the VI http://www.4shared.com/file/TJzJCb-B/seed1seed2.html

here du to that NI attackment error whith the following "The contents of the attachment doesn't match its file type"

i try to use .rar but same thing

any change in my Vi will be appreciated

please i need help in this

 

[KateB]

You can find an example for writing to Excel in https://decibel.ni.com/content/docs/DOC-2081. However, Excel limits row to 1047568 row/sheet. You may need to separate data into multisheet.

[altenbach]

As mentioned above, Excel is out, because of the row limit.

What is the purpose of the file. Does it need to be read by other programs?

Writing 200 000 000 rows should NOT be done in ASCII or excel, but should be saved as a binary file. Much less overhead!

[mangood]

---

@altenbach wrote:

As mentioned above, Excel is out, because of the row limit.

What is the purpose of the file. Does it need to be read by other programs?

Writing 200 000 000 rows should NOT be done in ASCII or excel, but should be saved as a binary file. Much less overhead!

---

thank you for advise

[mangood]

The item does not exist. It may have been deleted.

---

@KateB wrote:

You can find an example for writing to Excel in https://decibel.ni.com/content/docs/DOC-2081. However, Excel limits row to 1047568 row/sheet. You may need to separate data into multisheet.

---

[RavensFan]

The link was corrupted by the period at the end.

The correct link is https://decibel.ni.com/content/docs/DOC-2081

PS:

What does "hi ?Q>" mean in your signature?