I want to combine several series of cell ranges in an Excel file using Python Xlsxwriter. I found the Python team in the Xlsxwriter documentation on this website. http://xlsxwriter.readthedocs.org/en/latest/example_merge1.html as shown below:
worksheet.merge_range('B4:D4')
The only problem is that I have ranges in the format of numbers in rows and columns, like (0,0), which is A1. But Xlsxwriter seems to accept only a format similar to A1. I was wondering if anyone else has the same problem, and is there any solution for this.
XlsxWriter A1 (row, col), . . , merge_range():
A1
(row, col)
merge_range()
worksheet.merge_range('B4:D4', 'Merged Range', merge_format) worksheet.merge_range(3, 1, 3, 3, 'Merged Range', merge_format)