custom.py 1.7 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061
  1. # Copyright (c) 2010-2024 openpyxl
  2. from openpyxl.worksheet.header_footer import HeaderFooter
  3. from openpyxl.descriptors import (
  4. Bool,
  5. Integer,
  6. Set,
  7. Typed,
  8. Sequence
  9. )
  10. from openpyxl.descriptors.excel import Guid
  11. from openpyxl.descriptors.serialisable import Serialisable
  12. from openpyxl.worksheet.page import (
  13. PageMargins,
  14. PrintPageSetup
  15. )
  16. class CustomChartsheetView(Serialisable):
  17. tagname = "customSheetView"
  18. guid = Guid()
  19. scale = Integer()
  20. state = Set(values=(['visible', 'hidden', 'veryHidden']))
  21. zoomToFit = Bool(allow_none=True)
  22. pageMargins = Typed(expected_type=PageMargins, allow_none=True)
  23. pageSetup = Typed(expected_type=PrintPageSetup, allow_none=True)
  24. headerFooter = Typed(expected_type=HeaderFooter, allow_none=True)
  25. __elements__ = ('pageMargins', 'pageSetup', 'headerFooter')
  26. def __init__(self,
  27. guid=None,
  28. scale=None,
  29. state='visible',
  30. zoomToFit=None,
  31. pageMargins=None,
  32. pageSetup=None,
  33. headerFooter=None,
  34. ):
  35. self.guid = guid
  36. self.scale = scale
  37. self.state = state
  38. self.zoomToFit = zoomToFit
  39. self.pageMargins = pageMargins
  40. self.pageSetup = pageSetup
  41. self.headerFooter = headerFooter
  42. class CustomChartsheetViews(Serialisable):
  43. tagname = "customSheetViews"
  44. customSheetView = Sequence(expected_type=CustomChartsheetView, allow_none=True)
  45. __elements__ = ('customSheetView',)
  46. def __init__(self,
  47. customSheetView=None,
  48. ):
  49. self.customSheetView = customSheetView