#!/usr/bin/perl # example3 - This program creates a SXC Calc file by name use ooolib; # Set variables $doc = new ooolib("sxc"); # Type of document (ie. sxc) $doc->oooSet("builddir", "."); # Directory to create document in $doc->oooSet("title", "Title - Example 3"); # Title of document $doc->oooSet("subject", "Subject - Example 3"); # Subject of document $doc->oooSet("comments", "Who needs comments?"); # Comments for document $doc->oooSet("keyword", "keyword1"); # Add a keyword for the document $doc->oooSet("keyword", "keyword2"); # Add a keyword for the document $doc->oooSet("author", "John Doe"); # Set the author of the document # User defined variables $doc->oooSet("meta1-name", "Programmer"); # 1-4 user defined variables $doc->oooSet("meta1-value", "Joseph Colton"); # 1-4 user defined variables # Write the spreadsheet data $doc->oooData("cell-float", 1); $doc->oooSet("cell-down"); $doc->oooData("cell-float", 2); $doc->oooSet("cell-down"); $doc->oooData("cell-float", 3); $doc->oooSet("cell-right"); $doc->oooData("cell-float", 4); $doc->oooSet("cell-right"); $doc->oooData("cell-float", 5); $doc->oooSet("cell-up"); $doc->oooData("cell-float", 6); $doc->oooSet("cell-up"); $doc->oooData("cell-float", 7); $doc->oooSet("cell-left"); $doc->oooData("cell-float", 8); $filename = $doc->oooGenerate("example3.sxc"); # Create the document and return a filename print "$filename\n"; exit;