def stringToFloat(base_dir, name, output_dir):
wb = openpyxl.Workbook()
writer_sheet = wb.active
raw = openpyxl.load_workbook(base_dir + name)
raw_sheet = raw['Sheet1']
# print(raw.nrows, raw.ncols)
for i in range(0, raw_sheet.max_row):
for j in range(0, raw_sheet.max_column):
if i == 0:
writer_sheet.cell(i + 1, j + 1, raw_sheet.cell(row =i + 1, column = j + 1).value)
continue
else:
print(i+1,j+1)
writer_sheet.cell(i+1, j+1, float(raw_sheet.cell(i+1, j+1).value))
wb.save(name)