Write data in time intervals to excel file without opening it

[Nghtcrwlr]

Hello

I am measuring some values using . I need to write these data in to an excel file. ( WITHOUT opening the excel file. The data has to go on inserting in the excel as long as u run the VI). The data is measured continously. At every 2 minutes time, the data has to be recorded in to excel.

How is this possible?

thanks

[falkpl]

WITHOUT Opening Excel. Excel is not on the machine, you dont want to see the excel application, or you already have the file opened?

Options for writing dirrectly to an excel file are

1.  ActiveX excel objects, excel application can be opened without showing the user interface, but needs the version of excel on machine to work.

2.  Report generation toolkit, less flexable than ActiveX but most wrapper functions already provided REQUIRES ADDON Toolkit).

3.  Treat this file like a tab delimited text file, jsut append new text in tab delimited form.  Save the file as filename.xls when completed.  You can not have any excel specific formatting in this format (at least not easily) 

[Nghtcrwlr]

Hello falkpl

Excel is already in my computer. What i need is, I dont want a dialog box to pop up asking to save and all. The data should be automatically saved to an Excel sheet at a specific folder.

I tried with ActiveX excel objects , but it always asks for file path and opens the excel sheet. Also i could not save the data in the desired row and column.

Any example to save data in desired rows in LV version 7.1 would be very helpful..

thanks

[MikeS81]

Hi Nghtcrwlr,

see this link:

http://forums.ni.com/ni/board/message?board.id=BreakPoint&message.id=2391&query.id=582964#M2391

Mike

[falkpl]

This is a

function I have used for oprning excel in silent mode.  You can play with the visibility of the application I have a more updated version of the code but cant get to it right now.