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 for Programming
 LabTalk Forum
 Data processing

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
66de250 Posted - 06/04/2024 : 10:47:11 PM
I now have an origin project opj file that contains multiple workbooks, each with graph, data, and note. data is a table with two columns and many rows, and the data and title in the first column of the data table in each workbook are the same. Now I need to use the command in origin (MENU-e) to create an excel table with only one sheet workspace inside the project. I need to copy the data table in each workbook into the sheet of the excel table, and the first column of the excel table is the title of the first column of the data table. The remaining rows are then copied sequentially to the data in the first column of the data table in the workbook. The second column of the excel table and its subsequent columns are copied to the intensity data of each workbook Data table, and the title of the first row of each column is the name of the corresponding workbook. How should I type the command, please help me, thanks a million!
1   L A T E S T    R E P L I E S    (Newest First)
YimingChen Posted - 06/05/2024 : 3:32:36 PM
It appears you want to append the second column of multiple worksheets into one sheet, then insert a column at the beginning with the titles read from the first column of the source sheets. Is that correct?

You could use the wAppend X-function, please refer to the page below:
https://www.originlab.com/doc/en/X-Function/ref/wAppend

James

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