import excel file on diadem

[Krishna226]

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

[altenbach]

What kind of trouble?

[Krishna226]

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

[pesmith8a1]

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

[Krishna226]

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. 

[Brad_Turpin]

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