Manipulation of Excel file

[Baran]

Hi,

I want to put some of the results of my labview program in an existing excel file. For example put couple of numbers in some specific places and probably some plots in the excel file. I know I should use ActiveX, but I have not worked with it before. I was wondering if anybody knows how to do that. 

I have found some examples in previous discussions that copies some data from an excel sheet to another (attached), but I am not familiar enough to change them to what I want.

Thanks.

[aeastet]

Look in this tread. It has many different helps for Excel and Active X.

http://forums.ni.com/t5/BreakPoint/Excel-Board/td-p/379682

[Baran]

Thanks. The posts were pretty helpful. 

I am trying to figure out how to open an existing excel file and put a number in a specific cell. To start I just made this VI (based on the posts) and tried to get number of rows and columns. But it just shows me 1 and 1. Do you know what is the problem?

Thanks.

[wond3rboy]

Hi, its very easy doing it with the report generation toolkit. Gives you way more flexibility. Heres the VI in LV 8.5. It will  require the report generation toolkit to be installed though.

[Baran]

I have LV basic, and it doesn't have the toolkit. 

Thanks though 🙂