Get data from excel file

[RaWaS]

I need code to insert into Prop.row_1 value section, which get data from excel depending on droped shape name.

Somthing like that
= vi.Data.ImportExcelWorksheet( "d:\\data1.xlsx" , "Sheet1" , find row what = shpobj.name, get data from cells(row, 3 ) )

[aledlund]

perhaps you could share what release and version of visio you are using.
al

[RaWaS]

MS Visio 2007

[aledlund]

maybe this will give you and idea on how to get started
http://office.microsoft.com/en-us/visio/HA100518191033.aspx
al

[RaWaS]

No its not.
Just correct please this code to be jusfull
I need to put it to shape master cell named Prop.Level
I need something like this:
= vi.Data.ImportExcelWorksheet( "d:\\data1.xlsx" , "Sheet1" , find row what = shpobj.name, get data from cells(row, colummn ) )

[Yacine]

Use ODBC to access the excel sheet.

http://support.microsoft.com/default.aspx?scid=kb;en-us;257819
http://www.connectionstrings.com/