how can I write my results to excel in one sheet in perticular row?

[mrdesai88]

Hello everyone,

I am new in labview and I have a problem.

I found my results , It is in 2D array... It sometimes in 1D array because I will remove the header row.

How can I write my results one by one in succeding row?

I attached hereby the excel sheet where I have to write my results.

There are approximately 25 result so I have to run my VI 25 times but the result will display in excel sheet in 25 succeding row.

Hope u get my question...

Thank you  

[GerdW]

Hi mrdesai,

to work with your XLSX file you will need to use ActiveX or the RGT (which too uses ActiveX)…

Things would be so much easier when you would stick with CSV files instead!

[mrdesai88]

OK.

But my company requirement is , I have to write results in excel. They already have the format in excel.

Can you show me both way ? how to write file with excel and csv?

[mrdesai88]

Is that possible to write results like that?

[GerdW]

Hi mrdesai,

search the forum for "Excel ActiveX" and look up the LabVIEW help for "WriteSpreadsheetFile" to find suggestions for both possibilities.

Please be more specific when talking about "Excel files": Excel has no problems to work with CSV files even when those are simple text files in contrast to proprietary XLS/XLSX file formats…

[mrdesai88]

Hello,

I have a 2D array and its a String... I want to write my result in xlsx format.

And I also have 1D array and its double.. This is also I want to write in a xlsx format.... 

And these both result I have to write in 1 excel sheet in xlsx format but in different table... 25 times I have to run my VI as I mention earlier and 25 results I want to write in excel sheet one by one in succeding row.

Thank you very much for your previous solution .. but I dont understand how to put all values

[GerdW]

Hi mrdesai,

there was no solution, just suggestions.

When you insist on XLSX file format you will have to use ActiveX communication to an Excel installed on the same PC as your LabVIEW VI. There are many threads here in the forum discussing the same problem, you only need to read them!

[mrdesai88]

Dear GerdW,

I am really not understand the concept of ActiveX... I working on labview since last november and I never heard about that.

If you have a VI for that solution then please put that.. This is the last step of my project and I am not able to solved it. 

Thanks in advance

[GerdW]

Hi mrdesai,

if you never have heard of ActiveX you might have a hard time to automate Excel using ActiveX.

Well, you could start by googling for "ActiveX Excel LabVIEW" to get a starting point…

[mrdesai88 · Accepted solution]

OK..

I will surely do that...