Stack Overflow
Stack Overflow

Questions tagged [xlwt]

Library to create spreadsheet files compatible with MS Excel 97/2000/XP/2003 XLS files, on any platform.

xlwt is a Python library for modifying and generating spreadsheet files that are compatible with Excel 97/2000/XP/2003, OpenOffice.org Calc, and Gnumeric.

xlwt does not (yet) support Excel 2007 (.xlsx, .xlsm) writing.

xlwt has full support for Unicode. Excel spreadsheets can be generated on any platform without needing Excel or a COM server. The only requirement is Python 2.3 or higher. xlwt is a fork of pyExcelerator.

http://pypi.python.org/pypi/xlwt

640 questions
-2
votes
1 answer

Please point out my mistake in the following program

Here m trying to extract a list of blacklist IP from a specific site and trying to make an excel sheet of the following fields : IP , date ...... New updated code is : import xlwt import urllib def Bl(): link =…
Tejas
  • 1
  • 1
-2
votes
1 answer

How to fetch data from a webpage and paste it into excel

I'm trying to fetch some info from this Link. The data i wanna fetch is that company name, email, phone, location and paste it in the excel sheet. Please suggest some fromework / a way to scrape the data and write it to the xls. I know xlwt is one…
Python Learner
  • 129
  • 1
  • 11
-2
votes
1 answer

How to read and write data in Microsoft excel 2010 in python

Steps what I have done 1.Reading input data from xlsx file 2.calculated week number and total hours done by each department Need to do: 1.Reading particular row column from another existing xlsx sheet 2.writing total hours for each department in…
doubts
  • 157
  • 1
  • 1
  • 9
-2
votes
3 answers

Write in Excel using xlwt

I am trying to list out all the directories in my F: drive and write the names into excel. For this I am using Python and xlwt. I am getting some error while writing the names of the file in the excel.I tried to use for loop to increase row number…
Praveenks
  • 1,436
  • 9
  • 40
  • 79
-2
votes
1 answer

How to use python to delete a column and rows in excel, that contains certain values

Just trying to get python to open a file, read a file, do value set in which if the data that has a 1.00 and has another value thats over 0.93 in that row/column then it gets deleted, if not then go over row/column to the next row/column, both…
user3802685
  • 65
  • 1
  • 7
-2
votes
2 answers

how to append particular excel cell value using python?

cell (1,1) should have "Put me in same cell": import xlwt book = xlwt.Workbook() sheet = book.add_sheet('Sheet1') sheet.write(1, 1, "Put me") n=10 if n>0: sheet.write(1, 1, "in same cell")
Rahul
  • 1
  • 1
  • 3
-2
votes
4 answers

Is it possible to push data from Excel sheet using Python into a database?

I have a requirement where using Python I need to write into excel cell , the data which i will be collecting from web page. But not getting an option how to do that. any idea from you people? As per @Marcin comments here is the more clear…
Arup Rakshit
  • 116,827
  • 30
  • 260
  • 317
-3
votes
1 answer

Export python dictionary contaning list values into Excel sheet

Below is my sample dictionary. dict1 = {'X':[['a','1'], ['b','3'], ['c','2']], 'Y':[['a','8'], ['b','13']], 'Z':[['a','5'], ['b','7'], ['f','8']]} I am trying to get the below output in excel sheet using xlwt module. X a …
user3484464
  • 11
  • 6
-3
votes
1 answer

Format individual characters differently within an Excel cell

I have a column in Excel 2013 containing letters and the digits 1,2,3 and 4 (representing pinyin pronunciations and tone values). They are all in the same font & format, but I would like to convert the numbers only to superscript. It does not seem…
user2850117
  • 3
  • 1
  • 2
-4
votes
1 answer

Copying a column from a csv file to a xls file

I am trying to copy a column from a csv file to a spreadsheet in an excel file. However, for some reason the values from csv files aren't getting copied in the spreadsheet. The program compiles without any errors and all the statements are getting…
user3262537
  • 127
  • 1
  • 1
  • 7
1 2 3
…
42
43