1 files changed, 159 insertions, 0 deletions
diff --git a/sheet.go b/sheet.go
index 951baf9..ce3e645 100644
--- a/sheet.go
+++ b/sheet.go
@@ -1401,3 +1401,162 @@ func makeContiguousColumns(xlsx *xlsxWorksheet, fromRow, toRow, colCount int) {
 		fillColumns(rowData, colCount, fromRow)
 	}
 }
+
+type (
+	PageMarginBottom float64
+	PageMarginFooter float64
+	PageMarginHeader float64
+	PageMarginLeft   float64
+	PageMarginRight  float64
+	PageMarginTop    float64
+)
+
+// setPageMargins provides a method to set the bottom margin for the worksheet.
+func (p PageMarginBottom) setPageMargins(ps *xlsxPageMargins) {
+	ps.Bottom = float64(p)
+}
+
+// setPageMargins provides a method to get the bottom margin for the worksheet.
+func (o *PageMarginBottom) getPageMargins(ps *xlsxPageMargins) {
+	// Excel default: portrait
+	if ps == nil || ps.Bottom == 0 {
+		*o = 0.75
+		return
+	}
+	*o = PageMarginBottom(ps.Bottom)
+}
+
+// setPageMargins provides a method to set the Footer margin for the worksheet.
+func (p PageMarginFooter) setPageMargins(ps *xlsxPageMargins) {
+	ps.Footer = float64(p)
+}
+
+// setPageMargins provides a method to get the Footer margin for the worksheet.
+func (o *PageMarginFooter) getPageMargins(ps *xlsxPageMargins) {
+	// Excel default: portrait
+	if ps == nil || ps.Footer == 0 {
+		*o = 0.3
+		return
+	}
+	*o = PageMarginFooter(ps.Footer)
+}
+
+// setPageMargins provides a method to set the Header margin for the worksheet.
+func (p PageMarginHeader) setPageMargins(ps *xlsxPageMargins) {
+	ps.Header = float64(p)
+}
+
+// setPageMargins provides a method to get the Header margin for the worksheet.
+func (o *PageMarginHeader) getPageMargins(ps *xlsxPageMargins) {
+	// Excel default: portrait
+	if ps == nil || ps.Header == 0 {
+		*o = 0.3
+		return
+	}
+	*o = PageMarginHeader(ps.Header)
+}
+
+// setPageMargins provides a method to set the left margin for the worksheet.
+func (p PageMarginLeft) setPageMargins(ps *xlsxPageMargins) {
+	ps.Left = float64(p)
+}
+
+// setPageMargins provides a method to get the left margin for the worksheet.
+func (o *PageMarginLeft) getPageMargins(ps *xlsxPageMargins) {
+	// Excel default: portrait
+	if ps == nil || ps.Left == 0 {
+		*o = 0.7
+		return
+	}
+	*o = PageMarginLeft(ps.Left)
+}
+
+// setPageMargins provides a method to set the right margin for the worksheet.
+func (p PageMarginRight) setPageMargins(ps *xlsxPageMargins) {
+	ps.Right = float64(p)
+}
+
+// setPageMargins provides a method to get the right margin for the worksheet.
+func (o *PageMarginRight) getPageMargins(ps *xlsxPageMargins) {
+	// Excel default: portrait
+	if ps == nil || ps.Right == 0 {
+		*o = 0.7
+		return
+	}
+	*o = PageMarginRight(ps.Right)
+}
+
+// setPageMargins provides a method to set the top margin for the worksheet.
+func (p PageMarginTop) setPageMargins(ps *xlsxPageMargins) {
+	ps.Top = float64(p)
+}
+
+// setPageMargins provides a method to get the top margin for the worksheet.
+func (o *PageMarginTop) getPageMargins(ps *xlsxPageMargins) {
+	// Excel default: portrait
+	if ps == nil || ps.Top == 0 {
+		*o = 0.75
+		return
+	}
+	*o = PageMarginTop(ps.Top)
+}
+
+// PageMarginsOptions is an option of a page margin of a worksheet. See
+// SetPageMargins().
+type PageMarginsOptions interface {
+	setPageMargins(layout *xlsxPageMargins)
+}
+
+// PageMarginsOptionsPtr is a writable PageMarginsOptions. See GetPageMargins().
+type PageMarginsOptionsPtr interface {
+	PageMarginsOptions
+	getPageMargins(layout *xlsxPageMargins)
+}
+
+// SetPageMargins provides a function to set worksheet page lmargins.
+//
+// Available options:
+//   PageMarginBotom(float64)
+//   PageMarginFooter(float64)
+//   PageMarginHeader(float64)
+//   PageMarginLeft(float64)
+//   PageMarginRightfloat64)
+//   PageMarginTop(float64)
+func (f *File) SetPageMargins(sheet string, opts ...PageMarginsOptions) error {
+	s, err := f.workSheetReader(sheet)
+	if err != nil {
+		return err
+	}
+	ps := s.PageMargins
+	if ps == nil {
+		ps = new(xlsxPageMargins)
+		s.PageMargins = ps
+	}
+
+	for _, opt := range opts {
+		opt.setPageMargins(ps)
+	}
+	return err
+}
+
+// GetPageMargins provides a function to get worksheet page margins.
+//
+// Available options:
+//   PageMarginBotom(float64)
+//   PageMarginFooter(float64)
+//   PageMarginHeader(float64)
+//   PageMarginLeft(float64)
+//   PageMarginRightfloat64)
+//   PageMarginTop(float64)
+func (f *File) GetPageMargins(sheet string, opts ...PageMarginsOptionsPtr) error {
+	s, err := f.workSheetReader(sheet)
+	if err != nil {
+		return err
+	}
+	ps := s.PageMargins
+
+	for _, opt := range opts {
+		opt.getPageMargins(ps)
+	}
+	return err
+}