Python Forum
Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Multiple excel files
#7
an example of a for loop to open 26 files
for number in range(1, 27):
    print(f'open file{number}')
    # code to deal with the excel file
Output:
open file1 open file2 ... ... ... open file25 open file26
Reply


Messages In This Thread
Multiple excel files - by Kristenl2784 - Jun-12-2020, 03:45 AM
RE: Multiple excel files - by DPaul - Jun-12-2020, 06:50 AM
RE: Multiple excel files - by hussainmujtaba - Jun-12-2020, 07:31 AM
RE: Multiple excel files - by Kristenl2784 - Jun-12-2020, 12:30 PM
RE: Multiple excel files - by DPaul - Jun-12-2020, 02:17 PM
RE: Multiple excel files - by Kristenl2784 - Jun-12-2020, 06:11 PM
RE: Multiple excel files - by Yoriz - Jun-12-2020, 06:24 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Copy Paste excel files based on the first letters of the file name Viento 2 455 Feb-07-2024, 12:24 PM
Last Post: Viento
  python convert multiple files to multiple lists MCL169 6 1,567 Nov-25-2023, 05:31 AM
Last Post: Iqratech
  splitting file into multiple files by searching for string AlphaInc 2 908 Jul-01-2023, 10:35 PM
Last Post: Pedroski55
  Merging multiple csv files with same X,Y,Z in each Auz_Pete 3 1,180 Feb-21-2023, 04:21 AM
Last Post: Auz_Pete
  unittest generates multiple files for each of my test case, how do I change to 1 file zsousa 0 974 Feb-15-2023, 05:34 PM
Last Post: zsousa
  Find duplicate files in multiple directories Pavel_47 9 3,144 Dec-27-2022, 04:47 PM
Last Post: deanhystad
  How to loop through all excel files and sheets in folder jadelola 1 4,523 Dec-01-2022, 06:12 PM
Last Post: deanhystad
  Creating csv files from Excel file azizrasul 40 5,715 Nov-03-2022, 08:33 PM
Last Post: azizrasul
  Extract parts of multiple log-files and put it in a dataframe hasiro 4 2,098 Apr-27-2022, 12:44 PM
Last Post: hasiro
  Search multiple CSV files for a string or strings cubangt 7 8,062 Feb-23-2022, 12:53 AM
Last Post: Pedroski55

Forum Jump:

User Panel Messages

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