[Qgis-user] Excel Export from QGIS attribute table
Andreas Neumann
a.neumann at carto.net
Thu Dec 1 00:19:30 PST 2011
Hi,
It is a common requirement that users want to export a QGIS attribute
table to Excel/CSV/Spreadsheet. While CSV is probably easy, the other
two are probably more complex, but there are some good Python libraries
around. For my users, Excel is the most requested table export format.
I wonder if this could be made into the core, as I think that most
other user want that as well. The idea is to have an export button for
the table, choose the format (CSV, Excel, Openoffice) and let the user
select if he wants all data export, or only filtered or selected rows.
I guess it would be best to use Python for that purpose, as Python has
some good Excel libraries:
* pyExcelerator: http://sourceforge.net/projects/pyexcelerator/ (Excel
97/2000/XP/2003)
* xlrd und xlwt (reader/writer): http://www.python-excel.org (Excel 2.0
to 2007)
* openpyxl: https://bitbucket.org/ericgazoni/openpyxl/wiki/Home (Excel
2007 and higher)
Do any of you have experience with one of the above listed packages or
any other recommendations? How about OpenOffice writing?
Goal: cross platform without the need to have MSOffice or OpenOffice
installed.
Would this be best implemented in C++ or in Python?
Who else would be interested in such functionality?
Thanks,
Andreas
--
--
Andreas Neumann
Böschacherstrasse 10A
8624 Grüt (Gossau ZH)
Switzerland
More information about the Qgis-user
mailing list