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
 Excel - multiple sheet import

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
dominik.mierzwa Posted - 01/13/2020 : 06:41:53 AM
Origin Ver. and Service Release (Select Help-->About Origin):
OriginPro 2020 (64-bit)
9.7.0.185 (Academic)

Operating System: Window 10 PRO

Hi,

I'm going to import data from one Excel workbook with multiple sheets. Each sheet has 1 line of a header (1st) which should be assigned as "Long name" in Origin. However, when I choose "Number of Subheader lines": 1, and "Long Name": 1 it works only for the first sheet. In the 2nd and other ones, the subheader is in the 1st row.

How to fix it?

Kind regards,
Dominik
1   L A T E S T    R E P L I E S    (Newest First)
dominik.mierzwa Posted - 01/13/2020 : 07:37:24 AM
I found the option "Apply header for all sheets" so the problem is solved.

Kind regards,
Dominik

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