How to populate the last empty row in Excel without using Report Generation Kit

[Shep_Ametek]

I wrote  a Labview SUb Vi that uses Report Generation Toolkit that is not loaded on the test stand. I am looking to convert it from Report Generation Vi like New Report,  Append Table to Report, Dispose Report. The tunneling through all the report generation Vis seems extensive. Code is attached. Thanks, Greg

[RavensFan]

Your attachment is missing.

Look in the thread Excel Board.  It is a list of links to other threads containing useful information to interact with Excel using ActiveX

[Shep_Ametek]

Thank you that was a big help...

I used the Excel Forum to get a lot of great ideas.  My code is almost working.

There is a 2-D String Array that represents the String data that I am exporting to the Excel File Sheet 1 - 5.

I am attempting to determine the last populated row in sheet 1 then populate the next row of Sheet 1.  Since all 5 sheets are populated every time, I should not have to search every sheet for the last row.

I am getting two row populated on sheet 1 with seeming the same data.

 I found an AXExcelWrite2D ArrayWorksheet.vi that I thought would work.  I think there is a Table  determination that is causing me problems.  The link is http://lavag.org/topic/13324-labview-and-excel-activex-or-ado/.  The Application Invoke Node has a convert formula with "FromReferenceStyle" with R1C1 Attached to it.   I am not sure what this function is doing.  When I try to bring the function help up, there is a missing file.

I am including both the new active x vi and the report generation vi.   Report Generation VI works.

I would appreciate any assistance I can get on this.

Thanks

Greg

[Shep_Ametek]

I found a solution that works. The Excel Thread Example had an Invoke Node for Determining the Active Cells ( See Previous Post).  My array did seem to be compatiable with the invoke. I was getting Unknown Error.  I changed the ACtive Cel Determination Method so I am able to populate the cells as required.

[Shep_Ametek]

I am unable to attached the file. Sorry.

[GerdW]

Hi Greg,

you have to rename the VI files to *.vit or you can zip them.

This problem exists for quite some time…