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 <[email protected]>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 <[email protected]> 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 < >> [email protected]> 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 < >>> [email protected]> 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 >>>> [email protected] >>>> http://lists.osgeo.org/mailman/listinfo/qgis-user >>>> >>> >>> >>> _______________________________________________ >>> Qgis-user mailing list >>> [email protected] >>> http://lists.osgeo.org/mailman/listinfo/qgis-user >>> >>> >> >
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
