Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!selfless.tophat.at!newsfeed.xs4all.nl!newsfeed6.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:in-reply-to:references:from:date :x-google-sender-auth:message-id:subject:to:cc:content-type :content-transfer-encoding; b=LgMb6KYemAXo4xmhcFDWIeymgSlJBJqYVr+xrcRUHKRCk7H5ogeHXrogLLdkav+gyu XFCxpiwol0cFYJskS6H8u8nug1OxLHWDuHZy6kOOoLWAeyMJDDWcGNMdJBL+hJFaARS9 885/lLHf8enRojoO2I7pGNMVxw4S/ErxfuwwE=
MIME-Version: 1.0
Sender: kushal.kumaran@gmail.com
In-Reply-To: <abce1ec7-2265-451f-ac5b-1a3aa79e3fae@22g2000prx.googlegroups.com>
References: <9ad94241-e281-4325-9c0d-23547ad0b9b9@glegroupsg2000goo.googlegroups.com> <85318329-5bc8-4474-a54e-4e7ff53cd304@k3g2000prl.googlegroups.com> <mailman.2396.1307040552.9059.python-list@python.org> <abce1ec7-2265-451f-ac5b-1a3aa79e3fae@22g2000prx.googlegroups.com>
From: Kushal Kumaran <kushal.kumaran+python@gmail.com>
Date: Fri, 3 Jun 2011 18:11:21 +0530
Subject: Re: How to import data from MySQL db into excel sheet -- Very Urgent
To: hisan <santosh.ssit@gmail.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Cc: python-list@python.org
Precedence: list
Newsgroups: comp.lang.python
Message-ID: <mailman.2428.1307104903.9059.python-list@python.org>
Lines: 87
NNTP-Posting-Host: 82.94.164.166
Xref: x330-a1.tempe.blueboxinc.net comp.lang.python:6938

On Fri, Jun 3, 2011 at 5:52 PM, hisan <santosh.ssit@gmail.com> wrote:
> Task i need to achieve here is:
> I need to write a python script which fetches all the data from the
> MySQL database and dumps into an excel sheet. since i was not able to
> dump the data into excel sheet i used CSV file which looks similar to
> excel sheet.
> on dumping the data into CSV file i came know that column width is too
> small and hence it was not possible to display data properly.
> Hence i requested the way to increase the column widht to accommodate
> data of any length.
>

The xlwt module lets you write excel files from python.  There is more
information at http://www.python-excel.org/.  The examples page has an
example called col_width.py, which should be what you need.

> below is my sample code
>
>
> import os,time
> import MySQLdb
> import csv
> db=3DMySQLdb.Connect("localhost","root","san123","phone")
> cursor=3Ddb.cursor()
>
> cursor.execute("select column_name from information_schema.columns
> where table_name=3D'phonebook'")
> row=3Dcursor.fetchall()
> f=3Dopen(os.getcwd()+"\\analytics.csv",'w')
> writer =3D csv.writer(f)
> writer.writerow(row)
> cursor.execute("select * from phonebook")
> col_val=3Dcursor.fetchall()
> writer.writerows(col_val)
> f.close()
>
> My Main objective is to fetch the data and from database and dump it
> into excel sheet or csv file using Python.
> If there any ways to achieve this using python please let me know.
>
> Waiting for the early response-
>
> I need to achieve my task using python only
>
>
>
>
>
>
> On Jun 2, 2:48=C2=A0pm, Dennis Lee Bieber <wlfr...@ix.netcom.com> wrote:
>> On Thu, 2 Jun 2011 10:25:24 -0700 (PDT), hisan <santosh.s...@gmail.com>
>> declaimed the following in gmane.comp.python.general:
>>
>>
>>
>> > Currently i am importing the Database into CSV file using csv module,
>> > in csv file i need to change the column width according the size of
>> > the data. i need to set different column width for different columns
>> > pleas let me know how to achieve this
>>
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 Since CSV files are purely text, no Excel Sp=
readsheet visual
>> attributes can be defined in them...
>>
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 Take Python out of the equation.
>>
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 How would you change column width using an E=
xcel VBA script/macro?
>>
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 When you can answer that, you will have the =
answer of how to do it
>> from Python...
>> --
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 Wulfraed =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 Dennis Lee Bieber =C2=A0 =C2=A0 =C2=A0 =C2=A0 AF6VN
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 wlfr...@ix.netcom.com =C2=A0 =C2=A0HTTP://wl=
fraed.home.netcom.com/
>
> --
> http://mail.python.org/mailman/listinfo/python-list
>



--=20
regards,
kushal