create new excel file from Template file

[sacsk123]

---

@PalanivelThiruvenkadam wrote:

Try to explore from the shared file so that you will get to know how it works

try this

---

I am not sure whether i did everything correctly, but above code does nothing. Sometimes shows unknown errors(may be ActiveX related) and sometimes runs but does no change to Excel files.

[Bob_Schor]

---

@sacsk123 wrote:

I tried one more option and even it looks very close..

Used "excel easy table.vi" to save the data. but the data saved is stored as 2 ROWS.

But i want the data to be stored as 2 columns as shown in attached image.

---

First, don't post pictures of code, post code itself (either a VI or a LabVIEW Snippet).  This lets us "play with" the code and prevent eye-strain.

But to answer your question, have you ever heard of the (array) function "Transpose", or as LabVIEW calls it, "Transpose 2D Array"?  That's what you need ...

Bob Schor