Opening multiple excel files using Python
Question: I have multiple excel files in a directory and would like to open those files
at a time to perform write operations (To, for example, write "Hi" in the
first row of all the excel files). Is there any way to do so in Python?


Answer: You can use:

    
    
    import csv    
    with open('A.csv','w') as a, open ('B.csv', 'w') as b:
        a_reader = csv.reader(a)
        b_reader = csv.reader(b) 
        ...
    

Now you can iterate through the both files.

The python module
[fileinput](https://docs.python.org/2/library/fileinput.html) can be of help
also, it allows to iterate over lines of multiple files passed as arguments.

