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
-1
votes
1 answer

How to check if a header/footer exists in an excel sheet using xlrd/openpyxl or anyother package

I have a requirement where I need to check if header/footer exists in an excel page. If yes, I need to remove them. To remove I used openpyxl package and manipulated in a way that i copied the contents of excel to a new sheet and deleted the master…
avinash kumar
  • 5
  • 2
-1
votes
2 answers

How to get Python script to write to existing sheet

I am writing a Python script and stuck on one of the early steps. I am opening an existing sheet and want to add two columns so I have used this: #import the writer import xlwt #import the reader import xlrd #open the sussex results…
J4G
  • 211
  • 5
  • 14
-1
votes
1 answer

Python convert a list of .txt to .xls

I found this useful script to convert a list of .txt files to xls files. I'm still a Python newbie and having some trouble with fixing the error in my script. The script used is below: mypath = "I give my path here" from os import listdir from…
Atlas_Apple
  • 53
  • 8
-1
votes
1 answer

get content in between a matched pattern and next matched pattern using python

I am trying to write a python script to export text formated cisco firewall configuration file to excel for easy query and filtering. I am able to write acls and each fields into excel sheet tab. however for network objects I have a little…
Feng
  • 41
  • 7
-1
votes
1 answer

get data behind " , " to take phrase by python

I want to get data in Column D behind " , " in the end of the sentence from left to right to get phrase in link bio: [1]:( http://prntscr.com/fye9hi) "here" Someone cant help me please .... This is my code but it cant go like i want. import xlrd…
Minh Tuấn Ngô
  • 17
  • 1
  • 5
-1
votes
1 answer

read and write in excel file with python

I am trying to read the cell of a excel file in python, change its value and save it. If I do not have the line from xlutils.copy import copy in code, it recognizes workbook.sheeets(), but otherwise it says AttributeError: 'Workbook' object has…
Pegah
  • 672
  • 2
  • 13
  • 23
-1
votes
1 answer

Not printing anything on console

import Tkinter import tkMessageBox import xlwt from xlrd import open_workbook from tempfile import TemporaryFile from xlwt import Workbook import tkSimpleDialog import tkMessageBox from tkFileDialog import * top = Tkinter.Tk() #FSR def fsr(): …
user3848981
  • 11
  • 4
-1
votes
1 answer

How to get total details of current week?

for wk in sorted(out.keys()): rec_date = datetime.datetime(*xlrd.xldate_as_tuple(wk, inputfp.datemode)).isocalendar()[1]#search for dates of current week if rec_date == datetime.date.today().isocalendar()[1]:#conditions to check current week dates …
doubts
  • 157
  • 1
  • 1
  • 9
-1
votes
2 answers

Convert list of dictionaries to EXCEL with Python

I have a list of dictionaries: data= [{'week': 'null', 'releasename': 'r2.0', 'tssubmiton': None, 'outstate': None, 'substate': 'null', 'recomputedon': datetime.datetime(2014, 6, 10, 0, 0), 'submittedon': datetime.datetime(2013, 6, 26, 11, 30, 9),…
salamey
  • 3,633
  • 10
  • 38
  • 71
-1
votes
5 answers

Write dictionary of lists to xls in Python

1.5 month with Python. I am using Python 3.3.2 with WinPython http://code.google.com/p/winpython/ and port xlwt to Python 3 from here https://github.com/hansrwl/xlwt/tree/py3 This is dict with values as lists. It writes to xls file correctly with…
Vic Nicethemer
  • 1,081
  • 3
  • 16
  • 38
-1
votes
2 answers

Overwriting cells of an excel file without affecting the other sheets

i'm using python 2.7 I tried like this from xlrd import * from xlwt import * file1 = r"abc.xls" wbfile1 = open_workbook(file1) file2 = r"xyz.xls" wbfile2 = Workbook() SheetName_file2 =…
user19911303
  • 449
  • 2
  • 9
  • 34
-1
votes
1 answer

Need to save Data from mulitiple instances of a class to different columns in the same excel file using xlwt

I am making this program. The idea is to save the time from a stopwatch to an excel sheet. But it would be better to save them all into one excel sheet. Right now it saves to multiple ones. I just can't think of a way to get all the stopwatches to…
user2360297
  • 3
  • 1
-1
votes
1 answer

excel column width with xlwt upper and lowercase text

Hi. I'm using xlwt package with Python to make an application that writes to excel files. I have a function that returns the desired width of a cell so i can make the cell big enough to fit the text. However, my function breaks down when i'm writing…
stensootla
  • 13,945
  • 9
  • 45
  • 68
-2
votes
1 answer

Writing to a spreadsheet with Python 2.65

I am trying to make some Python 3.6 code work in a Python 2.65 environment. I've made most of the corrections but I cannot import module xlwt. It imports xlrd just fine. I tried openpyxl but that was not available either. Does Python 2.65 come with…
gwydion93
  • 1,681
  • 3
  • 28
  • 59
-2
votes
1 answer

How do I find next available column in Xls file and write there using xlrd/xlwt in Python

I am writing a selenium script where I need to store username password information of all the accounts I am creating. So I am using xlrd and xlwt to write information in an excel file but I am not able to find a way how script automatically detects…
Ihsan Ahmed Zaheer
  • 55
  • 7
1 2 3
…
42
43