HOW TO EXTRACT DATA FROM SPREADSHEET?

[Mr Wise]

Good morning guys... I need to extract data from an excel spread sheet is there anyone who can be able to help me?

rgds

thulani

[BCL@Servodan]

Hi.

Have You tried searching the LabView Examples???

[Mr Wise]

I tried but can`t get exactly what im looking for...

[MikeS81]

Hi 1235,

what about the "read from spreadsheet file" function. Or do you mean a "real" *.xls file. If yes you can use ActiveX functions.

Mike

[BCL@Servodan]

What exactly are You looking for then.

A more Thoroug description than "Need to extract data from Excel" would be nice.

Message Edited by BCL@Servodan on 05-29-2008 02:27 AM

[BCL@Servodan]

Hi again.

Try this attachment, it might help.

Message Edited by BCL@Servodan on 05-29-2008 02:34 AM

[Mr Wise]

hi Mike...will try to it in that way. the fact is that im still new in labview environment. i`ve been told to log data into a spread sheet, yes i can do that, but it continues saying that after the data has been logged you must be able to extract certain values and send it to another spread sheet.

[MikeS81]

Hi Mr Wise,

what will you try, "read from spreadsheet" or "activex"? Can you explain? Can you upload your vi? What type of values do you want to write, strings or numbers?

Mike

[Mr Wise]

thanks. The information that I want to extract is a string, let me send you the file so that you can see exactly what am I trying to say....Attached is the file.

[MikeS81]

Hi Mr Wise,

how long will your loop "normaly" run? You can build an array of your data which you want to write to the file. Use the autoindexing function of the loop for it. Then you can use the "write to spreadsheet file" function, there you can connect directly your array. Which version of labview do you use?

Mike