Execl write to location

[vamsi539]

I'm using the Channel Monitor.vi(from Ni example) to monitor the Bus.I would like to monitor 2 Messages and log the values to an excel sheet.I'm using a modified version of Write_to_Spreadsheet.vi to write to an excel sheet.

Is it possbile to write to a specific location in the Excel sheet. say Start at Row X-Column Y ? The Write_to_Spreadsheet.vi always writes from the location (0,0).

Thanks

-Vamshi

[tbd]

Hi Vamshi,

      To write to a specific location of an Excel sheet you'd probably use ActiveX functions (or possibly .NET functions.)

Use of ActiveX can carry some portablilty problems, and since the file you're working with is a tab-delimited text file, you might avoid the ActiveX stuff with a little 2D array manipulation.  See example attached.

Cheers!