I want to write 2D array to specific colums/rows in excel

[at2bob]

I found a good LLB for retrieving a 2D array from specific cells from a specific worksheet and used that as a template to write to excel.  I just do not know how to actually get the data written down.  I've looked at the WriteToSpreadsheet VI but I do not see how i can write to a specific cell group.  Please advise and if there is a simplier way that would be appreciated as well.

[aputman]

Check out this link and see if it is what you need.

http://zone.ni.com/devzone/cda/epd/p/id/4523

[at2bob]

i looked at that but didn't see how i could specify a starting column/row, i'm very new to LabView and it is probably easy to modify, I will spend some time on it and get back, thanks

[aputman]

Rather than "get" the active cell, you will need to "set" the active cell.  In the example below, I am activating cell 1,1 which is converted to A1.

[at2bob]

that looks easy enough, thanks

[at2bob]

i'm going to be calling this VI from TestStand so i tried to remove the event structure and set an active sheet, i also removed the "make visible" part for excel, i cannot seem to get my data to appear at all let alone in the correct cell

[Charles_CLA]

You retrieved the sheet specified but did not select it (or do anything with it). Your code attempted to continue on the worksheet that was selected by default. Additionally, the code you were given is EXTREMELY slow for writing an array to a range. Use both the Cell1 and Cell2 properties to get a reference to the entire range then set the value, once. The attached VI should work and be considerably faster.

[at2bob]

i get this error code: -2146827284  Unknown System Error in ExportToExcel_new.vi out of the Worksheet invoke node that contains the cell range, i added a close to close the excel app (hopefully did it right)

[aputman]

Don't use 0,0.  The cells start at 1,1.

[Charles_CLA]

---

@aputman wrote:

Don't use 0,0.  The cells start at 1,1.

---

Good point, I presumed that either test stand was wiring in a non-zero value or the Convert Cell (that was not included) was handling that case. I also missed adding the array size to the start cell. See attached...