Error no 13: Permission denied in python

[shantanu97]

written a python code for converting excel to csv code. run code in c and g drive. error is coming.

#Purpose: '''This python script is to extract each sheet in an Excel workbook as a new csv file'''
#Usage:  python ExceltoCSV.py [Excel_File_Location] [CSV_File_Location] 
#		  [C:\Users\....\Input_File.xlsx] [C:\Users\....\Output_Folder_Name/] Remember to put Forward Slash After Output Folder Name to save CSV file

import csv
import xlrd
import sys

def ExceltoCSV(excel_file, csv_file_base_path):
    workbook = xlrd.open_workbook(excel_file)
    for sheet_name in workbook.sheet_names():
        print('processing - ' + sheet_name)
        worksheet = workbook.sheet_by_name(sheet_name)
        csv_file_full_path = csv_file_base_path + sheet_name.lower().replace(" - ", "_").replace(" ","_") + '.csv'
        csvfile = open(csv_file_full_path, 'w',newline='')
        writetocsv = csv.writer(csvfile, quoting = csv.QUOTE_ALL)
        for rownum in range(worksheet.nrows):
            if rownum == 0:
                writetocsv.writerow(
                    list(str(x) for x in worksheet.row_values(rownum))+["SourceFile"]      
            )   
            else:    
                writetocsv.writerow(
                    list(str(x) for x in worksheet.row_values(rownum))+[excel_file.split("\\")[-1]]      
                )          
        csvfile.close()
        
if __name__ == '__main__':
    ExceltoCSV(excel_file = sys.argv[1], csv_file_base_path = sys.argv[2])

it will show error.

Error:
 File "ExceltoCSV.py", line 29, in <module>
    ExceltoCSV(excel_file = sys.argv[1], csv_file_base_path = sys.argv[2])
  File "ExceltoCSV.py", line 10, in ExceltoCSV
    workbook = xlrd.open_workbook(excel_file)
  File "C:\Users\ShantanuGupta\AppData\Local\Programs\Python\Python37\lib\site-packages\xlrd\__init__.py", line 111, in open_workbook
    with open(filename, "rb") as f:
PermissionError: [Errno 13] Permission denied: 'G:\\TestFilesIn'

[snippsat]

[Errno 13] Permission denied: 'G:\\TestFilesIn'

Look like you try to open a folder and not file.
So if file was in that folder argv from command line would be G:\TestFilesIn\some_file.csv.

Just to show an other way as Pandas already has this feature build with DataFrame.to_csv
Notebook Example