DIAdem

cancel
Showing results for 
Search instead for 
Did you mean: 

import excel file on diadem

Having trouble loading or importing excel files on data portal(Diadem)

0 Kudos
Message 1 of 6
(2,810 Views)

What kind of trouble?

0 Kudos
Message 2 of 6
(2,787 Views)

Krishna226_0-1616527207527.png

This is what I am seeing when trying to load excel data file on diadem data portal. 

 

0 Kudos
Message 3 of 6
(2,705 Views)

The long path is concerning to me.

 

Please try to move file to a much shorter path location. like c:\user\public\test\<File name.xlsx> and retry.

 

Just a note. When I have read a Excel file into portal, usually this requires a custom dataplugin. This is due to the formatting for Excel files being very custom, and requires the dataplugin to know the format well.

Do you have a example excel file that you could post?

 

Paul

0 Kudos
Message 4 of 6
(2,676 Views)

I am currently using base version of diadem 2019. I noticed that my version doesn't support "excel dataplugin wizard". please suggest some alternative to load excel data on data portal on diadem. please check the attached sample excel file that I am trying to read on diadem. 

Krishna226_0-1616717441117.png

 

0 Kudos
Message 5 of 6
(2,625 Views)

Hi Krishna,

 

I created a DataPlugin to read the *.xlsx data file you sent in.  You just need to double-click this *.uri file on the computer that has DIAdem in it, then you will see "Krishna_XLSX" as a DataPlugin option in the File>>Open menu of the NAVIGATOR in DIAdem.  If you have no other Excel DataPlugins registered, you should also then be able to just drag&drop the *.xlsx files into the Data Portal, either from the NAVIGATOR tree view or directly from Windows Explorer.

 

Brad Turpin

Principal Technical Support Engineer

NI

0 Kudos
Message 6 of 6
(2,596 Views)