how to write/read 2D array of Sting in Excel sheet using labview 7.0

[srinivasan.accent@gmail.com]

hi viru,

 so ur telling first have to create excel sheet via write 2d array to file.vi then i can change any modification in that same excel sheet createdby write 2d array to file.vi. 

when im reading using read 2d array.vi we can read the data in excel sheet with the modification also..is it correct....

and can u tell me how to do  program using activex cos... my project is related to  customer will excel sheet i have to read that excel sheet only.. so i can't tell to a customer  that create a excel sheet via labview..it wont look good for me and my company too. so what i need is customer wil give their excel sheet with data i have to read that excel sheet with my program(whether its data typed in excel sheet is manually or programmatically with labview)

pls dont mistake me for keep on asking the same question.. its cos of i didnt get the correct answer still now...forgive me...

[srinivasan.accent@gmail.com]

hi viru,

can you change this library vi to labview 7.0 pls save it in separate vi's not in library vi.

[srinivasan.accent@gmail.com]

sorry here attachment file...........

[Dennis_Knutson]

I think you've been given the correct answer - you just don't understand what has been said.

1. If a file is opened and saved with Excel, you have to use ActiveX in order to open it in LabVIEW. It's just that simple. There are thousands and thousands of posts related to Excel and LabVIEW. Do a search. Look at the examples posted to the Excel Board.

2. If a file is opened with Excel and exported to a csv or text file, then and only then can you use the Read From Spreadsheet function.