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 someone help me ?print
Asked
Active
Viewed 37 times
0
-
Why not simply copy the data into a Pandas dataframe, manipulate the dataframe, then save it into Excel? – Joel Aug 03 '18 at 23:14
-
Do you (or the user you'er logged in as) have write permissions on that file? – Richie Thomas Aug 03 '18 at 23:30
-
1If you are on Windows the answer is probably no. Excel, or the OS, keeps the file locked for writing when it is open. – jmcnamara Aug 04 '18 at 08:45