Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!feeder.news-service.com!news2.euro.net!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
From: "Prasad, Ramit" <ramit.prasad@jpmchase.com>
To: "'python-list@python.org'" <python-list@python.org>
Date: Mon, 6 Jun 2011 16:18:30 -0400
Subject: RE: How to import data from MySQL db into excel sheet
Thread-Topic: How to import data from MySQL db into excel sheet
Thread-Index: Acwkefc1EmDNSaJyRpaO8//niuhhZgAC8yNA
References: <9ad94241-e281-4325-9c0d-23547ad0b9b9@glegroupsg2000goo.googlegroups.com> <85318329-5bc8-4474-a54e-4e7ff53cd304@k3g2000prl.googlegroups.com> <0604E20B5F6F2F4784C9C8C71C5DD4DD2E348A0CA3@EMARC112VS01.exchad.jpmchase.net> <BANLkTim3FVpeE6L_G_OFCtRPawUFyyh-QA@mail.gmail.com>
In-Reply-To: <BANLkTim3FVpeE6L_G_OFCtRPawUFyyh-QA@mail.gmail.com>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Precedence: list
Newsgroups: comp.lang.python
Message-ID: <mailman.2507.1307393775.9059.python-list@python.org>
Lines: 38
NNTP-Posting-Host: 82.94.164.166
Xref: x330-a1.tempe.blueboxinc.net comp.lang.python:7110

>>> Currently i am importing the Database into CSV file using csv module, =
=0D=0A>>>in csv file i need to change the column width according the size o=
f =0D=0A>>>the data=2E i need to set different column width for different c=
olumns =0D=0A>>>pleas let me know how to achieve this=0D=0A=0D=0A>xlwt is a=
 package for editing Excel files=2E CSV, despite being a format=0D=0A>that =
Excel can open, is not an Excel file=2E A CSV is to spreadsheets=0D=0A>what=
 plain text is to word processing=2E It's an extremely simple, easy=0D=0A>t=
o use format programaticfally but it doesn't support any formattting=0D=0A>=
of any kind=2E=0D=0A=0D=0ATopic says importing into excel, so I assume the =
OP is *currently* using CSV but wants to *switch* to Excel=2E If that is tr=
ue then the following is the syntax for it=2E Assuming you open a workbook =
and create a worksheet within with a local name of "sheet"=2E=0D=0A=0D=0A> =
sheet=2Ecol(9)=2Ewidth =3D 3200=0D=0A=0D=0A=0D=0ARamit=0D=0A=0D=0A=0D=0ARam=
it Prasad | JPMorgan Chase Investment Bank | Currencies Technology=0D=0A712=
 Main Street | Houston, TX 77002=0D=0Awork phone: 713 - 216 - 5423=0D=0A=0D=
=0AThis communication is for informational purposes only=2E It is not=0D=0A=
intended as an offer or solicitation for the purchase or sale of=0D=0Aany f=
inancial instrument or as an official confirmation of any=0D=0Atransaction=
=2E All market prices, data and other information are not=0D=0Awarranted as=
 to completeness or accuracy and are subject to change=0D=0Awithout notice=
=2E Any comments or statements made herein do not=0D=0Anecessarily reflect =
those of JPMorgan Chase & Co=2E, its subsidiaries=0D=0Aand affiliates=2E=0D=
=0A=0D=0AThis transmission may contain information that is privileged,=0D=
=0Aconfidential, legally privileged, and/or exempt from disclosure=0D=0Aund=
er applicable law=2E If you are not the intended recipient, you=0D=0Aare he=
reby notified that any disclosure, copying, distribution, or=0D=0Ause of th=
e information contained herein (including any reliance=0D=0Athereon) is STR=
ICTLY PROHIBITED=2E Although this transmission and any=0D=0Aattachments are=
 believed to be free of any virus or other defect=0D=0Athat might affect an=
y computer system into which it is received and=0D=0Aopened, it is the resp=
onsibility of the recipient to ensure that it=0D=0Ais virus free and no res=
ponsibility is accepted by JPMorgan Chase &=0D=0ACo=2E, its subsidiaries an=
d affiliates, as applicable, for any loss=0D=0Aor damage arising in any way=
 from its use=2E If you received this=0D=0Atransmission in error, please im=
mediately contact the sender and=0D=0Adestroy the material in its entirety,=
 whether in electronic or hard=0D=0Acopy format=2E Thank you=2E=0D=0A=0D=0A=
Please refer to http://www=2Ejpmorgan=2Ecom/pages/disclosures for=0D=0Adisc=
losures relating to European legal entities=2E