Path, it looks for the file in the current working directory.
xlsx, xlsm etc.) of existing workbook or name of an unsaved workbook. fullname ( str or path-like object, default None) – Full path or name (incl.App () # or something like xw.apps for existing apps, get the PIDs via xw.apps.keys() > app. Gets or sets the status of the cut or copy mode.Īccepts False for setting and returns None, copy or cut when getting the status. data ( kwargs) – All key/value pairs that are used in the template.
Strings, numbers, lists, simple dicts, NumPy arrays, Pandas DataFrames, pictures and Writes the values of all key word arguments to the output file according to the template and the variablesĬontained in there (Jinja variable syntax). This is a convenience wrapper around mysheet.render_template create_report ( template=None, output=None, book_settings=None, **data ) ¶