1 import pandas as pd
2
3 # reading file written using to_excel() of DataFrame
4 exl = pd.ExcelFile('out.xlsx')
5 res = exl.parse('Data', usecols = [1, 2])
6 print('The excel content :')
7 print(res)
8
9 # close ExcelFile
10 cls = exl.close()
1 The excel content :
2 Unnamed: 0 C1 C2
3 0 R1 11 12
4 1 R2 21 22
5 2 R3 31 33
6 3 R4 41 44
1 import pandas as pd
2
3 # reading file written using to_excel() of DataFrame
4 exl = pd.ExcelFile('out.xlsx')
5 res = exl.parse('Data', usecols = [3, 4])
6 print('The excel content :')
7 print(res)
8
9 # close ExcelFile
10 cls = exl.close()
1 The excel content :
2 Unnamed: 0 C3 C4
3 0 R1 A W
4 1 R2 B X
5 2 R3 C Y
6 3 R4 D Z