swat.cas.datamsghandlers.Excel

class swat.cas.datamsghandlers.Excel(path, sheet=0, nrecs=1000, transformers=None, **kwargs)

Bases: swat.cas.datamsghandlers.PandasDataFrame

Create an Excel data message handler

Parameters

pathstring

Path to Excel file.

sheetstring or int, optional

Sheet name or index to import.

nrecsint, optional

Number of records to send at a time.

**kwargskeyword arguments, optional

Arguments sent to pandas.read_excel().

Returns

Excel data message handler object

See also

pandas.read_excel()

PandasDataFrame

__init__(self, path, sheet=0, nrecs=1000, transformers=None, **kwargs)

Initialize self. See help(type(self)) for accurate signature.

Methods

__init__(self, path[, sheet, nrecs, …])	Initialize self.
finish(self, connection)	Finish the data sending operation
getone(self, connection, \*\*kwargs)	Get a single response from the server
getrow(self, row)	Get a row of values from the data source
send(self, connection, nrecs)	Send the records to the connection
write(self, row, values)	Write the value to the row and column specified in the buffer

Attributes

args	Property that generates the CAS action parameters for CAS actions that use a data message handler.