Inserting data into Excel to a specific cell

[Pipecheverri]

I am trying to insert four numbers into four specific cells in Excel.

I don't have the Report Generation Toolkit... Is there a way of doing this without this toolkit?

Thanks in advance,

Felipe

[tst]

Look for excel examples in the example finder. They show you how to use ActiveX to control excel.

[Dennis_Knutson]

You shouldn't have to look any further than the shipping examples. There is one called Write Table to XL. In there is a subVI called Set Cell Value.

[Pipecheverri]

The way they are doing it in the LabVIEW examples, they are opening the Excel file and also closing it.  I want to be able to just write to the Excel file and only modify that cells I want.  I am also having trouble with the Excel Worksheet Refnum.  Why can't I just wire the Excel file name such as C:\ABC.xls

Right now I have an Excel file that has on column "A" four different number (rows 1,2,3,4).  I want to take each of these numbers on cells A1, A2, A3, and A4 and put them in another Excel file on say for instance cells B4, C5, D3, and F8.

I would appreciate if somebody could guide me on how to do a what seems to be a simple task...

Felipe

[Dennis_Knutson]

Editing a native xls file is not a simple matter. Open one with a text editor like notepad and see if you can easily decipher it. If you want simple, save your Excel file as comma or tab separated data. This will be a pure text file that is much easier to edit.

As far as the worksheet refnum, that's the way the property is defined by Microsoft.