swat.CAS.read_excel

CAS.read_excel(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:

io : string or path object

File-like object, URL, or pandas ExcelFile.

casout : string or CASTable, optional

The output table specification. This includes the following parameters.

name : string, optional

Name of the output CAS table.

caslib : string, optional

CASLib for the output CAS table.

label : string, optional

The label to apply to the output CAS table.

promote : boolean, optional

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

replace : boolean, optional

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

**kwargs : any, 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())