Is ExcelImport in 2012 release? I need to sort and import sheets in an Excel file.

[jwsnasa]

I have need to import a specific tab of 100 different Excel files.  Each file has 6 tabs, but only one contains my time-history data.  I want to write an interactive inport script, but my 2012 release does not appear to have "ExcelInport".  Can I get it somewhere, or is there a 2012 solution?

[Otmar]

Hello jwsnasa,

The ExcelImport in DIAdem 2012 is now done through the "Excel DataPlugin Wizard" in the NAVIGATOR. The result of the DataPlugin Wizard is a DataPlugin that will allow you to simply drag & drop (or programmatically load) XLS and XLSX files using the NAVIGATOR and the Data Portal. The Wizard will lead you through a few steps to build the DataPlugin, and at the end save the result for later re-use, so this is a one time process.

Here are some more detailed instructions on how to use the Wizard: http://www.ni.com/tutorial/13789/en/

Let us know if that will help solve your issue,

      Otmar

[DJColeslaw]

Hi jwsnasa,

You can enable the ExcelImport function throu gh the GPI extensions menu. To do this, navigate to "Settings >> Extensions >> GPI Extensions...". In the User Extensions tab, click the "add" button.  

This will launch the GPRI-DLL selection dialog:

select the GfsExcel.dll and select "Open".  This will allow you to use the ExcelImport function.  If you want this change to be permanent, save over the default Desktop.DDD file when prompted.

[jwsnasa]

Thanks you to both. 

The GPI especially helped, thanks! 

[jwsnasa]

Hey DJColeslaw, 

Do you know what the other .dll's contain?  We do tons of scripting and was wondering if it was something else useful.

Thanks!

[DJColeslaw]

Hi jwsnasa,

The other DLLs mostly contain deprecated methods which have been replaced with better, updated methods and which were included in the DIAdem directory for backwards compabitility.  As Otmar noted, the ExcelImport function has really been replaced with the ASCII DataPlugin Wizard, but you can still use the ExcelImport function by adding the extension. You can get a decent sense of what the available DLLs contain by mousing over the listings in the "DLL selection for registering extensions" window and reading the "File Description" section. From there, you can get additional information by searching the web but there really isn't anything there which doesn't already exist in DIAdem in better forms.