[GRASS-dev] Excel read support

Hi,

since Excel files continue to be widely used, it would be a great help to
have direct read support in GRASS, e.g. for easy table joins.

I have found this library (which comes e.g. with Fedora as well as OSGeo4W):
https://github.com/python-excel/xlwt
(main page: http://www.python-excel.org/)

To always go through LibreOffice conversion or other tricks is a bit annoying...
Or am I missing an easy trick?

Markus

On Thu, 2012-08-16 at 19:38 +0200, Markus Neteler wrote:

Hi,

since Excel files continue to be widely used, it would be a great help to
have direct read support in GRASS, e.g. for easy table joins.

I have found this library (which comes e.g. with Fedora as well as OSGeo4W):
https://github.com/python-excel/xlwt
(main page: http://www.python-excel.org/)

To always go through LibreOffice conversion or other tricks is a bit annoying...
Or am I missing an easy trick?

Markus
_______________________________________________
grass-dev mailing list
grass-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-dev

Fedora also has Furieri's freexl, in case that helps.

Volker

On Thu, Aug 16, 2012 at 7:43 PM, Volker Froehlich <volker27@gmx.at> wrote:

On Thu, 2012-08-16 at 19:38 +0200, Markus Neteler wrote:

Hi,

since Excel files continue to be widely used, it would be a great help to
have direct read support in GRASS, e.g. for easy table joins.

...

Fedora also has Furieri's freexl, in case that helps.

Excellent (since we at FEM co-financed it :slight_smile: - I see it also on
http://download.osgeo.org/osgeo4w/versions.html

So two choices if Mac OSX and the Debian-style world also
have either/or or both...

Markus

On 16/08/12 20:33, Markus Neteler wrote:

On Thu, Aug 16, 2012 at 7:43 PM, Volker Froehlich<volker27@gmx.at> wrote:

On Thu, 2012-08-16 at 19:38 +0200, Markus Neteler wrote:

Hi,

since Excel files continue to be widely used, it would be a great help to
have direct read support in GRASS, e.g. for easy table joins.

...

Fedora also has Furieri's freexl, in case that helps.

Excellent (since we at FEM co-financed it :slight_smile: - I see it also on
http://download.osgeo.org/osgeo4w/versions.html

So two choices if Mac OSX and the Debian-style world also
have either/or or both...

Debian has xlrd (xlwt is for writing Excel files) in stable and freexl in testing.

However, why should we implement this in GRASS when OGR already supports Excel file reading (via freexl) ? Can't you just use db.in.ogr ?

Moritz

On Fri, Aug 17, 2012 at 11:48 AM, Moritz Lennert
<mlennert@club.worldonline.be> wrote:
...

However, why should we implement this in GRASS when OGR already supports
Excel file reading (via freexl) ? Can't you just use db.in.ogr ?

Good point, I wasn't aware of that:

http://www.gdal.org/ogr/drv_xls.html
(GDAL/OGR >= 1.9.0)

So it won't be needed once the distros provide OGR with FreeXL support.

Markus