Python XlsxWriter – Number Formats In Excel, different formatting options for numeric data are available in the Number tab of the Format Cells menu. To control the formatting of numbers with XlsxWriter, we can use the set_num_format() method or define…
Python XlsxWriter – Hyperlinks A hyperlink is a string that, when clicked, takes the user to another location, such as a URL, another worksheet in the same workbook, or another workbook on their computer. The Worksheet class provides the write_url()…
Python XlsxWriter – Chart Legends Depending on the chart type, data is visually represented using different colors or patterns, such as columns, bars, lines, and arcs. A chart legend makes it easy to understand which color/pattern corresponds to which data…
Python XlsxWriter – Pie Chart A pie chart represents a single data series as a circle divided into slices corresponding to each data item in the series. In a pie chart, the arc length of each slice is proportional to…