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

[Filipe Silva Dias]

Thx Brad. That works fine.

But was wondering if there was a way to prevent Excel from doing this. The
equivalent function in Xtools Pro (ArcGIS) exports the data to Excel "as
they are" with no need to convert characters into numbers.

I forgot to mention before: if Richard hadnt introduced the plugin and its
functionality in this list, I would never have guessed from the name of
plugin, that it included the function "export table to excel".

Thanks



On Thu, Dec 15, 2011 at 10:14 PM, Brad Nesom <gisbradokla at live.com> wrote:

> 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/bade09e3/attachment.html>