swat.CAS.read_excel

CAS.read_excel(self, io, casout=None, **kwargs)

Read an Excel table into a CAS table

This method calls pandas.read_excel() with the given arguments, then uploads the resulting pandas.DataFrame to a CAS table.

Parameters

iostring or path object

File-like object, URL, or pandas ExcelFile.

casoutstring or CASTable, optional

The output table specification. This includes the following parameters.

namestring, optional

Name of the output CAS table.

caslibstring, optional

CASLib for the output CAS table.

labelstring, optional

The label to apply to the output CAS table.

promoteboolean, optional

If True, the output CAS table will be visible in all sessions.

replaceboolean, optional

If True, the output CAS table will replace any existing CAS. table with the same name.

**kwargsany, optional

Keyword arguments to pandas.read_table().

Returns

CASTable

See also

pandas.read_excel()

upload_file()

Examples

>>> conn = swat.CAS()
>>> tbl = conn.read_excel('iris.xlsx')
>>> print(tbl.head())