A Python package for generating Microsoft Excel ™ spreadsheet files.
This documentation is currently incomplete. There may be methods and classes not included and any item marked with a [NC] is not complete and may have further parameters, methods, attributes and functionality that are not documented. In these cases, you'll have to refer to the source if the documentation provided is insufficient.
This function is used to create and configure XFStyle objects for use with (for example) the Worksheet.write method.
A string to be parsed to obtain attribute values for Alignment, Borders, Font,
Pattern and Protection objects. Refer to the examples
in the file .../examples/xlwt_easyxf_simple_demo.py and to the xf_dict
dictionary in Style.py. Various synonyms including color/colour, center/centre and gray/grey
are allowed. Case is irrelevant (except maybe in font names). '-' may be used instead
Example: "font: bold on; align: wrap on, vert centre, horiz center"
To get the "number format string" of an existing cell whose format you want to reproduce,
select the cell and click on Format/Cells/Number/Custom. Otherwise, refer to Excel help.
Examples: "#,##0.00", "dd/mm/yyyy"
The class to instantiate to create a workbook
For more information about this class, see The Workbook Class.
A class to represent the contents of a sheet in a workbook.
For more information about this class, see The Worksheet Class.
This is a class representing a workbook and all its contents. When creating Excel files with xlwt, you will normally start by instantiating an object of this class.
This method is used to create Worksheets in a Workbook.
This method is used to save Workbook to a file in native Excel format.
This can be a string containing a filename of the file, in which case the excel file is saved to disk using the name provided.
It can also be a stream object with a write method, such as a StringIO, in which case the data for the excel file is written to the stream.
This is a class representing the contents of a sheet in a workbook.
WARNING: You don't normally create instances of this class yourself. They are returned from calls to Workbook.add_sheet
This method is used to write a cell to a Worksheet..