approx 500 .xlsx files in a directory with 6 sheets in each one. All of the data I need in each file is in the 6th sheet. Is there a way to convert all files to csv and only extract sheet 6. Thanks for any help
approx 500 .xlsx files in a directory with 6 sheets in each one. All of the data I need in each file is in the 6th sheet. Is there a way to convert all files to csv and only extract sheet 6. Thanks for any help