我有一个xlsb格式的巨大excel数据,由于它的大小,我想通过xlsb库一次只读取一些行。你知道吗
我已经在这里写了我的代码,请检查。你知道吗
import pandas as pd
import xlwings as xw
app = xw.App()
book = xw.Book(some_excel.xlsb)
sheet = book.sheets('Sheet1')
#from sheet1, I want to store 1150 rows into dataframe
#but I don't know how to read that much rows and put it in a dataframe simultaneously
df= sheet.range('A1').options(pd.DataFrame, expand='table').value # here I stored all rows the into df but after putting into dataframe will not give the required output.
book.close()
app.kill()
目前没有回答
相关问题 更多 >
编程相关推荐