| T O P I C R E V I E W |
| stbremm |
Posted - 10/15/2004 : 01:32:18 AM
Origin Version (Select Help-->About Origin): 7.5G
Operating System: win 2000
When I import data from excel into a worksheet, I want to use the first row as column name...
How can I do this without copy paste for any column???
Thank you for help!!! |
| 1 L A T E S T R E P L I E S (Newest First) |
| hajo |
Posted - 10/15/2004 : 03:25:14 AM
Hello, stbremm
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.
Feel free to ask again ...
Hajo
--
Dipl.-Ing. Hans-Joerg Koch
SiemensVDO Automotive,
Regensburg, Germany
Edited by - hajo on 10/15/2004 03:26:57 AM |
|
|
