Re: Creating a Super Simple WWW Link, Copy, & Paste into Spreadsheet Program

Path	csiph.com!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!feeder.erje.net!eu.feeder.erje.net!newsfeed.xs4all.nl!newsfeed4.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path	<hermanmu@gmail.com>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.120
X-Spam-Level	*
X-Spam-Evidence	'H': 0.76; 'S': 0.00; 'python.': 0.02; 'subject:into': 0.09; 'cc:addr:python-list': 0.11; 'adept': 0.16; 'adjacent': 0.16; 'hyperlink': 0.16; 'wrote:': 0.18; 'thu,': 0.19; 'help.': 0.21; 'cc:addr:python.org': 0.22; 'cc:20': 0.24; 'cc:no real name:20': 0.24; 'help!': 0.26; 'excel': 0.26; 'header:In- Reply-To:1': 0.27; 'michael': 0.29; 'said,': 0.30; 'message- id:@mail.gmail.com': 0.30; "i'm": 0.30; 'url:mailman': 0.30; '13,': 0.31; 'lot.': 0.31; 'sites.': 0.31; 'this.': 0.32; 'url:python': 0.33; "i'd": 0.34; 'received:google.com': 0.35; 'there': 0.35; 'combination': 0.36; 'subject:Simple': 0.36; 'url:listinfo': 0.36; 'hi,': 0.36; 'url:org': 0.36; 'easily': 0.37; 'starting': 0.37; 'thank': 0.38; 'e.g.': 0.38; 'pm,': 0.38; 'url:mail': 0.40; 'how': 0.40; 'easy': 0.60; 'greatest': 0.60; 'number,': 0.60; 'then,': 0.60; 'new': 0.61; 'simple': 0.61; 'back': 0.62; 'show': 0.63; 'to:addr:gmail.com': 0.65; 'charset:windows-1252': 0.65; 'population': 0.68; 'internet': 0.71; 'excel,': 0.84; 'hyperlinks': 0.91; '2013': 0.98
DKIM-Signature	v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type:content-transfer-encoding; bh=NC5+FP9tOGoERglQW2QRYidsc7c0hKZ3E1HuFGeZmAU=; b=cVzTDZ/lWCsnCpHGauFtoWd6WFlnNEZof1LA3DC+0oO/+N01CLAm4su+R7lrvgsQwt 0S6pPTDlyhs/oyc4sTk9o+42Uc8ZNoW77v96eLQkio1cPwRlJG0n0Cbo3vNuB6ByuAQM Vx08+5Ob6mGkOf5dUJ2MV9BOCcvdtGzDhpeJbIjqsUBR9RxqLkvbdsJhHhUOwdP6HKdf mO0R7MxaVt7ngkRX5eiCxW5b5UAAtQahwNMdM4nkj6gTxv24VHbojMlGzHyHvhTTydSv HZCZxqvAq7leAit91KOiNhGh8sMwtHFUhBMYVlWAiKylSUDAwrF26klrNDu4cnkNAf3y iLsg==
X-Received	by 10.180.39.236 with SMTP id s12mr1576544wik.14.1371222169248; Fri, 14 Jun 2013 08:02:49 -0700 (PDT)
MIME-Version	1.0
In-Reply-To	<34b25d59-63b8-44e7-ac10-0afc52a7d726@googlegroups.com>
References	<34b25d59-63b8-44e7-ac10-0afc52a7d726@googlegroups.com>
From	Michael Herman <hermanmu@gmail.com>
Date	Fri, 14 Jun 2013 08:02:28 -0700
Subject	Re: Creating a Super Simple WWW Link, Copy, & Paste into Spreadsheet Program
To	buford.lumbar@gmail.com
Content-Type	text/plain; charset=windows-1252
Content-Transfer-Encoding	quoted-printable
Cc	python-list@python.org
X-BeenThere	python-list@python.org
X-Mailman-Version	2.1.15
Precedence	list
List-Id	General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe	<http://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive	<http://mail.python.org/pipermail/python-list/>
List-Post	<mailto:python-list@python.org>
List-Help	<mailto:python-list-request@python.org?subject=help>
List-Subscribe	<http://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups	comp.lang.python
Message-ID	<mailman.3311.1371222176.3114.python-list@python.org> (permalink)
Lines	34
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1371222176 news.xs4all.nl 15876 [2001:888:2000:d::a6]:51604
X-Complaints-To	abuse@xs4all.nl
Xref	csiph.com comp.lang.python:48159

