File Handling In Python-

Ex-

class Test:
    file = None
    def main():
        try:
            Test.file = open("./test.txt") #builin module(We are assuming that you have test.txt in same folder)
            print("****Read the content at an instance****")
            content = Test.file.read()
            print(content)
            print("****Read the content char by char****")
            for ch in content:
                print(ch, end='')
        except Exception as ex:
            print("Exception occurred-", ex)
        finally:
            if Test.file is not None:
                Test.file.close()
                print("\n*****File Closed******")
Test.main()

Output-
	****Read the content at an instance****
	Hi Welcome
	Bye
	****Read the content char by char****
	Hi Welcome
	Bye
	*****File Closed******

Open Function Is Having 3 Modes-

1) “R” –

  • 1) Open the file in read mode.
  • 2) If file is present – It will open the file and will return the pointer.
  • 3) If file is not present – It will raise the exception.

2) “W” –

  • 1) Open the file into the write mode.
  • 2) If file is present – It open the file and remove all the existing content.
  • 3) If file is not present – It will create a new file.

3) “A” –

  • 1) Open the file into the append mode.
  • 2) If file is present – It open the file and place the cursor at the end of the file to add new content.
  • 3) If file is not present – It will create the new file.

Ex-

class Test:
    src = None
    dest = None

    def main():
        try:
            Test.src = open("./test1.txt", "r")
            Test.dest = open("./test1.py", "w")

            for ch in Test.src:
                Test.dest.write(ch)
            print("Data Copied")
        finally:
            if Test.src is not None:
                Test.src.close()
            if Test.dest != None:
                Test.dest.close()

Test.main()

Output-
	Data Copied
    • Qsn-

      How to read the content of CSV(comma separated values) file?

Ans-

import csv #predefined module
file = open("./Test.csv", "r")
print("CSV File Opened")

table = csv.reader(file)
for record in table:
    print(record)
file.close()
print("File Closed")

    • Qsn-

      How to read the content of XLS file?

Ans-

import xlrd
wb = xlrd.open_workbook("Demo1.xlsx")
sheet = wb.sheet_by_index(1)
for i in range(sheet.nrows): #sheet.nrows - Total no of rows
    for j in range(sheet.ncols) :#sheet.ncols - Total no of colomns
        print(sheet.cell_value(i,j), end=' ')
    print()

Output-
	Name Age 
	A2 171.0 
	B2 898.0 
	C2 787.0
Menu