table read write

[AEC ENGINEER]

Hi,

I am tring to import data from excel file into a table. the user should modify the data in the table, then export the data again into another excel file. i dont have any problem to import/export data from/to excel file.

the problem how i can use same table as control/indicator???

I am looking for your support please.

thanks and best regards,

FAHAD

[GerdW]

Hi Fahad,

that's what locals are good for!

Make the table a control. After reading the excel file write the data to a local of the table, before writing the file back you can read from the control...

Message Edited by GerdW on 09-09-2009 04:15 PM

[AEC ENGINEER]

thanks for your assistance.

did you mean "local variable"??

other thing, how i can modifiy the contents of the table while it is running. the cell look like locked while the VI is running?

Thanks so much for your help and assistance,

FAHAD

[Cory_K]

To create a local variable, right click the control (or indicator) and go to

Create >> Local Variable

If you right click the local variable, you can change to read/write depending if you want it to act as a control/indicator respectively.

[GerdW]

Hi FAHAD,

when I do it like this I can edit the table:

Write to the local once to initialize, then do editing in the loop, then write the final content...

[AEC ENGINEER]

Thanks Mr. GerdW.

[AEC ENGINEER]

dear,

the above way is suitable in case of no previous values in the table. but in my case already the table contains a values. i tried many times but in all times it is not works.

could you please help me with an example with reading values from Excel sheet then edit those values then send it back to excel.

[GerdW]

Hi Fahad,

replace the empty array constant by your "reading some Excel values" routine and you're done

[AEC ENGINEER]

Hi,

in the attached file , how i can link "all rows" variable with "table"

could you please modifie the VI to be clear for me.

Thanks in advance for your assistance,

FAHAD

[Dennis_Knutson]

Why did you create the local variable 'local rows' in the first place?

To fix it, just left click on the local and select 'Table' to link it to that  control.

Please check the free LabVIEW tutorials.