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
#5
(Jun-30-2022, 01:21 PM)Mark17 Wrote:
(Jun-29-2022, 01:42 PM)Oshadha Wrote: Without using filename = open(filename, 'w')

Try to use With:

with open(filename, 'w') as file:
    file.write('text')
This way you don't have to filename.close(). This way is more efficient and automatically closes the file if an error is raised.

Does the entire program need to go inside this with block, then, or would I just include this in those places I'm actually writing to the file?

All code that requires the file text wrapper (file variable).
Basically only when writing / reading the file.
Mark17 likes this post
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 404 Mar-03-2024, 12:16 AM
Last Post: MrBean12
  Copy Paste excel files based on the first letters of the file name Viento 2 504 Feb-07-2024, 12:24 PM
Last Post: Viento
  Search Excel File with a list of values huzzug 4 1,313 Nov-03-2023, 05:35 PM
Last Post: huzzug
  Updating sharepoint excel file odd results cubangt 1 931 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,159 Mar-14-2023, 07:59 PM
Last Post: Jennifer_Jone
  Save and Close Excel File avd88 0 3,206 Feb-20-2023, 07:19 PM
Last Post: avd88
  Trying to access excel file on our sharepoint server but getting errors cubangt 0 860 Feb-16-2023, 08:11 PM
Last Post: cubangt
  Import XML file directly into Excel spreadsheet demdej 0 893 Jan-24-2023, 02:48 PM
Last Post: demdej
  how to read txt file, and write into excel with multiply sheet jacklee26 14 10,446 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,172 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