顶层函数¶

load(index=1, header=1, chunksize=5000)¶

Loads the selected cell(s) of the active workbook into a pandas DataFrame. If you select a single cell that has adjacent cells, the range is auto-expanded (via current region) and turned into a pandas DataFrame. If you don't have pandas installed, it returns the values as nested lists.

备注

Only use this in an interactive context like e.g. a Jupyter notebook! Don't use this in a script as it depends on the active book.

参数:

index (bool | int) -- Defines the number of columns on the left that will be turned into the DataFrame's index
header (bool | int) -- Defines the number of rows at the top that will be turned into the DataFrame's columns
chunksize (int) -- Chunks the loading of big arrays.

示例

>>> import xlwings as xw
>>> xw.load()

See also: view

在 0.23.1 版本发生变更.

view(obj, sheet=None, table=True, chunksize=5000)¶

缺省情况下会创建一个新的工作簿并在第一个工作表上显示一个对象。如果提供了一个工作表对象，在显示对象之前会清除工作表里面的内容。

备注

Only use this in an interactive context like e.g., a Jupyter notebook! Don't use this in a script as it depends on the active book.

参数:

obj (Any) -- the object to display, e.g. numbers, strings, lists, numpy arrays, pandas DataFrames
sheet (Sheet | None) -- 工作表对象。如果没有提供这个参数，会使用一个新建工作簿的第一个工作表。
table (bool) -- If your object is a pandas DataFrame, by default it is formatted as an Excel Table
chunksize (int) -- Chunks the loading of big arrays.

示例

>>> import xlwings as xw
>>> import pandas as pd
>>> import numpy as np
>>> df = pd.DataFrame(np.random.rand(10, 4), columns=['a', 'b', 'c', 'd'])
>>> xw.view(df)