Re: [Qgis-developer] Excel export

2013-10-23 Thread Victor Gonzalez
Hi, Thank you, Richard. If you want I can work with you to upgrade the plugin to 2.0. I have a current project now in which this functionality is needed, so I can spend some time in this. What do you think? Regards, Víctor. 2013/10/22 Richard Duivenvoorde rdmaili...@duif.net On 22-10-13

[Qgis-developer] Excel export

2013-10-22 Thread Victor Gonzalez
Hi all, I need to export some attribute tables from QGIS in .xls format. As far as I know, the XYTools plugin [1] does what I want, but it does not work with QGIS 2.0 yet, right? I can update it and contribute the changes, but I would like to know if it has been already planned or maybe the

Re: [Qgis-developer] Excel export

2013-10-22 Thread Siki Zoltan
Dear Victor, save your data into a shape file and open the dbf table with excel or calc and save as xls. Regards, Zoltan On Tue, 22 Oct 2013, Victor Gonzalez wrote: Hi all, I need to export some attribute tables from QGIS in .xls format. As far as I know, the XYTools plugin [1] does what

Re: [Qgis-developer] Excel export

2013-10-22 Thread Victor Gonzalez
Hi Siki, Thanks for the response. I like your solution, but the users who are going to use this don't want to export data to dbf or csv and then transform it manually. So I guess my best option is to adapt the XYTools plugin to the 2.0 version, provided that nobody else is already doing so. Is

Re: [Qgis-developer] Excel export

2013-10-22 Thread Matthias Kuhn
Hi Victor. According to the page of this plugin [1] Richard Duivenvoorde is the maintainer of this plugin. I would wait for his response before taking any action. He recently replied in another thread to a similar question. [2] Kind regards, Matthias [1]

Re: [Qgis-developer] Excel export

2013-10-22 Thread Duarte Carreira
Cc: qgis-developer Assunto: Re: [Qgis-developer] Excel export Hi Siki, Thanks for the response. I like your solution, but the users who are going to use this don't want to export data to dbf or csv and then transform it manually. So I guess my best option is to adapt the XYTools plugin to the 2.0

Re: [Qgis-developer] Excel export

2013-10-22 Thread Gino Pirelli
I think the maintainer was working on it as you can see in the commits https://github.com/rduivenvoorde/xytools/commit/554645bea2e60c1ffc47da47607d93e25c8d9c6f did you asked to him? ciao Luigi Pirelli (luigi.pire...@faunalia.it) On 22 October 2013 08:30, Victor Gonzalez

Re: [Qgis-developer] Excel export

2013-10-22 Thread Richard Duivenvoorde
On 22-10-13 08:30, Victor Gonzalez wrote: Hi all, I need to export some attribute tables from QGIS in .xls format. As far as I know, the XYTools plugin [1] does what I want, but it does not work with QGIS 2.0 yet, right? I can update it and contribute the changes, but I would like to know

Re: [Qgis-developer] Excel Export from QGIS attribute table

2012-02-05 Thread Yves Jacolin (free)
Hello, I've just sucessfully used it with QGIS to open an ods file into QGIS. It works fine! Thanks Even, Y. Le vendredi 3 février 2012 19:39:57, Even Rouault a écrit : Le jeudi 01 décembre 2011 09:41:12, Even Rouault a écrit : I'd be much more interested in reading of xls, xlsx, ods etc

Re: [Qgis-developer] Excel Export from QGIS attribute table

2012-02-03 Thread Even Rouault
Le jeudi 01 décembre 2011 09:41:12, Even Rouault a écrit : 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

[Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread Andreas Neumann
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

Re: [Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread Alex Mandel
On 12/01/2011 12:19 AM, Andreas Neumann wrote: 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

Re: [Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread Andreas Neumann
Hi Alex, My biggest question is why do you need anything other than CSV? Excel and OpenOffice both open CSV automatically already. Both also open dbf, though saving back to either csv or dbf can be extremely tricky. Not to mention everything else scientific can use csv - for example R,

Re: [Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread Even Rouault
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

Re: [Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread Alex Mandel
On 12/01/2011 12:32 AM, Andreas Neumann wrote: Hi Alex, My biggest question is why do you need anything other than CSV? Excel and OpenOffice both open CSV automatically already. Both also open dbf, though saving back to either csv or dbf can be extremely tricky. Not to mention everything else

Re: [Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread Giovanni Manghi
Hi Andreas Who else would be interested in such functionality? this is one of the features qgis users/trainees ask more around here. So I guess that if they represent a part of the qgis users universe, such feature will interest quite a lot of people :) cheers -- Giovanni --

Re: [Qgis-user] Re: [Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread Filipe Silva Dias
Hello, I agree that such a tool would be very useful for many people. In my work I frequently have to collect environmental variables in a GIS and then export them to Excel/Calc for processing. To be able to this quickly with a few clicks would save me (and many people) a lot of time and

Re: [Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread Yves Jacolin
Alex, Le jeudi 01 décembre 2011 09:26:45, Alex Mandel a écrit : Both also open dbf, though saving back to either csv or dbf can be extremely tricky. Microsoft Office 2010 don't open nor create DBF files anymore (that's what said one of my customer this week)! I agree that if we (user) can

Re: [Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread Etienne Tourigny
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.roua...@mines-paris.org wrote: I'd be

Re: [Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread Andreas Neumann
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

Re: [Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread 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

Re: [Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread Guy Roussin
Hi Microsoft Office 2010 don't open nor create DBF files anymore (that's what said one of my customer this week)! You can open but not save DBF files with Microsoft Excel 2010. http://office.microsoft.com/en-us/excel-help/file-formats-that-are-supported-in-excel-HP010014103.aspx -- Guy

Re: [Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread Yves Jacolin (free)
Le jeudi 1 décembre 2011 17:50:29, Guy Roussin a écrit : Hi Microsoft Office 2010 don't open nor create DBF files anymore (that's what said one of my customer this week)! You can open but not save DBF files with Microsoft Excel 2010.