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
