Evaluation version cannot import XLSX file?

[Bert66]

Good morning,

I'm evaluating DIAdem for the first time, in order to understand if it solves my job need, which is analyse incoming data from plant power metering and find/represent certain parts (e.g. peaks of specific durations).

The data come in XLSX format of a MS Excel spreadsheet, in three columns: yyyy-mmydd, hh:mm:ss and the corresponding measured (single) value. The spreadsheet is huge: about 658000 rows (more than 11 MB file size).

Coming to my problem, I tried to import the file with the wizard button but a window came out, titled "DIAdem Evaluation Version" and telling me that "Cannot open file".

The spreadsheet that I tried to import doesn't contain formulas: only data.

I ask you if the problem is due to the evaluation version or other reasons: e.g. the XLSX file format instead the XLS (Excel 97-2003 - which is not compatible with such number of rows).

Thank you for your support.

Alberto.

[Brad_Turpin]

Hi Alberto,

Your DIAdem evaluation version shouldn't cause any problems for loading an Excel file, and both the *.xls and *.xlsx fomats are supported by the Spreadsheet Reader object in DIAdem DataPlugins, which the Wizard should have used.

I think the simplest way forward is for you to post a shortened version of your 3 column file, say the first 100 lines, in Excel format.  I will be happy to create a DataPlugin and send it back to you.  It sounds like the DataPlugin will be no more than 1 screen of code.

Brad Turpin

Principal Technical Support Engineer

NI / Emerson

[Bert66]

Thank you Brad,

I uploaded a sample of the spreadsheet.

Best regards,

Alberto

[Brad_Turpin]

Hi Alberto,

Sorry, I got sidetracked and just got back to this post.  Here's a starting DataPlugin that reads the 1 file you sent.  We might still need to tweak it, but it should be close to what you want.  I had to zip the DataPlugin to post it to this forum.  Just unzip it and double-click on the *.uri file to register the DataPlugin.  You may need to unregister your initial attempt at an XLSX DataPlugin before DIAdem will use this new one by default.  You can always right-click on a file in the NAVIGATOR and select "Open with..." or use the File>>Open menu to specify the exact DataPlugin you want to use.

Regards,

Brad