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

[Brad Nesom]

hmm,
unless it has to do with the version exported, I thought that it was excel.

On Thu, Dec 15, 2011 at 4:24 PM, Filipe Silva Dias <filipesdias at gmail.com>wrote:

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