[Qgis-developer] Excel Export from QGIS attribute table

[Etienne Tourigny]

It has been suggested to support LibreOffice/OpenOffice Calc in
addition to XLS.
How hard would it be to improve the  FreeXL library to support ods ,
or incorporate support for ods into OGR's xls driver?

I might also add that the FreeXL does not (yet?) support the newer XML
SS file format specification (.xlsx, Microsoft Excel 2007 and newer),
which may be a show-stopper?

Etienne

On Thu, Dec 1, 2011 at 12:21 PM, Andreas Neumann <a.neumann at carto.net> wrote:
> Hi,
>
> Thanks all for your ideas.
>
> I agree - it makes sense to me to improve and use OGR for this purpose.
>
> I also tested the idea with the clipboard. On Linux Ubuntu it works fine if
> one copies from the QGIS table and pastes in LibreOffice/OpenOffice Calc. On
> pasting, it opens the CSV dialogue for importing.
>
> FYI: for use with Python Plugins Jürgen added the xlrd/xlwt Python module to
> the OSGeo4W distribution. With these modules at hand it is very easy to read
> and write basic XLS files. Not a solution for the core, but definitely
> interesting for Python Plugins.
>
> Andreas
>
>
> On Thu, 1 Dec 2011 11:50:38 -0200, Etienne Tourigny wrote:
>>
>> To add to Even's suggestion,
>>
>> I think it would be best to improve the xls driver in OGR and
>> integrate that into QGis, rather than develop a standalone QGis
>> plugin.
>> That way you make both better!
>>
>> Etienne
>>
>>
>> On Thu, Dec 1, 2011 at 6:41 AM, Even Rouault
>> <even.rouault at mines-paris.org> wrote:
>>>
>>>
>>>> > I'd be much more interested in reading of xls, xlsx, ods etc as
>>>> > tables for joining or generating spatial X,Y layers.
>>>
>>>
>>> FYI, Sandro Furieri has created a lightweight FreeXL library that can
>>> read XLS
>>> files. It can be integrated with spatialite (through a VirtualXLS
>>> module), or
>>> standalone. I've developed in GDAL/OGR 1.9.0 a OGR driver that relies on
>>> it. See
>>> http://gdal.org/ogr/drv_xls.html for the details and limitations.
>>>
>>> Best regards,
>>>
>>> Even
>>> _______________________________________________
>>> Qgis-developer mailing list
>>> Qgis-developer at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>>
>> _______________________________________________
>> Qgis-developer mailing list
>> Qgis-developer at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>
>
> --
> --
> Andreas Neumann
> Böschacherstrasse 10A
> 8624 Grüt (Gossau ZH)
> Switzerland
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer