python中的max_row,Openpyxl max_row和max_column错误地报告了一个较大的数字

最新推荐文章于 2023-01-15 10:17:05 发布

叶小开喝的柳橙冰

最新推荐文章于 2023-01-15 10:17:05 发布

阅读量1.6k

点赞数

文章标签： python中的max_row

在使用openpyxl库解析Excel文件时，遇到max_row函数返回值比实际行数大的问题。尽管尝试了删除空行和根据其他讨论修改代码，但错误依然存在。问题在于max_row并未按预期忽略空行。为解决此问题，需要自定义代码从max_row开始反向遍历，直到找到第一个所有单元格值都为空的行，以此确定实际的最大行数。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

My query is to do with a function that is part of a parsing script Im developing. I am trying to write a python function to find the column number corresponding to a matched value in excel. The excel has been created on the fly with openpyxl, and it has the first row (from 3rd column) headers that each span 4 columns merged into one. In my subsequent function, I am parsing some content to be added to the columns corresponding to the matching headers. (Additional info: The content I'm parsing is blast+ output. I'm trying to create a summary spreadsheet with the hit names in each column with subcolumns for hits, gaps, span and identity. The first two columns are query contigs and its length. )

I had initially written a similar function for xlrd and it worked. But when I try to rewrite it for openpyxl, I find that the max_row and max_col function wrongly returns a larger number of rows an