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
0 answers

Is it possible to change data in an open worksheet through modules, openpyxl, xlsxwriter, xlwt, or xlutils?

I need to modify the data of the excel cells without it being closed, is this a limitation of the modules or is it possible to do this process? Python returns this error: '' PermissionError: [Errno 13] Permission denied: 'sample.xlsx' '' . Can…
Eliezer Borges
  • 1
0
votes
0 answers

copying .xlsx excel files with python while retaining formating/graphs

I'm using xlrd, xlwt and xlutils to parse a large data file and import it to a pre existing excel sheet which has tables, graphs, equations, ect… The problem I'm having is, I can't seem to find a way to do this using xlsx excel files. When I create…
Trubsworth
  • 45
  • 6
0
votes
1 answer

No Module Named xlutils.copy and pip install fail

I am getting an error message that says "no module named xlutils.copy". When I got to do the pip install of xlutils.copy I get an error message "could not find a version that satifies the requirement". I downloaded xlutils 2.0.0 which contains…
boulderj
  • 11
  • 1
  • 5
0
votes
1 answer

from xlutils.copy import copy ImportError: No module named copy

I want to modify the existing worksheet. When I input from xlutils.copy import copy then I got ImportError: No module named copy I have try reinstall xlutils from different ways, it still doesn't work. Lib\site-packages\xlutils\copy.py is also…
Freya Ma
  • 3
  • 1
  • 3
0
votes
2 answers

How do I use text from a file as a variable name?

How do I use text from a file as a variable name? I am pulling values out of an excel file. I am using xlrd and xlutils with python 3. class employee(object): def __init__(self, name): self.name = name emp_list.append(name) def…
Devin Griffin
  • 1
  • 1
0
votes
1 answer

Python - Deleting a sheet

Is there any function that has been made to delete only a single sheet using xlwt, xlrd, xlutils, xlutils.filter, or pyexcel? Those are the only ones I have access to and I want to know how to delete a sheet. Perhaps you could create a list with all…
Nick M.
  • 259
  • 1
  • 8
  • 22
0
votes
1 answer

pip install xlutils python3

I'm trying to install xlutils package to access xls sheets in Python but unfortunately I'm unable to install it. Python version 3.5.1 using spyder editor, have got this error. runfile('E:/python_practice/task2/gen1.py',…
venky
  • 3
  • 2
0
votes
0 answers

How to write value inside existing Excel sheet?

Here is the piece I am trying to write the value inside existing excel sheet in particular cell but value is not printing inside that sheet,how to write that value,here I used xlutils.copy from datetime import datetime, timedelta, date from xlrd…
doubts
  • 157
  • 1
  • 1
  • 9
0
votes
0 answers

Python Doesn't Release File/Cannot Save File (xlutils)

So I have a XLS file that is being accessed via the xlutils library. When my program is finished doing its process, its supposed to delete the original file and rename the temporary file to the original file. The data in the excel file is being…
ohbrobig
  • 939
  • 2
  • 13
  • 34
0
votes
0 answers

excel borders are not proper in copied file after using xlutils.copy.copy

I have a excel sheet and I am trying write data into that. My sheet works as a template and after writing I will save the file with another name. My python code for populating is like this # -*- coding: utf-8 -*- import json import xlrd from…
Lee
  • 33
  • 2
  • 8
0
votes
1 answer

Python, copy xls file with marking

I need to copy/edit existing sheet of xls file to new file with marking. What i've tried: import xlrd from xlutils.copy import copy workbook = xlrd.open_workbook('template1.xls') new_wb = copy(workbook) new_wb.save("test.xls") But marking is not…
Valeriy Gaydar
  • 500
  • 1
  • 6
  • 26
0
votes
1 answer

Editing an Excel file and saving it to a new file with Python

I want to go into my current folder and edit whatever files is in the folder with the string "test" onto cell 0,0 and then save it as book1.xlsx but my code is giving me an error. Can anyone help? import xlrd import os import glob from xlutils.copy…
user4077617
  • 1
0
votes
1 answer

Is there any way to append a new row to an Excel spreadsheet using Python?

I have searched around, tried some win32com and some xlrd/xlwt/xlutils but all I can do is insert data into the existing Excel rows - I want to be able to insert one new row (specifically the first one, in my case). Does anyone know how to do this…
amchugh89
  • 1,276
  • 1
  • 14
  • 33
0
votes
1 answer

xlwt and xlutils not working while xlrd works all right

I am a Windows user and I have a Python 2.7 version. I would be really grateful if someone helped me on that: I have downloaded, unpacked with 7Zip and installed xlrd, xlwt and xlutils (the installation seemed to be completed all right) but only…
fanny
  • 1,373
  • 12
  • 25
0
votes
1 answer

Python - Excel: Finding the first empty row in a column

working from my last question I've managed to get a good chunk of the way to get my system finished. Of course I've run across a problem. I basically have a program that plays a game. Every correct answer adds 10 to the global variable 'points'.…
user3191879
  • 1
  • 1
  • 2
1 2 3 4
5
6