Importing LOTS of Excel Files

[albe0186_]

Hi All,

I am new to DIAdem so this might be an easy question to answer. I have lots of .xlsx files and different levels of folders in a folder structure. Each .xslx file contains data on the first sheet (Example Attached). How should I go about collecting and organizing the data for viewing/analysis? Converting to TMDS files? Using the My DataFinder?

I also likely need to call a customer import script to grab each .xlsx file since there is data starting on row 15 but the end is not defined. And the data of the test is important which is at the top rather than in each row. In the end I want to view the data across all these .xlsx file with the data on the Y axis and the date on the X axis.

I can write custom scripts if needed.

Thanks!

[albe0186_]

Opps, Spelling corrections:

"I also likely need to call a custom import script"

"And the date of the test is important"

[Dia791]

Hey.

First of all, such imports are easier, if you have all files in one folder. Maybe it could help to copy all of them into one (temporar) folder via batch-file / shell commands?..

For the import itself, you can start the script recording, import one file, and then take a look on the recorded code. Sometimes it helps to understand, what the software does and needs.

Conversion to TDMS would help for further evaluations, as long the structure remains similar for all XLS files. Means, you don't have completely different layout in the table. The begin of data area can vary, it's okay, can be adjusted.

After you have all in TDMS, you can apply math algorithms for searching in DataFinder.

But anyhow it seems to be a bunch of work...

Greetings,

Vassili

[albe0186_]

Thanks for your reply Vassili,

I was thinking DAIdem was built for applications like this, so I was hoping there was an easier way. But I can do what you have suggested if needed.

[albe0186_]

I was able to easily put all the excel files in one folder. However, I tried recording and then importing but DIAdem does not allow recording of the Wizard for importing xls files. "Can not execute the wizard in the recording mode"

[Dia791]

You're right, obviously the wizards cannot be recorded...

I tried to adjust the plugin, but it looks weird for me...

I'm sorry, no further proposals yet. Maybe any guys from NI application support can write someting like "external wizard", which can be started like a standard vbs code..?