Print Range Settings

 

Summary: How do I set the print range settings from xlwt?

I have a document that is currently set as four pages for the purposes of printing, and I need to make it so that the print range is set to only treat it as one page. The documentation for xlwt (outside of the basics) is hard to find.

The only things I've been able to find so far are:

  • A Visual Basic answer, but the answer doesn't describe the terminology or how it works.
  • A Google Groups discussion that also doesn't explain what any of the values do.

    • Try 

    worksheet.fit_num_pages=1

    Or worksheet.set_fit_num_pages(1) both of which shrinks everything to fit on one page. The default value is set to 0 meaning no scaling happens.

    ws.print_scaling is a scaling percentage, set by default to 100.

    ws.paper_size_code defaults to 9 on my system, but presumably lets you choose between A3, A4, ...

    链接地址: http://www.djcxy.com/p/19484.html

    上一篇: 使用TIMESTAMPDIFF和JPA标准查询，并使用hibernate作为提供者

    下一篇: 打印范围设置