Gridlines on selected sheets
Opened this issue · 0 comments
Is your feature request related to a problem? Please describe.
The end user has asked that "Every sheet except cover sheet should have grid lines"
Describe the solution you'd like
A clear and concise description of what you want to happen.
Add gridline number as an option for different sheets, or have as above as default.
Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.
Will try xlsxwriter / openpyxl to open file an modify then re-save, if no easy fix within gptables.
Additional context
The gridline option is set in gptables in gptables.core.wrappers.py class GPWorkbook and function add_worksheet:
worksheet._workbook = self # Create reference to wb, for formatting
worksheet.hide_gridlines(2)
return worksheet
https://xlsxwriter.readthedocs.io/page_setup.html
The following values of option are valid for hide_gridlines:
0 = Don’t hide gridlines.
- 1 = Hide printed gridlines only.
- 2 = Hide screen and printed gridlines.
Or, if you don’t supply an argument the default option is 1, i.e. only the printed gridlines are hidden.