<div><font size=2 color=navy face=Arial>
I did find a bunch of ways to put dots on individual points but none off the shelf to make lines between two points. <br></font></div>
<br><div><hr size=2 width="100%" align=center tabindex=-1>
<font face=Tahoma size=2>
<b>From</b>: cialug-bounces@cialug.org <cialug-bounces@cialug.org>
<br><b>To</b>: Central Iowa Linux Users Group <cialug@cialug.org>
<br><b>Sent</b>: Fri Aug 20 13:19:57 2010<br><b>Subject</b>: Re: [Cialug] Lazy programmer question
<br></font><br></div>
There are some mashups on the web that let you upload a spreadsheet of addresses. I've not seen one that lets you create multiple maps from one spreadsheet.<div><br></div><div>Somethign I do ocassionally (actually, its by far my #1 use of a spreadsheet) is to use a formula to spit out HTML.</div>
<div><br></div><div>For example, if A1 is address one and B1 is address 2 then I might create a formula in C1 like this:</div><div>="<a href='...?address="&A1&"'>adress 1</a> and <a href='...?address="&A2&"'>address 2</a>"</div>
<div><br></div><div>Then you fill down and copy the resulting column into an HTML doc.</div><div><br></div><div>That could come in handy with the static map api:</div><div><a href="http://code.google.com/apis/maps/documentation/staticmaps/">http://code.google.com/apis/maps/documentation/staticmaps/</a></div>
<div><br></div><div>Or with just a little looking I'll bet you could do the same to spit out javascript that uses the normal maps api.</div><div><br></div><div>I don't know it's possible to embed images into a spreadsheet where details about the image come from cell references. That would be pretty cool.</div>
<div><br></div><div>One more option is to upload your doc to google docs, switch to the older version and play with the map gadget. I gave it a quick glance and could not see how to feed it two addresses though.<br><br><div class="gmail_quote">
On Fri, Aug 20, 2010 at 12:27 PM, Dave Weis <span dir="ltr"><<a href="mailto:djweis@internetsolver.com">djweis@internetsolver.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<br>
I have a spreadsheet containing two addresses per line and I want to draw a (google or other) map with a line between each of those addresses. I would prefer it not to take the rest of the day.<br>
<br>
Any pointers on the most efficient method to give this to google maps?<br>
<br>
--<br>
Dave Weis<br>
515-224-9229<br>
<a href="mailto:djweis@internetsolver.com">djweis@internetsolver.com</a><br>
<a href="http://www.internetsolver.com/" target="_blank">http://www.internetsolver.com/</a><br>
Please check out our Complete Support Service<br>
<a href="http://www.internetsolver.com/completesupport/" target="_blank">http://www.internetsolver.com/completesupport/</a><br>
<br>
_______________________________________________<br>
Cialug mailing list<br>
<a href="mailto:Cialug@cialug.org">Cialug@cialug.org</a><br>
<a href="http://cialug.org/mailman/listinfo/cialug" target="_blank">http://cialug.org/mailman/listinfo/cialug</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Matthew Nuzum<br>newz2000 on freenode, skype, linkedin, <a href="http://identi.ca">identi.ca</a> and twitter<br><br>"Never stop learning" –Robert Nuzum (My dad)<br>
</div>