03-08-2010 12:58 PM
No, no, no!
You've been told that you cannot use the Read From Spreadsheet function with a native excel file. Either save the excel file as comma or tab separated text or use ActiveX function to read Excel. You have no other options so please pay attention to what has already been said.
03-08-2010 01:18 PM
03-08-2010 01:29 PM
03-08-2010 01:42 PM
You should be able to invoke an Open document node (or similar) and wire your file path to that. (i dont have office at home)
03-08-2010 01:50 PM
03-08-2010 02:06 PM
Help Menu
Example Finder
Search
ActiveX
Write Table to XL.vi
Look inside the subVI's.
03-08-2010 02:20 PM
Hello Ravens,
That example Is writing the.xls file from .vi. but, I need to write the .xls file to .vi to plot the graph between specified coulmns and shouold start from 24th row in the excel file. You see that ecel file here I am attaching
03-08-2010 03:05 PM
Look inside the SubVI called Set Cell Value. Instead of writing a cell value, change that property node from Write to Read. Attach an indicator to it instead of a control as it is now.
Now with that bit of code (save as a new subVI since you don't want to accidentally overwrite the example) you can Read from a particular cell in Excel.
03-08-2010 03:20 PM
03-08-2010 03:27 PM