writting to an specific spreadsheet of an existing excel file.

[fgarcia]

I need to write a labview 2-D array of real numbers to an specifc spreadsheet of an existing excel file (which has many sheets and is located in my hard disk).  

Some years ago a member forum wrote a nice and small code for writting to excel.  The code is http://forums.ni.com/ni/attachments/ni/6170/107/1/Excel.vi and was posted here http://forums.ni.com/ni/board/message?board.id=6170&thread.id=105

I found that it would be useful after some modifications. How to modify it in order to get what I need?  (Obs.: My LabVIEW version is 8.0)

Message Edited by fgarcia on 02-06-2010 08:39 AM

Message Edited by fgarcia on 02-06-2010 08:40 AM

[ben64]

There is a function to do that in the Excel specific VIs palette of the Report Generation Toolkit. Of course you need to have the toolkit installed. You can also use the invoke and property nodes on the Excel object but you have to find out what are the appropriate methods to use and propriety to set (you should find the information in an Excel programming manual. in VBA it is something like worksheet("Sheet2").Select). You can use the Workbook OPEN method to open the Excel workbook saved on you hard disk (connect your file path to the Filename input of the invoke node).

Ben