[SATLUG] Need scripting assistance
jjsa at gvtc.com
Sat Dec 22 07:42:43 CST 2007
Python has a module xlrd that makes it real easy to read and process
excel files. I've read and processed similar sized spreadsheets with
this combo and no problems.
Brian Lewis wrote:
>> A large (perhaps a 500MB) spreadsheet full of contacts. The info
>> contains an account number, first name, last name, email address.
>> How would I go about extracting every email address from the
>> spreadsheet into a text file, on their own line ie.
>> johndoe at foo.com
>> janedoe at foo.com
>> bob at foo.com
>> etc etc
>> Is this even possible?
>> Even better,
>> johndoe at foo.com; janedoe at foo.com; bob at foo.com
>> In increments of about 200.
>> Before anyone else asks, this is not for spam.. I would like to
>> contact all the customers in our system, and unfortunately, all the
>> data is in an excel spreadsheet :/ I don't really want to cp+p every
>> single address (well over 100,000) into emails. I would happily copy
>> and paste blocks of 200 :)
>> Any advice would help!
>> Thanks gang,
>> Not sent from my iphone, this one was sent using PINE (best email
>> client EVER)
More information about the SATLUG