| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576 |
- #!/usr/bin/env python
- # -*- coding: utf-8 -*-
- # Copyright (C) 2008 Søren Roug, European Environment Agency
- #
- # This is free software. You may redistribute it under the terms
- # of the Apache license and the GNU General Public License Version
- # 2 or at your option any later version.
- #
- # This program is distributed in the hope that it will be useful,
- # but WITHOUT ANY WARRANTY; without even the implied warranty of
- # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
- # GNU General Public License for more details.
- #
- # You should have received a copy of the GNU General Public
- # License along with this program; if not, write to the Free Software
- # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
- #
- # Contributor(s):
- #
- # This script converts a spreadsheet to a text file. I.e. it copies
- # the sheets and turns them into tables in the textfile
- # Note: Copy of images does not work?
- #
- import sys, getopt
- from odf.opendocument import OpenDocumentText, load
- from odf.table import Table
- from odf.text import P
- def usage():
- sys.stderr.write("Usage: %s [-o outputfile] inputfile\n" % sys.argv[0])
- if __name__ == "__main__":
- try:
- opts, args = getopt.getopt(sys.argv[1:], "o:", ["output="])
- except getopt.GetoptError:
- usage()
- sys.exit(2)
- outputfile = None
- for o, a in opts:
- if o in ("-o", "--output"):
- outputfile = a
- if len(args) != 1:
- usage()
- sys.exit(2)
- inputfile = args[0]
- if outputfile is None:
- outputfile = inputfile[:inputfile.rfind('.')] + ".odt"
- spreadsheetdoc = load(inputfile)
- textdoc = OpenDocumentText()
- # Need to make a copy of the list because addElement unlinks from the original
- for meta in spreadsheetdoc.meta.childNodes[:]:
- textdoc.meta.addElement(meta)
- for font in spreadsheetdoc.fontfacedecls.childNodes[:]:
- textdoc.fontfacedecls.addElement(font)
- for style in spreadsheetdoc.styles.childNodes[:]:
- textdoc.styles.addElement(style)
- for autostyle in spreadsheetdoc.automaticstyles.childNodes[:]:
- textdoc.automaticstyles.addElement(autostyle)
- for sheet in spreadsheetdoc.getElementsByType(Table):
- textdoc.text.addElement(sheet)
- textdoc.text.addElement(P())
- textdoc.Pictures = spreadsheetdoc.Pictures
- textdoc.save(outputfile)
|