The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 Placing import data from Column B on

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
antonio1@uni-bremen.de Posted - 03/11/2022 : 03:34:23 AM
Greetings everyone,

I want to change the initial column which origin place the imported data.

I have a set of data with the same amount of columns and rows. I wrote the values at the first column and I want origin to place the imported data starting at the second column.

Right now, it is always overwriting the first column, which I want to keep it.

This is probably really simple but I was not able to find a good solution using the import wizard.

1   L A T E S T    R E P L I E S    (Newest First)
ChaoC Posted - 03/11/2022 : 11:31:14 AM
Hi Antonio,

Follow these steps:

-Select the worksheet you want to import to
-At the top of Origin go to Data>Import from File>Single ASCII
-If you don't see a Single ASCII option, you have to go to Import from File>Add/Remove File Types to add it to your menu.
-Select your import data make sure the Show Options Dialog is checked, hit OK.
-Under the Import Options menu there is 1st File Import Mode, select Start New Columns.

Your data should import without overwriting existing columns.

Let me know if you have any other questions!

Chao

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000