| Author |
 Topic  |
|
|
66de250
China
32 Posts |
 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! |
|
|
YimingChen
1658 Posts |
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 |
 |
|
| |
Topic |
|
|
|
Data processing