ooxml

xlsx-printArea.tcl
Login

xlsx-printArea.tcl

File examples/xlsx-printArea.tcl from the latest check-in


#!/bin/sh
#\
exec tclsh8.6 "$0" "$@"

set auto_path [linsert $auto_path 0 ..]
if {[catch {package require ooxml}]} {
    source ../ooxml.tcl
}

set spreadsheet [::ooxml::xl_write new -creator {Creator Name}]
for {set s 1} {$s <= 4} {incr s} {
    if {[set sheet [$spreadsheet worksheet "Sheet$s"]] > -1} {
        for {set r 1} {$r < 6} {incr r} {
            $spreadsheet row $sheet
            for {set c 1} {$c < 6} {incr c} {
                $spreadsheet cell $sheet $s,$c,$r
            }
        }
        switch -- $s {
            1 {
                $spreadsheet printarea $sheet A1 C3
            }
            2 {
                #$spreadsheet printarea $sheet B2 C3
                $spreadsheet printarea $sheet 1,1 2,2
            }
            4 {
                $spreadsheet printarea $sheet A3 A4
            }
        }
    }
}
$spreadsheet write printArea.xlsx
$spreadsheet destroy