in reply to Finding columns on multipage spreadsheets

merrymonk:

You've been here long enough to know how to format a post! ;^)

Anyway, to answer your question: Using Spreadsheet::WriteExcel, I don't believe it's possible. After all, you don't know anything about the printer: Paper size, orientation, scale are all unknown to the program. That's enough to be a problem.

Using Win32::OLE you might be able to do it by forcing a print preview and then querying the data structures, but that sounds like a bit more effort than I'd consider.

...roboticus

Update: Inserted missing word in sentence (in bold).

  • Comment on Re: Finding columns on multipage spreadsheets

Replies are listed 'Best First'.
Re^2: Finding columns on multipage spreadsheets
by merrymonk (Hermit) on Jul 06, 2010 at 17:20 UTC
    I cannot help but agree about the format of the post.
    An aberation for which I hope I can be forgiven.
    It looks like some hardwork as a penance since I am not using Spreadsheet::WriteExcel
    (that is unless some other Monk has more ideas!)
[reply]

      merrymonk:

      Gah! I missed a word in my reply (updated above). Sorry about that. I don't believe it's possible in Spreadsheet::WriteExcel.

      ...roboticus

[reply]

In Section Seekers of Perl Wisdom