excel

[bnt19]

hi.

i am accessing data from excel into my vi . how can i edit the array table data during runtime and save the same in excel sheet.

i am successfully accessing and displayed data in array . but i can't able to edit and save the data during runtime.and edited data i need to save into excel. please tel me the solution .

thanks in advance.

basavaraj

[srikrishnaNF]

Hi Basavaraj,

  Ofcourse you can edit the table during run time and can write the data again to excel.Please follow these steps:

  1)Read the data in your excel sheet to a table control..(I think you could be able to do this).

  2)Now create a subvi which will act as some pop-up over which you could be able to edit the same table data..Design the front panel of that pop-up so that there should be some OK button or similar kind,so that you can press that button to save the whole data in the table to the same excel sheet.

Regards,

SrikrishnaNF

[Frabto]

Addition to that to save the data in excel sheet you can see examples in the forum

 http://forums.ni.com/ni/attachments/ni/170/650989/1/ExcelExamples.llb

[srikrishnaNF]

Hi Frabto,

  Instead of using these Excel sheet examples,better he can use a CSV file where reading of the data is easy compared to excel sheet.

Regards,

SrikrishnaNF

[Frabto]

SrikrishnaNF,

   When we want to write/read specific cells we have to use these vis( that uses Activex).

[bnt19]

thanks for ur reply .... i will try this.