Dhristov
Dhristov

Reputation: 1

How do I update an existing excel file with python

I need to update values in an existing excel file.

I need to open an existing file. I need to update for example the cell value in row 4 column A. I need to close and save the existing file.

I have tried a simple code but it returns an error.

CHECK MY CODE

EDIT: the code from the image works and executes but when i open the Excel file excel returns an error.

Upvotes: 0

Views: 197

Answers (1)

Bill the Lizard
Bill the Lizard

Reputation: 406095

workable_copy = copy(read_excel)

TypeError: 'module' object is not callable

This message means that you're calling a module as though it were a function. Since your script recognizes copy as a module, I assume you've imported it with import xlutils.copy. However, if you want to use the function without qualifying it, you have to import it like this:

from xlutils.copy import copy

Upvotes: 1

Related Questions