On 6/2/2011 5:11 AM, hisan wrote:
Please let me know how can i import my sql data of multiple rows and
columns into an excel sheet.
here i need to adjust the column width based on the on the data that
sits into the column
You're asking in the wrong forum. Try the MySQL forum or an
Excel for
>>> 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
>xlwt is a package for editing Excel
On Mon, Jun 6, 2011 at 9:35 AM, Prasad, Ramit wrote:
>> 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 achi
> 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
If you are using xlwt:
sheet.col(9).width = 3200
On Fri, Jun 3, 2011 at 5:52 PM, hisan 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
> exc
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
On Jun 2, 5:19 pm, Martin Brochhaus
wrote:
> Why do you need to do this with python? Why not output the SQL data as a .cvs
> and open that file in Excel. The user can then adjust column widths as he
> likes.
>
> If it has to be done programatically, you might want to start your journey
> here:h
