Overview of Data Importing in Origin Video Lecture | Origin Tutorials for Beginners - Data & Analytics

importing data into origin is very easy
with drag-and-drop support available for
many standard formats for example here
we have an excel file we'd like to
import after the data is imported you
can right-click the headers and set them
as comments
long name
were units
in addition to drag and drop you can
also use the import dialog to import
data with more options
let's prompt this dialog by clicking the
import Excel button after selecting our
file we can then tell origin which
sheets to import in this case there's
only one in the column headers tab you
can also specify how many rows of data
covers the main header and sub header
and set them as the long name and units
and we can also turn on sparklines to
easily view trends in our data now that
our data is imported let's make some
modifications first we'll add a new
column for corrected data which will
calculate by subtracting the blank data
from our sample data
you can use the f of X row to enter any
formula with origin scripting language
lab talk
now you no longer have to type out the
word column before the column name
instead origin 2017 spreadsheet cell
notation allows you to enter the letter
of each column using them in a similar
manner to algebraic variables
once a formula has been entered a green
lock icon will appear in the header to
indicate the values of this column are
the output of an operation
you can also turn on the spark lines of
the newly added data by using the option
in the right-click menu
now let's plot a double-wide plot of the
sample data and corrected data
if we want to include our graph with our
data we can add it as a floating graph
in the same worksheet
now let's say that our Excel file has
changed here we've pasted some new data
in the sample column and saved it in
origin we can easily update our workbook
and corresponding data by going to file
re-import directly
you can see the corrected column updates
automatically and our graph instantly
reflects this the exes scales however
will not update because the axis rescale
mode is set as normal by default you can
open and customize a floating graph
simply by double clicking on it
now that our graph is open let's double
click on an axis to open the axis dialog
let's set both the X and Y axis rescale
modes to auto
you
once we've done this we'll hit rescale
to see the effect this has and repeat
these steps for the axis on our second
layer we'll click return to go back to
the worksheet now that everything is set
up in one workbook if you want to import
more such data and reproduce the same
calculation in graph just click the
import Excel button a second time select
some more data files and in the import
dialog set both the first file import
mode and multi file import mode to start
new book
because this data has organized the same
way as our previously imported data
we'll set our template to clone with
this setting origin will clone the
active workbook in an import our new
data into it
therefore new data will be handled the
same way as the previous data set with
column calculations in a double Y graph
updating accordingly