best-practice-and-impact/gptables

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.