ExcelImport and STP question

[Julia Dawkins]

Yes, that does work, I receive all 445 channels.  However, when I try the real file on the server, it does not work again. 

I have copied that file again and have attached it.  I am only able to return the first 445 channels (until line 447 in Excel).  One bit of information that may be useful, this file on the server is "read-only" and has some macros attached to it.  I had thought I could make a local copy and read from that local file, but even that does not work! 

Thanks again!

Julia

[Walter_Rick]

To read "only" 445 channels is OK, because you're ignoring the first tow lines. I've changed the settings of the Excel file to read-only and tested it again. It works perfect.
Your posting doesn’t contain a attachment.

Greetings

Walter

[Julia Dawkins]

I'm very sorry, I meant to attach this:

[Walter_Rick]

With the new Excel file I can reproduce the problem. I need a little bit time to find out what happens.

Greetings

Walter

[Walter_Rick]

Hi Julia,

I found out what the problem is. A configuration file (STP) does only work for a specific kind of Excel file proper. That means, for all files with the same structure (in your case the same number of rows).

Currently there is no way to handle this more flexible. The only possible way is to use the import wizard. Sorry.

Greetings

Walter

[Walter_Rick]

Hi Julia,

I found out where the problem is. A configuration file (STP) does only work for a specific kind of Excel file proper. That means, for all files with the same structure (in your case the same number of rows).

Currently there is no way to handle this more flexible. The only possible way is to use the import wizard. Sorry.

Greetings

Walter

[Julia Dawkins]

I was wondering about that, when I looked at a STP file for a shorter file versus a longer file, the STP file was shorter/longer respecitively.  Are all STP files for all file types this way (configured for a specific file length)?  I ask because I saved my excel file as a tab-delimited text file and used ASCIIConfigLoad and ASCIILoad commands to load this text file.  If I add more data to the text file, DIADem loads everything properly.  So perhaps this will work?

Thank you again!

Julia

[Walter_Rick]

Hi Julia,

STP files are configuration files created for a specific file structure. If the number of channels which should be imported are always the same this works perfect for ASCII and Excel file formats. But STP files are not designed for various channel numbers.
In case of ASCII files we have a very good solution with the new interface "DataPlugins". This allows you to create a flexible and powerful import filter written in VBS very easily. Please have a look at our DataPlugins web page. There you find lots of ready to use plugins as well as a detailed description and examples.
So in case of ASCII files my suggestion is to create a DataPlugin. I think that will solve all the problems.

Greetings
Walter