Python Forum
Excel file in use from Python
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel file in use from Python
#1
Hi all! My program writes to three .csv files. At the end of the program, I do a filename.close() for all three. Usually, this does the trick and after the program executes I'm able to open these files in Excel and look at them.

Intermittently, I get the "file is locked for editing by 'another user.' Open 'Read-Only' or click 'Notify' to open read-only and receive notification when the document is no longer in use."

Now... the first few times this happened would be when an exception was raised and the program stopped. In these cases, I'm able to manually enter filename.close() in JN and the file opens fine.

With this intermittent issue, though, it's not following any exception and manually entering filename.close() in JN does not unlock the file. Twice now, it seems, the file is unlocked not when I close the two JN browser tabs but rather when I close Anaconda Powershell Prompt, which is always running in the background when I'm using JN.

Any ideas on what I can do to avoid this?
Reply


Messages In This Thread
Excel file in use from Python - by Mark17 - Jun-27-2022, 12:49 PM
RE: Excel file in use from Python - by Larz60+ - Jun-27-2022, 01:22 PM
RE: Excel file in use from Python - by Oshadha - Jun-29-2022, 01:42 PM
RE: Excel file in use from Python - by Mark17 - Jun-30-2022, 01:21 PM
RE: Excel file in use from Python - by Oshadha - Jul-03-2022, 05:45 AM
RE: Excel file in use from Python - by Mark17 - Jul-03-2022, 01:47 PM
RE: Excel file in use from Python - by deanhystad - Jul-04-2022, 03:58 AM
RE: Excel file in use from Python - by Mark17 - Jul-04-2022, 02:06 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Python openyxl not updating Excel file MrBean12 1 495 Mar-03-2024, 12:16 AM
Last Post: MrBean12
  Copy Paste excel files based on the first letters of the file name Viento 2 589 Feb-07-2024, 12:24 PM
Last Post: Viento
  Search Excel File with a list of values huzzug 4 1,411 Nov-03-2023, 05:35 PM
Last Post: huzzug
  Updating sharepoint excel file odd results cubangt 1 1,008 Nov-03-2023, 05:13 PM
Last Post: noisefloor
  Reading data from excel file –> process it >>then write to another excel output file Jennifer_Jone 0 1,237 Mar-14-2023, 07:59 PM
Last Post: Jennifer_Jone
  Save and Close Excel File avd88 0 3,420 Feb-20-2023, 07:19 PM
Last Post: avd88
  Trying to access excel file on our sharepoint server but getting errors cubangt 0 909 Feb-16-2023, 08:11 PM
Last Post: cubangt
  Import XML file directly into Excel spreadsheet demdej 0 934 Jan-24-2023, 02:48 PM
Last Post: demdej
  how to read txt file, and write into excel with multiply sheet jacklee26 14 10,903 Jan-21-2023, 06:57 AM
Last Post: jacklee26
Thumbs Up Need to compare the Excel file name with a directory text file. veeran1991 1 1,235 Dec-15-2022, 04:32 PM
Last Post: Larz60+

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020