-
Notifications
You must be signed in to change notification settings - Fork 0
/
convertExcelToCSV.py
35 lines (25 loc) · 1.21 KB
/
convertExcelToCSV.py
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
28
29
30
31
32
33
34
35
import pandas as pd
import os
import warnings
warnings.simplefilter("ignore")
parentFolder = 'D:\\Code\\automation\\20220511-20220517'
def main():
for folderName, subfolders, filenames in os.walk(parentFolder):
for filename in filenames:
if filename.endswith('.xlsx'):
print("FILE INSIDE " + folderName + ": " + filename)
filePath = os.path.join(folderName, filename)
# read excel without headers
# df = pd.read_excel(filePath, index_col=None, header=None, engine="openpyxl")
df = pd.read_excel(filePath, engine="openpyxl")
# uncomment this code to custom Header
# newHead = ['MeasureTime', 'KeyValueList', '', '', 'Operator', 'RawData', '', '', '', 'Remark']
# df.columns = newHead
# save to csv
df.to_csv(filePath.replace('.xlsx', '.csv'), index=False)
# delete the original xlsx file
os.remove(filePath)
print("FILE DELETED: " + filePath)
print("FILE INSIDE " + folderName + ": " + filename + " DONE")
if __name__ == '__main__':
main()