Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!selfless.tophat.at!newsfeed.xs4all.nl!newsfeed5.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail Return-Path: X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org X-Spam-Status: OK 0.037 X-Spam-Evidence: '*H*': 0.93; '*S*': 0.00; 'completeness': 0.05; 'width': 0.07; '>in': 0.09; 'csv': 0.09; '712': 0.16; 'affiliates,': 0.16; 'columns': 0.16; 'currencies': 0.16; 'opened,': 0.16; 'received:155.180': 0.16; 'received:159.53': 0.16; 'received:159.53.110': 0.16; 'received:169.70': 0.16; 'received:bankone.net': 0.16; 'received:exchad.jpmchase.net': 0.16; 'received:jpmchase.com': 0.16; 'received:jpmchase.net': 0.16; 'received:svr.bankone.net': 0.16; 'solicitation': 0.16; 'subject:import': 0.16; 'url:disclosures': 0.16; 'url:jpmorgan': 0.16; 'importing': 0.19; 'to:2**1': 0.20; 'header:In-Reply-To:1': 0.21; 'column': 0.22; 'applicable,': 0.23; 'herein': 0.23; 'module,': 0.23; 'received:169': 0.25; 'received:169.254': 0.25; 'subject:data': 0.26; 'reflect': 0.28; 'manually': 0.29; 'subject:How': 0.30; '>the': 0.30; 'chase': 0.30; 'received:155': 0.30; 'received:159': 0.30; 'received:169.254.1': 0.30; '(including': 0.32; 'represents': 0.32; 'to:addr:python-list': 0.33; 'file': 0.34; 'thank': 0.35; 'using': 0.35; 'phone:': 0.36; 'format.': 0.36; 'accepted': 0.36; 'charset:us-ascii': 0.36; 'data.': 0.37; 'change': 0.37; 'accuracy': 0.37; 'arising': 0.37; 'subject:from': 0.38; 'data': 0.38; 'purposes': 0.38; 'subject:: ': 0.38; 'comments': 0.39; 'legally': 0.39; 'to:addr:python.org': 0.39; 'under': 0.40; 'you.': 0.62; 'subject': 0.62; 'according': 0.63; 'market': 0.63; 'virus': 0.63; 'free': 0.63; 'applicable': 0.65; 'co.,': 0.65; 'contact': 0.66; 'relating': 0.67; 'legal': 0.70; 'offer': 0.71; 'sale': 0.76; 'bank': 0.76; 'investment': 0.78; 'purchase': 0.83; 'affiliates.': 0.84; 'prices,': 0.84; '3200': 0.91; 'defect': 0.91; 'instrument': 0.95; 'notice.': 0.96 X-DKIM: Sendmail DKIM Filter v2.8.4 sj3.jpmchase.com p56GZsBD011669 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=jpmchase.com; s=smtpout; t=1307378154; bh=eLOuracX68fSpwnJn95MaklOr3eqxF4jeUolYtJtvtM=; h=From:To:Date:Subject:Message-ID:References:In-Reply-To: Content-Transfer-Encoding:MIME-Version:Content-Type; b=G7+2lEqJcibsQ23S9uzZMHPZCwg1Ty2iV4M7zIcAQyizgoTUfKCpwmGGktm/wj5SQ nc4QZ3fFXJoxA8+KCoMY9gstDulGrz8/0mOp8Z7kWb9vNho8MezkZ3+k9ml5mEX8K/ L/J8gzaD3hecvMcJKxMOhzAXBYTyGCZWqQDw37L8= From: "Prasad, Ramit" To: "'hisan'" , "'python-list@python.org'" Date: Mon, 6 Jun 2011 12:35:43 -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: AcwhS1n3q7uKMduhTeO5gqlRSHnZ0ADHB9UA References: <9ad94241-e281-4325-9c0d-23547ad0b9b9@glegroupsg2000goo.googlegroups.com> <85318329-5bc8-4474-a54e-4e7ff53cd304@k3g2000prl.googlegroups.com> In-Reply-To: <85318329-5bc8-4474-a54e-4e7ff53cd304@k3g2000prl.googlegroups.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-DLP-FWD: Yes Content-Type: text/plain; charset="us-ascii" X-BeenThere: python-list@python.org X-Mailman-Version: 2.1.12 Precedence: list List-Id: General discussion list for the Python programming language List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Newsgroups: comp.lang.python Message-ID: Lines: 32 NNTP-Posting-Host: 82.94.164.166 X-Trace: 1307378163 news.xs4all.nl 49184 [::ffff:82.94.164.166]:58881 X-Complaints-To: abuse@xs4all.nl Xref: x330-a1.tempe.blueboxinc.net comp.lang.python:7094 > 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 of=0D= =0A>the data=2E i need to set different column width for different columns= =0D=0A>pleas let me know how to achieve this=0D=0A=0D=0AIf you are using xl= wt:=0D=0Asheet=2Ecol(9)=2Ewidth =3D 3200=0D=0A=0D=0AI am not sure exactly w= hat unit the 3200 represents so I just adjust this manually to be a size th= at works for me=2E=0D=0A=0D=0A=0D=0ARamit=0D=0A=0D=0A=0D=0A=0D=0ARamit Pras= ad | JPMorgan Chase Investment Bank | Currencies Technology=0D=0A712 Main S= treet | Houston, TX 77002=0D=0Awork phone: 713 - 216 - 5423=0D=0A=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