How to read cells in excel sheet while run time

[Nithu]

Hi,

   Anyone have solution for my problem plz provide me ASAP.

Actually I want to open excel sheet,visible to user, from that excel sheet i need to select rows & columns,then stored into table in lab view.

IAnd one more thing then close the excel sheet.

Thanks & Regards

[MikeS81]

Hi Anitha,

this should help you http://zone.ni.com/devzone/cda/epd/p/id/2231

Mike

[Nithu]

Hi Mike,

   In this example defined the range;but i don't want like that.

For example first step open the excel sheet,visible to user,through hand i need to select from opened excel sheet,and stored into labview,then close the file.

Thanks & Regards

[MikeS81]

Hi Anitha,

if i understand you correct you want that the user select the Data stored in LabView manually, right? For that you can define a Callback function.

Mike

[Nithu]

Hi Mike,

  Yes ur right.How to do callback function,can you plz explain little bit clear.

Thanks & Regards

[MikeS81]

Hi Anitha,

there is a function to define callback functions in the ActiveX part of LabView. An example is available in the example finder. Search for callback. One of the examples is with Excel.

Mike

[Nithu]

Hi Mike,

  I don't want this way.For example in my excel sheet sunday,monday.....friday are stored in first colum.

Now in labview i opend that file with mouse i will place on sunday then that sunday automatically stored into labview .like that all one by one or all i need to store.

Thanks & Regards.

[smercurio_fc]

I'm sorry, but there's clearly a language issue here. What do you mean "automatically stored in LabVIEW"? Is it supposed to go into a table, a string indicator, a variable, ... ? Also, what does "like that all one by one or all i need to store" mean? Do you mean that if someone clicks on an individual cell then that cell's contents should be transferred to LabVIEW, or if the user selects a range then that range should be transferred to LabVIEW, or neither, or both?

[Nithu]

Hi Mike,

    If user clicks on an individual cell then that cell's contents should be transferred to LabVIEW & stored (table/string indicator/ variableor)& also if the user selects a range then that range should be transferred to LabVIEW.Both way I need.

Thanks & Regards

[MikeS81]

Hi Anitha,

i understand what you mean. Here is an example with the callback you need. To test it, create a new workbook or open an existing one and click into the cells.

Mike

Message Edited by MikeS81 on 04-03-2008 04:15 PM