Python XlsxWriter – Applying Filters In Excel, you can use logical expressions to set filters on table data based on criteria. In the XlsxWriter worksheet class, we have the autofilter() method or object. This method’s mandatory parameter is a cell…
Python XlsxWriter Overview XlsxWriter is a Python module for creating spreadsheet files in the Excel 2007 (XLSX) format, using the open XML standard. The XlsxWriter module was developed by John McNamara. Its earliest version (0.0.1) was released in 2013. The…
Python XlsxWriter – Hello World Getting Started The first program to test whether a module/library is working properly is usually to write the message “Hello World”. The following program creates a file with the .XLSX extension. An object of the…
Python XlsxWriter – Line Chart A line chart displays a series of data points connected by a line along the X-axis. It is an independent axis because the values on the X-axis are independent of the vertical Y-axis. The Y-axis…
Python XlsxWriter – Data Validation The Data Validation feature in Excel allows you to control what users can enter into a cell. You can use it to ensure that a cell value is a number/date within a specified range, is…
Python XlsxWriter – Hiding or Protecting a Worksheet The hide() method of a worksheet object makes the worksheet disappear until it is unhidden through the Excel menu. In the following worksheet, there are three worksheets, one of which, sheet2, is…
Python XlsxWriter – Adding a Chart One of Excel’s most important features is its ability to convert data into charts. A chart is a visual representation of data. Different types of charts can be generated from the Chart menu. To…
Python XlsxWriter – Important Classes The XlsxWriter library consists of the following classes. The methods defined in these classes allow for programmatically performing various operations on XLSX files. These classes are: Workbook Class Worksheet Class Format Class Chart Class Chartsheet…
Python XlsxWriter – Dates and Times In Excel, dates are stored as real numbers so they can be used in calculations. By default, January 1, 1900 (called the epoch) is treated as 1, so January 28, 2022 corresponds to 44589.…
Python XlsxWriter – Page Setup The worksheet’s page setup methods are related to the worksheet’s appearance when printed. These worksheet methods control orientation, paper size, margins, and more. set_landscape() This method sets the orientation of the worksheet’s printed pages to…