Public Member Functions | |
__init__ (self, wks, dctype='', keep_DC=True) | |
__del__ (self) | |
settings (self) | |
source (self) | |
source (self, s) | |
new_sheet (self, name) | |
imp (self, fname='', sel='', sparks=False) | |
Public Attributes | |
keep = keep_DC | |
wks = wks | |
dc = dctype.lower() | |
source = fname | |
Protected Member Functions | |
_optn (self) | |
Protected Attributes | |
str | _trLTname = '_trTmpDCSettings' |
_trOptn = None | |
Data Connector Parameters: wks (DSheet): the worksheet or martix sheet to use the connector dctype(str): Name of the connector, CSV, Excel etc keep_DC(bool): Keep the connector after import Example: import originpro as op f = op.path('e')+r'Samples\Import and Export\S15-125-03.dat' wks = op.find_sheet() dc = op.Connector(wks) ss = dc.settings() partial = ss['partial'] partial[op.attrib_key('Use')]='1' partial['row']='10:20' dc.imp(f)
originpro.dc.Connector.imp | ( | self, | |
fname = '', | |||
sel = '', | |||
sparks = False ) |
Import file Parameters: fname(string): source file name sel(string):selection Returns: none Examples: wks=op.find_sheet() dc=op.Connector(wks) f=op.path('e')+r'Samples\Import and Export\ASCII Simple.dat' dc.imp(f)
originpro.dc.Connector.new_sheet | ( | self, | |
name ) |
Import a new selection into a new sheet Parameters: name(str): selection, for example an Excel sheet name Returns: None Examples: dc.imp(f, sel='Oil') dc.new_sheet('Natural Gas')
originpro.dc.Connector.settings | ( | self | ) |
Parameters: none Returns: Import settings Examples: wks=op.find_sheet() dc=op.Connector(wks) ss=dc.settings()
originpro.dc.Connector.source | ( | self | ) |
Property getter returns the source of Data Connector Parameters: none Returns: (str) Data Source Examples: wks=op.find_sheet() dc=op.Connector(wks) print(dc.source)
originpro.dc.Connector.source | ( | self, | |
s ) |
Property setter set the source of Data Connector Parameters: s(str): Data Source Returns: None Examples: wks=op.find_sheet() dc=op.Connector(wks) dc.source=op.path('e')+r'Samples\Import and Export\S15-125-03.dat' dc.imp()