Show key headers only | View raw

Hi there -

Yes, as others have said, this is not an easy project. That said, it
can be down. I'd use a combination of DataNitro, to connect with
Excel, and Scrapy, to easily scrap and crawl the sites. I'm adept at
both and would be happy to help you with this. Email me at
michael@mherman.org for help.

Best,

Michael

On Thu, Jun 13, 2013 at 12:28 PM, <buford.lumbar@gmail.com> wrote:
>
> Hi, I'm new to Python. Would someone be able to write me and/or to show me
> how to write a simple program that:
>
> 1-follows a hyperlink from MS Excel to the internet (one of many links
> like this, http://www.zipdatamaps.com/76180, for e.g.) and then,
>
> 2-copies some data (a population number, e.g. 54195) and then,
>
> 3-pastes that data back into the same MS Excel spreadsheet, into the
> adjacent cell.
>
> ... and that’s it... row after row of hyperlinks all in one column...
>
> Please, please help me my wrist is starting to hurt a lot. You would have
> my greatest appreciation for your help!
>
> thank you, Buford
> --
> http://mail.python.org/mailman/listinfo/python-list

Back to comp.lang.python | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Creating a Super Simple WWW Link, Copy, & Paste into Spreadsheet Program buford.lumbar@gmail.com - 2013-06-13 12:28 -0700
  Re: Creating a Super Simple WWW Link, Copy, & Paste into Spreadsheet Program Joel Goldstick <joel.goldstick@gmail.com> - 2013-06-13 15:41 -0400
    Re: Creating a Super Simple WWW Link, Copy, & Paste into Spreadsheet Program buford.lumbar@gmail.com - 2013-06-13 13:18 -0700
  Re: Creating a Super Simple WWW Link, Copy, & Paste into Spreadsheet Program Dave Angel <davea@davea.name> - 2013-06-13 16:08 -0400
  Re: Creating a Super Simple WWW Link, Copy, & Paste into Spreadsheet Program Ian Kelly <ian.g.kelly@gmail.com> - 2013-06-13 14:42 -0600
  RE: Creating a Super Simple WWW Link, Copy, & Paste into Spreadsheet Program Nick Cash <nick.cash@npcinternational.com> - 2013-06-13 21:10 +0000
    Re: Creating a Super Simple WWW Link, Copy, & Paste into Spreadsheet Program Neil Cerutti <neilc@norwich.edu> - 2013-06-14 12:50 +0000
  Re: Creating a Super Simple WWW Link, Copy, & Paste into Spreadsheet Program Steven D'Aprano <steve+comp.lang.python@pearwood.info> - 2013-06-14 03:02 +0000
    Re: Creating a Super Simple WWW Link, Copy, & Paste into Spreadsheet Program buford.lumbar@gmail.com - 2013-06-14 07:03 -0700
  Re: Creating a Super Simple WWW Link, Copy, & Paste into Spreadsheet Program rusi <rustompmody@gmail.com> - 2013-06-13 21:43 -0700
  Re: Creating a Super Simple WWW Link, Copy, & Paste into Spreadsheet Program Denis McMahon <denismfmcmahon@gmail.com> - 2013-06-14 11:48 +0000
  Re: Creating a Super Simple WWW Link, Copy, & Paste into Spreadsheet Program Michael Herman <hermanmu@gmail.com> - 2013-06-14 08:02 -0700

csiph-web