[Qgis-user] new xytools plugin: now open and save simple Excel files

[Brad Nesom]

Filipe,
  You should note that excel does that on it's own.
if you look at your data and there is a small green triangle in the upper
left corner, that means the data is "available" to be formated as numeric.
simply select all the cells that show that (don't select the column heading
name) and then go to the top of the selection. (a little tricky to explain
further).
There is a "yellow" exclamation mark to the left. carefully hover cursor to
the left over the mark then pick the down arrow that appears.
select "convert to number".
there ya go.
On Thu, Dec 15, 2011 at 3:59 PM, Filipe Silva Dias <filipesdias at gmail.com>wrote:

> Thanks Richard. This tool was on my "Top ten list of things that would
> make my work a lot less annoying".
>
> Possible problem: exported the attribute table of a shapefile to an Excel
> spreadsheet, but the values of the columns appeared formated as characters
> (even though they're numbers). Anyonelse can confirm this?
>
> Best regards
> Filipe
>
> On Thu, Dec 15, 2011 at 8:33 PM, Richard Duivenvoorde <rdmailings at duif.net
> > wrote:
>
>> Hi List,
>>
>> I uploaded a new version of the xytools plugin. After some questions and
>> discussion on the list about Excel files, I added simple capability to
>> open and save excel files.
>>
>> It uses the python xlw and xlrd libs for that
>> (http://www.python-excel.org/). Those are available for windows users in
>> the osgeo4w package. Linux users can probably get it from there package
>> manager. If all fails, go to http://www.python-excel.org/ and get it
>> from there.
>>
>> In short: it can save the attributes of a vector layer to a simple (one
>> worksheet containing) xls file.
>> It can open an xls file and load it in a memory layer. You can either
>> point to an x and y column, and those values will be used for the x and
>> y of the Point features. Or you can cancel choosing the x and y, and the
>> attribute data will just be loaded taking 0/0 as x and y coordinates.
>>
>> There is a help file availabe via the xytools plugin menu with more
>> information.
>>
>> Let me know if you find problems with it or have ideas to improve (see
>> docs for earlier ideas).
>>
>> plugin via plugin menu
>> or
>> http://plugins.qgis.org/plugins/xytools/
>>
>> source
>> http://hub.qgis.org/projects/xytools/repository
>>
>> project page
>> http://hub.qgis.org/projects/xytools
>>
>> Regards,
>>
>> Richard Duivenvoorde
>>
>> ps if you find the plugin really usefull, I'm also trying out paypal
>> buttons on the project page :-) Half of the profit (?) goes to the qgis
>> project for this one I promised Paolo and Tim...
>>
>>
>>
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20111215/3b14382c/attachment.html>