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 Return-Path: X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org X-Spam-Status: OK 0.000 X-Spam-Evidence: '*H*': 1.00; '*S*': 0.00; 'attributes': 0.05; '-0700': 0.07; 'width': 0.07; 'python': 0.08; 'csv': 0.09; 'received:80.91': 0.09; 'received:80.91.229': 0.09; 'received:80.91.229.12': 0.09; 'received:gmane.org': 0.09; 'received:list': 0.09; 'received:lo.gmane.org': 0.09; 'defined': 0.14; 'bieber': 0.16; 'columns': 0.16; 'declaimed': 0.16; 'email addr:ix.netcom.com': 0.16; 'email name:wlfraed': 0.16; 'equation.': 0.16; 'from:addr:ix.netcom.com': 0.16; 'from:addr:wlfraed': 0.16; 'from:name:dennis lee bieber': 0.16; 'received:66.245': 0.16; 'received:dsl.mindspring.com': 0.16; 'received:mindspring.com': 0.16; 'received:wlfraed': 0.16; 'subject:import': 0.16; 'them...': 0.16; 'url:netcom': 0.16; 'url:wlfraed': 0.16; 'wulfraed': 0.16; 'importing': 0.19; 'column': 0.22; 'thu,': 0.22; 'module,': 0.23; 'url:home': 0.25; 'subject:data': 0.26; 'lee': 0.29; 'subject:How': 0.30; 'header:X -Complaints-To:1': 0.32; 'to:addr:python-list': 0.33; 'file': 0.34; 'that,': 0.34; 'purely': 0.35; 'using': 0.35; 'charset:us- ascii': 0.36; 'data.': 0.37; 'change': 0.37; 'received:org': 0.38; 'subject:from': 0.38; 'subject:: ': 0.38; 'header:Mime-Version:1': 0.39; 'to:addr:python.org': 0.39; 'according': 0.63; 'dennis': 0.77; 'vba': 0.84 X-Injected-Via-Gmane: http://gmane.org/ To: python-list@python.org From: Dennis Lee Bieber Subject: Re: How to import data from MySQL db into excel sheet Date: Thu, 02 Jun 2011 11:48:58 -0700 Organization: > Bestiaria Support Staff < References: <9ad94241-e281-4325-9c0d-23547ad0b9b9@glegroupsg2000goo.googlegroups.com> <85318329-5bc8-4474-a54e-4e7ff53cd304@k3g2000prl.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Gmane-NNTP-Posting-Host: user-11fa49i.dsl.mindspring.com X-Newsreader: Forte Agent 3.3/32.846 X-No-Archive: YES 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: 22 NNTP-Posting-Host: 82.94.164.166 X-Trace: 1307040553 news.xs4all.nl 49038 [::ffff:82.94.164.166]:59944 X-Complaints-To: abuse@xs4all.nl Xref: x330-a1.tempe.blueboxinc.net comp.lang.python:6878 On Thu, 2 Jun 2011 10:25:24 -0700 (PDT), hisan 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 Since CSV files are purely text, no Excel Spreadsheet visual attributes can be defined in them... Take Python out of the equation. How would you change column width using an Excel VBA script/macro? When you can answer that, you will have the answer of how to do it from Python... -- Wulfraed Dennis Lee Bieber AF6VN wlfraed@ix.netcom.com HTTP://wlfraed.home.netcom.com/