transferring data from excel to labview and vice versa

[Venk7337]

Friends,

 I want to get the data from Excel into the LabView..I'm kind of new to the LabView..I have a block diagram with an input array..so I have to input Excel data into that array...To do that, I'm not sure how to further build my block diagram that can automatically get the Data from the specified excel file and export back to any excel file. Please, help me

with this..Attached is my Block Diagram.

[Dennis_Knutson]

Look at the code in the previous post. If you have th report generation toolkit, look at the examples for that. Look at the examples in the Excel Board. Do a search of the LabVIEW board for 'Excel'.

[Venk7337]

Dennis,

Thank you for the advise...I appreciate that! Actually, I'm kind of brand new to LabView...If you don't mind can you work on my block diagram, I just have to import the data from Excel and export back to some other Excel file..Basically, I don't know the connections I'm suppose to make in that block diagram to do that. Please help me with that! Block diagram is on the previous post..please!!

[Dennis_Knutson]

There is no block diagram in your previous post. There is an image of one but that is hardly sufficient to do any editing. In any case, why don't you try doing something with the code first. You have the Excel file. You would need to do that before anyone volunteers to do this for you.

You could also save the Excel file as a comma or tab separated text file. Then you could use the Read From Spreadsheet File function. That's a lot simpler than using Excel and ActiveX.

[Venk7337]

Dennis,

Thank you for your quick replies...Amazing!

Actually, I have the Excel sheet that was saved in CSV format, it has just one column with numeric values...Like I said, I'm not sure how to use Read from Spreadsheet File function within the block diagram..Please help me.

[Dennis_Knutson]

Just like this.

Since you still did not post the csv file, if there are any problems, you will have to debug that.

This is pretty basic stuff. Before you try doing any more programming or before asking anymore questions, please go and take the tutorials.

[Dennis_Knutson]

sorry, forgot to attach the image.

Message Edited by Dennis Knutson on 02-05-2010 09:28 AM