| T O P I C R E V I E W |
| urana1@uco.edu |
Posted - 12/21/2017 : 10:43:28 PM
Origin Ver. and Service Release (Select Help-->About Origin): 2018
Operating System: Windwos 10[
Hello,
I would appreciate if anyone could point me in the right direction to parse the multiple excel or csv files using batch processing. Please see below:
File 1
Water (cc) 30
Mass (kg) 28
Height (cm) 180
Pressure 1015
File 2
Pressure 1040
Water (cc) 40
Mass (kg) 56
Height (cm) 190
What I want after batch processing of file 1 and file 2?
***********************
File 1 File 2
Water (cc) 30 40
Mass (kg) 28 56
Height (cm) 180 190
Pressure 1015 1040
img]http://www.originlab.com/ftp/forum_and_kbase/Images/File1.png[/img]
 |
| 3 L A T E S T R E P L I E S (Newest First) |
| JacquelineHe |
Posted - 01/03/2018 : 10:29:23 PM
Hi,
After you import your datasets in to Origin, you can try to use Worksheet Query tool to extract your dataset.
Choose menu Worksheet: Worksheet Query to open the dialog.
Please refer to this help page:
https://www.originlab.com/doc/Origin-Help/Wks-Query-QS
Sample:
Thanks
Jacqueline
OriginLab |
| urana1@uco.edu |
Posted - 12/22/2017 : 3:28:22 PM
Thank you for the reply.
The excel file actually contains a lot of parameters along with their values. What I wanted to try is:
Search for specific parameter (e.g., mass), and parse this specific parameter "mass" along with its value (e.g., 28). I would like this result to be in a different sheet or workbook. I do not want to extract other parameters that exist in the excel sheet.
Thanks.
|
| JacquelineHe |
Posted - 12/22/2017 : 05:14:50 AM
Hi
You can try to import these file in the multiple workbook(or worksheet) and then sort these worksheet by first column.
You can add this script in the "Script after Each File Imported" edit box, then the imported datasets are sort by first column
wsort descending:=1;
Then Append the Worksheets into one Worksheet (set Recalulate to None), then delete the repeated columns.
Plesae refer to thess help page of import , Append Workbook, and reduce column.
https://www.originlab.com/doc/X-Function/ref/impCSV
https://www.originlab.com/doc/X-Function/ref/impMSExcel
https://www.originlab.com/doc/Origin-Help/append-worksheet
https://www.originlab.com/doc/Origin-Help/Reduce-Columns
Thanks
Jacqueline
OriginLab
|
