Skip to content

Tag: xlsxwriter

Python xlsxwriter loop through each worksheet in a workbook

I want to iterate through each worksheet that I have created in a workbook with add_worksheet function. I want to do this with all the available sheets in the workbook and write ‘Hello’ in cell ‘A1’ of each sheet. Here is the code I am trying: I was expecting it to write ‘Hello’ in cell ‘A1’ for each available sheet

Set_column breaks on date formats in xlsxwriter for python

I am a new python user and I am trying to understand why set_column and conditional_format work differently when I feel they should work the same. Here is an example of my code for set column. What I am doing here is trying to apply a date color for col6 and col 7 ‘startDate’ and ‘endDate’. The issue is I