Python xlrd 读取Excel数字 跟Excel显示不一样 小数位太长 求大神的解决方法(已解决)
十分想念顺店杂可。。。
Excel显示的数据
Python代码读取
# -*- coding: utf-8 -*-
# @Time : 2019/5/22 13:53
# @Author : 甄超锋
# @Email : 4535@sohu.com
# @File : aaa.py
# @Software: PyCharm
import xlrd
# xled读取
workbook = xlrd.open_workbook("aaa.xlsx")
sheet2 = workbook.sheet_by_index(4)
rows1 = sheet2.row_values(22)
print(rows1[2])
import openpyxl
# openpyxl读取
wb = openpyxl.load_workbook('aaa.xlsx',)
a_sheet = wb.get_sheet_by_name('表五')
b4_too = a_sheet.cell(row=23, column=3)
print(b4_too.value)
# print(int(b4_too.value))
# print(float(b4_too.value))
# pandas读取
import pandas