1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
| import os
import pandas as pd
from openpyxl import Workbook
from openpyxl import load_workbook
print ('Starting program')
print ('cwd = ' + os.getcwd())
os.chdir('/home/pi/Documents')
#************USING PANDAS TO READ THE DATAS******
dest_filename = 'temp.xlsx'
xl = pd.ExcelFile (dest_filename)
df = xl.parse ('Predim')
print ('Reading values from Pandas : ')
print (df)
#************USING OPENPYXL TO READ THE DATAS******
print ('Reading value with openpyxl (data_only = True)')
wb = load_workbook(filename = dest_filename, data_only= True)
ws = wb.active
print (ws['B1'].value)
print (ws['B2'].value)
print (ws['B3'].value)
print (ws['B4'].value) |
