just a workarround I used several times for now .... short description of the steps:
- export the Excel Worksheet to a TAB seperated ASCII file (be carefull of cells with a CRLF in it!) out of excel. As you don't own an OriginPRO license you should write a small VBA Macro for using it in Excel doing that job for all files you are interested in! - BETTER: telling your software for data aquisition NOT to write in Excel but directly as TAB seperated ASCII!! (Any other seperator is possible also!) (Having the PRO version you could access Excel directly by COM out of Origin! But so, you should use the "workarround")
- use the ASCII Import editor for reading in the ASCII file. Here you are much more able to take influence of the import method than you are using "open excel" ... Store a Template import filter and use it with your datatype every time you have those data.
worksheet column name
Posted - 10/15/2004 : 01:32:18 AM
