read excel sheet and save the data in same excel file

[prifx2]

  Hi all , I need to build a VI in labiew which reads excel file and the data (number ) in column1 to be added to data (number )  in column 2 and saved in the same Excel sheet file .kindly help me I refered all the examples but didn’t find for me any suitable kindly help me it is very urgent

[MikeS81]

Hi prifx2,

see this link please

http://forums.ni.com/ni/board/message?board.id=BreakPoint&view=by_date_ascending&message.id=2393#M23...

There should be something helpful for you.

Mike

Message Edited by MikeS81 on 04-29-2009 08:55 AM

[prabhuvijayakumar]

The attached files shows how to read and write from an Excel file.

[Gak]

hi ,

I am giving you solution of your problem. I think this is what you want.

[J.Mamakos]

I don't know if this'll help you at all, but it's a VI that I made to handle writing single cells, ID arrays, or 2D arrays of strings, numbers of formulae into excel.  It needs the Excel._Workbook reference (which is carried through), then you specify the name/number of the sheet within the workbook and the top left cell (by row and column) of the area you want to write to.  For arrays, there is the option to transpose (flip x and y orientation) the data.  Unfortunately, (this may not apply to all versions of LabVIEW and Excel) formulae can only be written in cell by cell.  Single cells and 1D arrays input to the same place, and 2D arrays have a separate input (do not connect to both inputs at the same time).  You do need to specify the type of input (string, number, formula) since I have not found a way to automatically detect this (I cannot create polymorphic VIs).

I hope this helps in some way.