Excel dataplugin examples?

[GS]

I need to write a dataplugin for an Excel spreadsheet, but I'm having trouble finding an example of how to do this. There is one that seems to deal with the subject called ADO.VBS, but I can't figure out what's going on in the script or what I would need to modify to make it work for me. Are there any other examples or tutorials on the subject?

George

[Brad_Turpin]

Hi George,

The posted ADO DataPlugin basically treats the Excel sheet as a data base and addresses it through the Microsoft Jet data base engine, which is ideal for Excel files with very long columns of data.

I recently created a DataPlugin that instead reads out individual cell values one by one.  This is not ideal for long channels but excellent for Excel files with mainly scaler values or for interrogating an arbitrary Excel file to figure out what type it is.  I haven't cleaned up this cell-based Excel DataPlugin to post it on the Discussion Forum, but I will send it to you directly via email.

Regards,
Brad Turpin
DIAdem Product Support Engineer
National Instruments

[StefanR]

Hi George,

with DIAdem 2010 we introduced the 'Workbook' object allowing to parse/read Excel files using a DataPlugin.

Please see the Excel Example for more details.