QtXlsxWriter icon indicating copy to clipboard operation
QtXlsxWriter copied to clipboard

Add panes splitting, auto filter and selection features.

Open GMolini opened this issue 6 years ago • 0 comments

This pull request has features copied from @agrech , which proposed them for the original repository of @dbzhang800

I have merely copied his code and would like to include them in this version.

Add worksheet pane splitting features with methods:

  • freezePane() : Create panes and mark them as frozen in worksheet's spreadsheetML.
  • splitPane(): Create panes and mark them as split in worksheet's spreadsheetML. Auto filter feature:
  • setAutoFilter(): Mark a range of cells for auto filtering. Selection feature:
  • setSelection(): Select a cell range and activate a cell for a pane in a worksheet.

Existing panes, auto filter and selections will also be imported on opening an existing xlsx file.

GMolini avatar Mar 02 '18 15:03 GMolini