Stack Overflow
Stack Overflow

Questions tagged [xlutils]

xlutils allows you to copy and modify Excel files writing Excel 2003 files.

xlutils is based on and and allows for modifying (not in place, complete files are written) Excel files. It is limited by the underlying libraries and therefore can read Excel 2007, but cannot write that format (.xlsx, .xlsm).

Documentation: http://pythonhosted.org/xlutils/

88 questions
0
votes
1 answer

How do I write to one sheet in an already existing excel sheet in Python?

I got an excel file that has four sheets. One sheet, sheet 4. contains data in simple CSV and the others read the data of this sheet and make different calculations and graphs. In my python application I would like to open the excel file, open sheet…
Perry
  • 1,709
  • 1
  • 17
  • 25
0
votes
1 answer

Datastore operation timed out during excel file generation

I'm generating an excel file using xlwt and store it on datastore as blob property. But during the generation got this error "Timeout: The datastore operation timed out, or the data was temporarily unavailable.". I have noticed that using xlutils we…
Nijin Narayanan
  • 2,269
  • 2
  • 27
  • 46
0
votes
0 answers

Attendance tracker using Excel and Python

I'm Vice Wing Commander at the Air Force Detachment I go to here at college. One responsibility of my job is taking attendance. Within the wing there are four squadrons. Each squadron turns in attendance every week and I have to transfer the…
Dave
  • 503
  • 1
  • 8
  • 21
0
votes
4 answers

How to delete an existing worksheet in excel file using xlutils, xlwt, xlrd with python

I tried to search many places but dit not see any example snippet of code about how to delete an existing worksheet in excel file by using xlutils or xlwt with python. Who can help me, please?
JinFy
  • 9
  • 1
  • 1
  • 3
0
votes
2 answers

Python xlutils copies over incorrect year

I've written a script that changes values for a certain date in an excel sheet. When I create a new excel file using copy, it copies everything over correctly except for the year portion of the date. For example, it will go from 4/5/2012 to…
westbyb
  • 171
  • 5
  • 15
-1
votes
2 answers

Add int value in a cell of excel file from python code

My excel file contains multiple sheets, I am trying to add value(int:5) in cell("C5") in sheet("sheet_1") of excel file("testexcel.xlsx"). I tried many ways, but none of the functions are able to edit the excel file. Excel File either gets corrupted…
Ash
  • 63
  • 8
-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
1 answer

Python Modify data of existing .xlsx file

I have some code here in python which created a .xlsx file using openpyxl. However, when i tried to modify the file, the new data will register into the file but previous data is gone. I heard of using deepcopy or (.copy.copy) to copy the data of…
Hashashihn Altheim
  • 109
  • 3
  • 14
-1
votes
1 answer

How to read sheets in the existing XLSX by using openpyxl?

I am reading existing xlsx sheet and writing data into that using openpyxl,but for reading sheets I used 'load_workbook'is that right way to get sheet from existing xlsx file,it showing error I go t error like this: Traceback (most recent call…
doubts
  • 157
  • 1
  • 1
  • 9
-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
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
1 answer

Removing column formatting in Excel worksheet using Python xlrd or xlutils

What I am attempting to duplicate using Python 2 is the following MS Excel action - 1) Select All 2) Copy 3) Special Paste - without formatting I have been pouring over xlrd and xlutils and although they have filtering capabilities I do not see what…
scopedial
  • 203
  • 1
  • 3
  • 7
-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
1 2 3 4 5
6