Skip to content
This repository has been archived by the owner on Jul 22, 2022. It is now read-only.

Add option to set Print Area #194

Closed
dmechiche opened this issue May 11, 2018 · 3 comments
Closed

Add option to set Print Area #194

dmechiche opened this issue May 11, 2018 · 3 comments
Milestone

Comments

@dmechiche
Copy link

dmechiche commented May 11, 2018

Add a worksheet option to set the print area by specifying which cells should be printed.
screen shot 2018-05-11 at 10 25 22 am

@natergj
Copy link
Owner

natergj commented Jul 7, 2018

I'll add this as an enhancement request. It looks like this is done by specifying a definedName element in the workbook xml.
reference: definedNames.name (§18.2.6 of ECMA-376 2nd edition pdf)

@natergj natergj added this to the 1.6.0 milestone Sep 16, 2018
@natergj
Copy link
Owner

natergj commented Sep 16, 2018

I just released version 1.6.0 to NPM which adds the ability to set print areas. example in project README

ws.setPrintArea(startRow, startCol, endRow, endCol) where parameters are numbers corresponding to print area

@natergj natergj closed this as completed Sep 16, 2018
@stufinn
Copy link
Contributor

stufinn commented Jan 28, 2019

I seem to be hitting an error when I use ws.setPrintNames(), upon opneing the new file in excel. Any ideas why this would be happening?

excelerror

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

3 participants