Excel Export in 64-bit DIAdem 2017

[AlexVander]

Hello:

I have recently updated to 64-bit DIAdem 2017.  Previously, my script (DIAdem 2012) has used the commands in the GfsExcell.dll to export only one group from the Data Portal to an Excel file.  

We then run some external macros on the Excel file, so the format of the Excel file is very important:

-Channels are stored in columns, with the first column being the data point index.

-The first row is channel name, second row is channel comments, third row is units, and from the fourth column on is the recorded data.

I have not found a way to perform this export effectively, as 64-bit DIAdem 2017 has made the GfsExcel.dll functionality obsolete.

Any help would be much appreciated!

Thanks,

Alex

[Sil.VI]

Hi Alex,

I was looking for some infromation on the question you added and noticed that there in the Release Notes for DIAdem 2017 we recommned the use of the Excel export Wizard instead (you can check this in the Compatibility of DIAdem 2017 64-Bit and DIAdem 2017 32-Bit section) To which I believe you can find further details in this other help reference. Could this be an option for your system?

Hope you could find that helpful, let us know if you have further questoins !

Regards

[AlexVander]

S.Jimenez:

Thank you for your reply.  

I had previously found the Release Notes and had tried to follow the instructions in the Excel Export Wizard help document.  However, the document tells me to register the GFSExcel.dll file in order to access the functionality of the Wizard, which I am not able to do with the 64-bit version.

The attached file shows the result of my attempt to register the Excel .dll file.  Is there a 64-bit version of the GFSExcel.dll file?

The release notes specify to use the Excel Data Plugin Wizard.  Is this different than the Excel Export Wizard you referred me to?

I appreciate all the help I can get with this; this issue I'm having with exporting to Excel is the last hurdle I have in updating my script from DIAdem 2012 to DIAdem 2017.

Thank you,

Alex

[yamadj]

Hey Alex,

I just tried to use the wizard in DIAdem 2017A (17.5) 64-bit and it worked fine the example excel sheet. I wonder if there is something different in 2017A.

Also I checked my GPI extensions and nothing is registered so I'm not sure that you need to register to use the wizard.

[AlexVander]

Thanks for the reply, yamadj.

I see you are running Windows 10; I am on Windows 7, so maybe that is causing some conflicts?  Either way, I am able to use the Wizard as well, but not to create a Plugin for exporting the data to Excel in the format I require.

I have since solved my issue, albeit the solution is a work-around for now.  When using my script in the 32-bit version of DIADem 2017, rather than the 64-bit version, I am able to access the GFSExcel.dll file which contains the commands I need to perform my custom Excel export.  I knew this was an option all along; I resisted reverting back to the 32-bit version of DIAdem 2017, trying every alternate option I could think of, as long as I could....

We don't really NEED to run the 64-bit version, although it would have been nice; 32-bit will suffice.  Perhaps NI could look into making a 64-bit version of the GFSExcell.dll file and allowing its functionality again....

Thanks for all the help everyone!

-Alex

[AndreasK]

I am not sure if this might help but the 2017 DIAdem vesrion contains an option to save to XLSX files.

Call DataFileSave("C:\temp\EXAMPLE.xlsx","ExcelTdmExport")

it is not configurable but it saves a XLSX file with the same format that would show up in Excel if you use the TDM Excel plugin to load an tdm or tdms file into Excel.

[AlexVander]

AndreasK:

Thanks for the reply!

I did try that method but the deal breaker for me was that, as you noted, it isn't configurable.  That method wouldn't be streamlined enough for our process.

Thanks,

Alex