天天看点

python to_excel参数解释_Pandas Excel文件解析参数

sheetname : string, int, mixed list of strings/ints, or None, default

Strings are used for sheet names, Integers are used in zero-indexed

sheet positions. Lists of strings/integers are used to request

multiple sheets. Specify None to get all sheets. str|int -> DataFrame

is returned. list|None -> Dict of DataFrames is returned, with keys

representing sheets. Available Cases

Defaults to 0 -> 1st sheet as a

DataFrame

1 -> 2nd sheet as a DataFrame

“Sheet1” -> 1st sheet as a DataFrame

[0,1,”Sheet5”] -> 1st, 2nd & 5th sheet as a dictionary of

DataFrames

None -> All sheets as a dictionary of DataFrames