Batch Processing when Dragging and Dropping Data into Origin

Origin 2016 introduced a new way to perform batch processing when importing multiple data files into a workbook which is already setup with analysis, graphing, cell formatting, and etc. You can watch this video to see how it works.

This blog will show user how to do an extra step so that such batch processing can be performed when dragging and dropping more data files into such workbook. We will use sample data in Origin installation as an example.


Import 1st Data with Some Customization

  1. Start a new project in Origin.
  2. Choose File: Import: Single ASCII…
  3. Check Show Options Dialog checkbox and choose F1.dat under Samples\Import and Export\ folder in installed Origin folder. Click Open button.
  4. Set Import Mode: Start New Books. Set Template Name: <clone>
  5. Expand Import Options -> Header Lines node. Set Long name, Units, Comments From and Comments To to 4, 5, 1, 2 respectively.import_customization
  6. Click OK. You will get F1 workbook as follows.import_F1

Note: All import settings are automatically saved in the worksheet so if you import other data into this sheet, the same customization will be used.


Setup the Analysis and Graphing

  1. Add a new column D in worksheet. Set the long name as Corrected
  2. In F(x) cell of column D, enter formula: col(B)-col(C).
  3. Right click the Sparklines cell of Column D and choose Add or Update Sparklines… to make sparklines show for column D.import_corrected
  4. Highlight col(D) and select Plot: Symbol: Scatter.
  5. Double click X axis line to open Axis dialog.
  6. With Scale tab active, select Horizontal and Vertical on left panel. Set Rescale: Auto. This way if data are changed, the graph will auto update. Click OK.
  7. Choose Analysis: Fitting: Sigmoidal Fit…  menu. NLFit dialog will open with Category preset to Growth/Sigmoidal. Choose Bolzmann as Function.
  8. On Advanced tab, set Recalculation to Auto. Click Fit button to performance the fitting.
  9. With F1 sheet active, right click in gray area of the worksheet and choose Add Graphs… context menu. Add Graph1 as a floating graph.import_corrected_fit

Now we have a workbook with everything setup. Note: Anytime you want to customize the graph further, you can double click the graph. They key is to have everything inclusive in this workbook.


Batch Processing More Data Files by Dragging and Dropping

  1. Show Windows Explorer and Origin side by side. Make sure F1 sheet is active.
  2. In Windows Explorer, go to Origin installation folder. E.g. by default it should be C:\Program Files\OriginLab\Origin2016
  3. Go to Samples\Import and Export\ subfolder.
  4. Select F2.dat and F3.dat, which have similar data structure as F1.dat.
  5. Drag these 2 files onto the F1 worksheet. (Note: Don’t just drop it into blank area of workspace since that will not use the import settings of F1 sheet)
  6. You will get two more workbooks with F2.dat and F3.dat file imported, column corrected, and sigmoidal fit performed. batch_drag


Note: Origin provides a built-in list of import filter files for drag an drop. If in general your data is well-defined and already can be dragged into Origin workspace to import. Then you can choose Tools: Import Filters Manager… menu.

Choose your import file type, e.g. ASCII. Click Edit button.

Only set Import Mode to Start New Book or Start New Sheet. Enter <clone> as Template Name.

Click Save As… to call it e.g. ASCII_Clone.

Then when you drag and drop new data files to workbook with analysis and graphing setup already, you will be asked to choose which import filter to use. If you choose ASCII_Clone will do batch processing.

One Response

  1. I want to one ,thanks

Leave a Reply