From 04:00 PM CDT – 08:00 PM CDT (09:00 PM UTC – 01:00 AM UTC) Tuesday, April 16, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

DIAdem

cancel
Showing results for 
Search instead for 
Did you mean: 

How to save as Excel file type?

Solved!
Go to solution

There were no Excel file type under the "Save As" function.  Is there anyway to include Excel file type under this list?  Snapshot attached. 

0 Kudos
Message 1 of 2
(4,843 Views)
Solution
Accepted by topic author NiCoder

Hi NiCoder,

 

You have a numer of different options to get data from the DIAdem Data Portal to Excel:

 

1)  Save to TDM or TDMS file and use the free TDM Excel Importer to load the data into Excel

2)  Save to CSV file and use Excel's built-in ASCII file import feature to load the data into Excel

3)  Load the gfsexcel.dll GPI-DLL and use the "File >> Save as..." option to export an *.xls data file

4)  Use a custom VBScript to automate any of the above 3 options

5)  Use a custom VBScript to directly send each Data Portal data channel to a column of values in Excel via ActiveX

 

Options 1) and 2) are easiest if you want a purely interactive solution.  Option 1) will export all the data values as well as all the properties.  Option 2) will export all the data values and the name of each channel in the Data Portal, but none of the other properties.  If you choose to use option 3), know ahead of time that this feature is limited to 255 columns and will not export any custom properties, just the properties that existed back in DIAdem 8.1.  Option 4) can add in all the custom properties that are missing in option 2).  Option 5) can export all the data and all custom properties, but it is also the slowest option and involves the most programming.

 

Let me know what sounds best to you,

Brad Turpin

DIAdem Product Support Engineer

National Instruments

Message 2 of 2
(4,812 Views)