search

d-band / better-xlsx

A better xlsx library.
https://d-band.github.io/better-xlsx/
420 stars 36 forks source link

How to set page margin #69

Closed liuzhen88 closed 6 years ago

liuzhen88 commented 6 years ago

i want to set execel page margin, how to do this ?

helloyou2012 commented 6 years ago

See the code here: xmlWorksheet

const sheet = file.addSheet('hello');
sheet.afterMake = (xsheet) => {
  xsheet.pageMargins.left = 0.7875;
  xsheet.pageMargins.right = 0.7875;
  xsheet.pageMargins.top = 1.05277777777778;
  xsheet.pageMargins.bottom = 1.05277777777778;
  xsheet.pageMargins.header = 0.7875;
  xsheet.pageMargins.footer = 0.7875;
};