RobbenEmi的专栏

import pandas as pdimport xlrdwb = xlrd.open_workbook(file)df = pd.read_excel(wb)df.to_hdf(h5_file,'key',format='table')

使用pandas的read_excel读取，耗时巨大，而且不适合作为调试工具，这里使用openpyxl，用它的只读模式，可以 即时 读取任何单元格的内容，代码如下：import openpyxlfile = 'big_excel.xlsx'# 必须是只读模式，否则也是很慢wb = openpyxl.load_workbook(file,read_only=True) sht = wb['Sheet1']# 从第2行5列读起，data就是一行的数据。注意，excel的第一行第一列是(1,1).

用到库 win32ui, 看清楚,不是win32guiCreateFileDialog(bFileOpen, defExt , fileName , flags , filter , parent )这个可以参考详细说明,点击链接即可 open_flag = win32con.OFN_OVERWRITEPROMPT | win32con.OFN_PATHMUSTEXIST | win32con.OFN_HIDEREADONLY # 打开方式 default_format = 'xlsx' # 自

一个PDF文件，可能有文字也可能有表格，把需要的表格内容写到Excel里面可以这样做。可以看到，表格的开头是有文字的，可以以它为截取的开始。源文件为test.pdf目标文件为pdf.xlsximport pdfplumber # 关键在这个库import pandas as pddef func(src, dest='pdf.xlsx'): pdf = pdfplumber.open(src) size = len(pdf.pages) #pdf有多少页 .

import pandas as pd直接生成Exceldf.to_excel(filename)生成的同时修改sheet名称df.to_excel(filename,sheet_name='sample')多个dataframe写入一个文件with pd.ExcelWriter('stocks.xlsx') as writer: df1.to_excel(writer,...

假设有以上的数据，蓝底的是PERCENTRANK.EXC的结果，我们要用python计算该值，则可以按照如下方式解决import pandasdf = pd.DataFrame([[10,3],[11,4],[12,5],[13,6],[14,'']],index=[1,2,3,4,5],columns=['size','num'])size_df = df['size']num_df ...

import xlwings as xwapp = xw.App(visible=False, add_book=False)app.display_alerts = Falseapp.screen_updating = Falsewb = app.books.open('test.xlsx')sht_sample = wb.sheets['Sample'] # 要复制的sheet...

import win32com.client from PIL import ImageGrab import oso = win32com.client.Dispatch("Excel.Application")o.Visible = 0o.DisplayAlerts = 0wb = o.Workbooks.Open(srcfile)for sheet in wb...

比如excel中显示的是Oct-10，如果读取到这个数据，直接用strptime转换是没有用的，因为这个日期是从1899年开始delta = datetime.timedelta(days=timestamp) #timestamp就是从excel读取到的那个值m_date = datetime.datetime.strptime('1899-12-30', '%Y-%m-%d') + del...

Dim wb As Workbookpaths = ThisWorkbook.Path & "\"Set wb = Workbooks.Open(paths & "test.xlsx")wb.Close

import xlwings as xwfile = 'a.xlsx'app = xw.App(visible=False, add_book=False)app.display_alerts = Falseapp.screen_updating = Falsewbk = app.books.open(file)sheet = wbk.sheets['Sheet 1']# 以下是根...

import win32com.clientimport osxlApp = win32com.client.Dispatch('Excel.Application')xlApp.Visible = Falsexls = xlApp.Workbooks.Open(os.getcwd() + "\\test.xls")sheet = xls.Worksheets(1)info =...

import xlwings as xwtry: app = xw.App(visible=False, add_book=False) xls = app.books.open(excel_file)except: returnsheet = xls.sheets[0]info = sheet.used_rangenrows = info.last_ce...

import win32com.clientimport timepath = r'absolute dir'xl = win32com.client.DispatchEx("Excel.Application")workbook = xl.Workbooks.Open(path)xl.Visible = Falseworkbook.RefreshAll()workbook.Save()...

这是我写的一个获取十档行情的python代码import xlsxwriter     startdate = '2018-06-12 09:00:00' enddate = '2018-06-12 15:03:00' filepath = 'tickData.xlsx' workbook=xlsxwriter.Workbook(filepath) works...

出现这个错误，一般是源文件有问题，可以联系作者，不过这不明智，以下提供了三种方法来读该文件。1. 修改xlrd源码如果你还想继续使用xlrd，那么你需要修改源码，先找到compdoc.py文件，该文件位于：Python\lib\site-packages\xlrd\compdoc.py找到426行代码，将它注释掉就行raise CompDocError("%s corruption:...

导入库import xlwings as xw打开Excel文件获取workbook''' 这种打开方式，可以设置Excel不可见 '''app=xw.App(visible=True,add_book=False)# app.display_alerts=False# app.screen_updating=Falsefile = r'd:\workspace\test.xl...

import xlwings as xwapp = xw.App(visible=False, add_book=False)wbk = app.books.open('test.xlsx')sht = wbk.sheets['chartsheet']title = 'hello world'sht.charts['图表 1'].api[1].ChartTitle.Text = ti...

VBA设置数据多少有些麻烦，不如把代码全部写在python里面。VBA设置的方法可以看我的博客，VBA设置图表坐标轴最大最小范围该设置方法用python解决如下：import xlwings as xwfile = 'test/tt.xlsx'app = xw.App(visible=False)wbk = app.books.open(file)sht = wbk.sheets[...

import xlwings as xwapp = xw.App(visible=False, add_book=False)wb = app.books.open('test.xlsx')sht = wb.sheets[0]清理内容，清理数据及格式sht.range('A6:V10').clear()设置背景色sht.range('A6:V10').color = (255,0...

Sub Axis() Dim wb As Workbook paths = ThisWorkbook.Path & "\" Set wb = Workbooks.Open(paths & "a.xlsx")wb.CloseSet sht = Worksheets("sheet1&amp

两种方式import xlwings as xwapp = xw.App(visible=False, add_book=False)wb = app.books.open('test.xlsx')wb.save()wb.close()app.quit()wb = xw.Book('test.xlsx')wb.visible = Falsewb.save()wb.clo...

打开excel，按alt+f11，然后输入如下内容Function MaxDrawDown(returns As Variant) As Variant Dim TS As Variant Dim n As Integer Dim Min As Double TS = returns n = UBound(TS) Min = 0 For i = 1 To