Thx Brad. That works fine.<br><br>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. <br>
<br>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". <br>
<br>Thanks<br><br><br><br><div class="gmail_quote">On Thu, Dec 15, 2011 at 10:14 PM, Brad Nesom <span dir="ltr"><<a href="mailto:gisbradokla@live.com">gisbradokla@live.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>Filipe,</div>
<div> You should note that excel does that on it's own.</div>
<div>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.</div>
<div>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). <br></div>
<div>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.</div>
<div>select "convert to number".</div>
<div>there ya go.<br></div><div><div></div><div class="h5">
<div class="gmail_quote">On Thu, Dec 15, 2011 at 3:59 PM, Filipe Silva Dias <span dir="ltr"><<a href="mailto:filipesdias@gmail.com" target="_blank">filipesdias@gmail.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT:#ccc 1px solid;MARGIN:0px 0px 0px 0.8ex;PADDING-LEFT:1ex" class="gmail_quote">Thanks Richard. This tool was on my "Top ten list of things that would make my work a lot less annoying".<br>
<br>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?<br><br>
Best regards<br>Filipe<br><br>
<div class="gmail_quote">On Thu, Dec 15, 2011 at 8:33 PM, Richard Duivenvoorde <span dir="ltr"><<a href="mailto:rdmailings@duif.net" target="_blank">rdmailings@duif.net</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT:#ccc 1px solid;MARGIN:0px 0px 0px 0.8ex;PADDING-LEFT:1ex" class="gmail_quote">Hi List,<br><br>I uploaded a new version of the xytools plugin. After some questions and<br>discussion on the list about Excel files, I added simple capability to<br>
open and save excel files.<br><br>It uses the python xlw and xlrd libs for that<br>(<a href="http://www.python-excel.org/" target="_blank">http://www.python-excel.org/</a>). Those are available for windows users in<br>the osgeo4w package. Linux users can probably get it from there package<br>
manager. If all fails, go to <a href="http://www.python-excel.org/" target="_blank">http://www.python-excel.org/</a> and get it<br>from there.<br><br>In short: it can save the attributes of a vector layer to a simple (one<br>
worksheet containing) xls file.<br>It can open an xls file and load it in a memory layer. You can either<br>point to an x and y column, and those values will be used for the x and<br>y of the Point features. Or you can cancel choosing the x and y, and the<br>
attribute data will just be loaded taking 0/0 as x and y coordinates.<br><br>There is a help file availabe via the xytools plugin menu with more<br>information.<br><br>Let me know if you find problems with it or have ideas to improve (see<br>
docs for earlier ideas).<br><br>plugin via plugin menu<br>or<br><a href="http://plugins.qgis.org/plugins/xytools/" target="_blank">http://plugins.qgis.org/plugins/xytools/</a><br><br>source<br><a href="http://hub.qgis.org/projects/xytools/repository" target="_blank">http://hub.qgis.org/projects/xytools/repository</a><br>
<br>project page<br><a href="http://hub.qgis.org/projects/xytools" target="_blank">http://hub.qgis.org/projects/xytools</a><br><br>Regards,<br><br>Richard Duivenvoorde<br><br>ps if you find the plugin really usefull, I'm also trying out paypal<br>
buttons on the project page :-) Half of the profit (?) goes to the qgis<br>project for this one I promised Paolo and Tim...<br><br><br><br>_______________________________________________<br>Qgis-user mailing list<br><a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br></blockquote></div><br><br>_______________________________________________<br>Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
<br></blockquote>
</div><br>
</div></div></blockquote></div><br>