blocks|key|2752682|text|试试这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2752683|import+xlwings+as+xw

cellsDown+=+xw.Range('A1').vertical.value

cellsRight+=+xw.Range('A1').horizontal.value

print+len(cellsDown)

print+len(cellsRight)|code-block|syntax|javascript|2752684|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Try this:

<pre><code>import xlwings as xw

cellsDown = xw.Range('A1').vertical.value

cellsRight = xw.Range('A1').horizontal.value

print len(cellsDown)

print len(cellsRight)
</code></pre>

blocks|key|1567183|text|您可以尝试使用Direction，方法是从最底层开始，然后向上移动：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1567184|import+xlwings
from+xlwings.constants+import+Direction
wb+=+xlwings.Workbook(r'data.xlsx')
print(wb.active_sheet.xl_sheet.Cells(65536,+1).End(Direction.xlUp).Row)|code-block|syntax|javascript|1567185|entityMap^0|7|9|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

You could try using <code>Direction</code> by starting at the very bottom and then moving up:

<pre><code>import xlwings
from xlwings.constants import Direction
wb = xlwings.Workbook(r'data.xlsx')
print(wb.active_sheet.xl_sheet.Cells(65536, 1).End(Direction.xlUp).Row)
</code></pre>

blocks|key|3220257|text|--这与crazymachu的答案非常相似，它只是封装在一个函数中。从xlwing的0.9.0版本开始，您可以这样做：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|3220258|import+xlwings+as+xw

def+lastRow(idx,+workbook,+col=1):
++++"""+Find+the+last+row+in+the+worksheet+that+contains+data.

++++idx:+Specifies+the+worksheet+to+select.+Starts+counting+from+zero.

++++workbook:+Specifies+the+workbook

++++col:+The+column+in+which+to+look+for+the+last+cell+containing+data.
++++"""

++++ws+=+workbook.sheets[idx]

++++lwr_r_cell+=+ws.cells.last_cell++++++#+lower+right+cell
++++lwr_row+=+lwr_r_cell.row+++++++++++++#+row+of+the+lower+right+cell
++++lwr_cell+=+ws.range((lwr_row,+col))++#+change+to+your+specified+column

++++if+lwr_cell.value+is+None:
++++++++lwr_cell+=+lwr_cell.end('up')++++#+go+up+untill+you+hit+a+non-empty+cell

++++return+lwr_cell.row|code-block|syntax|javascript|3220259|从直觉上看，该函数从找到工作簿中最极端的右下角单元开始.然后，它移动到所选列，然后向上移动，直到它到达第一个非空单元格。|3220260|entityMap^0|0|H|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|S|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|N|$]]

This is very much the same as crazymachu's answer, just wrapped up in a function. Since version 0.9.0 of xlwings you can do this:

<pre><code>import xlwings as xw

def lastRow(idx, workbook, col=1):
 """ Find the last row in the worksheet that contains data.

 idx: Specifies the worksheet to select. Starts counting from zero.

 workbook: Specifies the workbook

 col: The column in which to look for the last cell containing data.
 """

 ws = workbook.sheets[idx]

 lwr_r_cell = ws.cells.last_cell # lower right cell
 lwr_row = lwr_r_cell.row # row of the lower right cell
 lwr_cell = ws.range((lwr_row, col)) # change to your specified column

 if lwr_cell.value is None:
 lwr_cell = lwr_cell.end('up') # go up untill you hit a non-empty cell

 return lwr_cell.row
</code></pre>

Intuitively, the function starts off by finding the most extreme lower-right cell in the workbook. It then moves across to your selected column and then up until it hits the first non-empty cell.

blocks|key|1567215|text|您可以使用通过api属性公开的VBA函数(使用它查找任何带有星星的内容，并从第一个单元格开始搜索)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1567216|示例：|1567217|row_cell+=+s.api.Cells.Find(What="*",
+++++++++++++++++++After=s.api.Cells(1,+1),
+++++++++++++++++++LookAt=xlwings.constants.LookAt.xlPart,
+++++++++++++++++++LookIn=xlwings.constants.FindLookIn.xlFormulas,
+++++++++++++++++++SearchOrder=xlwings.constants.SearchOrder.xlByRows,
++++++++++++++++SearchDirection=xlwings.constants.SearchDirection.xlPrevious,
+++++++++++++++++++++++MatchCase=False)

column_cell+=+s.api.Cells.Find(What="*",
++++++++++++++++++++++After=s.api.Cells(1,+1),
++++++++++++++++++++++LookAt=xlwings.constants.LookAt.xlPart,
++++++++++++++++++++++LookIn=xlwings.constants.FindLookIn.xlFormulas,
++++++++++++++++++++++SearchOrder=xlwings.constants.SearchOrder.xlByColumns,
++++++++++++++++++++++SearchDirection=xlwings.constants.SearchDirection.xlPrevious,
++++++++++++++++++++++MatchCase=False)

print((row_cell.Row,+column_cell.Column))|code-block|syntax|javascript|1567218|这里概述的其他方法似乎不需要数据之间的空行/列。|1567219|来源：https://gist.github.com/Elijas/2430813d3ad71aebcc0c83dd1f130e33|offset|length|1567220|entityMap|0|LINK|mutability|MUTABLE|url|https://gist.github.com/Elijas/2430813d3ad71aebcc0c83dd1f130e33^0|0|0|0|0|3|1R|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Y|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|Z|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|10|8|@]|9|@$M|11|N|12|1|13]]|A|$]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]]]

One could use the VBA Find function that is exposed through api property (use it to find anything with a star, and begin your search from the first cell).

Example:

<pre><code>row_cell = s.api.Cells.Find(What="*",
 After=s.api.Cells(1, 1),
 LookAt=xlwings.constants.LookAt.xlPart,
 LookIn=xlwings.constants.FindLookIn.xlFormulas,
 SearchOrder=xlwings.constants.SearchOrder.xlByRows,
 SearchDirection=xlwings.constants.SearchDirection.xlPrevious,
 MatchCase=False)

column_cell = s.api.Cells.Find(What="*",
 After=s.api.Cells(1, 1),
 LookAt=xlwings.constants.LookAt.xlPart,
 LookIn=xlwings.constants.FindLookIn.xlFormulas,
 SearchOrder=xlwings.constants.SearchOrder.xlByColumns,
 SearchDirection=xlwings.constants.SearchDirection.xlPrevious,
 MatchCase=False)

print((row_cell.Row, column_cell.Column))
</code></pre>

Other methods outlined here seems to require no empty rows/columns between data.

source: <a href="https://gist.github.com/Elijas/2430813d3ad71aebcc0c83dd1f130e33" rel="nofollow noreferrer">https://gist.github.com/Elijas/2430813d3ad71aebcc0c83dd1f130e33</a>

blocks|key|1567227|text|综合上面的答案，您可以在一行中完成：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1567228|wb.sheet.range(column+%2B+last+cell+value).Get+End+of+section+going+up[non+blank+assuming+the+last+cell+is+blank].row|code-block|syntax|javascript|1567229|示例代码：|1567230|import+xlwings+as+xw
from+xlwings+import+Range,+constants

wb+=+xw.Book(r'path.xlsx')
wb.sheets[0].range('A'+%2B+str(wb.sheets[0].cells.last_cell.row)).end('up').row|1567231|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Consolidating the answers above, you can do it in one line:

<pre><code>wb.sheet.range(column + last cell value).Get End of section going up[non blank assuming the last cell is blank].row
</code></pre>

Example code:

<pre><code>import xlwings as xw
from xlwings import Range, constants

wb = xw.Book(r'path.xlsx')
wb.sheets[0].range('A' + str(wb.sheets[0].cells.last_cell.row)).end('up').row
</code></pre>

blocks|key|1555375|text|我们可以使用Range对象查找最后一行和/或最后一列：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1555376|import+xlwings+as+xw

#+open+raw+data+file
filename_read+=+'data_raw.csv'
wb+=+xw.Book(filename_read)
sht+=+wb.sheets[0]

#+find+the+numbers+of+columns+and+rows+in+the+sheet
num_col+=+sht.range('A1').end('right').column
num_row+=+sht.range('A1').end('down').row

#+collect+data
content_list+=+sht.range((1,1),(num_row,num_col)).value
print(content_list)|code-block|syntax|javascript|1555377|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

We can use Range object to find the last row and/or the last column:

<pre><code>import xlwings as xw

# open raw data file
filename_read = 'data_raw.csv'
wb = xw.Book(filename_read)
sht = wb.sheets[0]

# find the numbers of columns and rows in the sheet
num_col = sht.range('A1').end('right').column
num_row = sht.range('A1').end('down').row

# collect data
content_list = sht.range((1,1),(num_row,num_col)).value
print(content_list)
</code></pre>

blocks|key|3220366|text|Python3.6，xlwing+0.11|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3220367|溶质素1|3220368|要查找最后一行的数据，您应该做一些水平和垂直的工作。您必须遍历每一列，以确定哪一行是最后一行。|3220369|import+xlwings
workbook_all+=+xlwings.Book(r'path.xlsx')
objectiveSheet+=+workbook_all+.sheets['some_sheet']
#+lastCellContainData(),+inspired+of+Stefan's+answer.
def+lastCellContainData(objectiveSheet,lastRow=None,lastColumn=None):
++++lastRow+=+objectiveSheet.cells.last_cell.row+if+lastRow==None+else+lastRow
++++lastColumn+=+objectiveSheet.cells.last_cell.column+if+lastColumn==None+else+lastColumn
++++lastRows,lastColumns+=+[],[]
++++for+col+in+range(1,lastColumn):
++++++++lastRows.append(objectiveSheet.range((lastRow,+col)).end('up').row)
++++++++#+extract+last+row+of+every+column,+then+max().+Or+you+can+compare+the+next+
++++++++#+column's+last+row+number+to+the+last+column's+last+row+number.+Here+you+get
++++++++#+the+last+row+with+data,+you+can+also+go+further+get+the+last+column+with+data:
++++for+row+in+range(1,lastRow):
++++++++lastColumns.append(objectiveSheet.range((row,+lastColumn)).end('left').column)
++++return+max(lastRows),max(lastColumns)
++++
lastCellContainData(objectiveSheet,lastRow=5000,lastColumn=300)|code-block|syntax|javascript|3220370|我添加了lastRow和lastColumn。为了使程序更有效，您可以根据所处理的数据的近似形状来设置这些参数。|3220371|解决方案2|3220372|作为pywin32的包装器，xlwing是很荣幸的。我不知道你的情况是否允许键盘或鼠标。如果是这样的话，首先ctrl%2Btab切换到工作簿，然后ctrl%2Ba选择包含数据的区域，然后调用workbook_all.selection.rows.count。|offset|length|style|CODE|3220373|另一种方法:当您知道数据的右底部单元格位于什么位置时，例如AAA10000，只需调用objectiveSheet.range('A1:'%2B'AAA10000').current_region.rows.count即可。|3220374|entityMap^0|0|0|0|0|0|0|2J|X|0|16|1S|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|10|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|11|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|13|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|14|8|@$Q|15|R|16|S|T]]|9|@]|A|$]]|$1|U|3|V|5|6|7|17|8|@$Q|18|R|19|S|T]]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|X|$]]

python 3.6, xlwings 0.11
<h1>Solutoin 1</h1>
To find last row with data, you should do some work both horizontally and vertically. You have to go through every column to determine which row is the last row.
<pre><code>import xlwings
workbook_all = xlwings.Book(r'path.xlsx')
objectiveSheet = workbook_all .sheets['some_sheet']
# lastCellContainData(), inspired of Stefan's answer.
def lastCellContainData(objectiveSheet,lastRow=None,lastColumn=None):
 lastRow = objectiveSheet.cells.last_cell.row if lastRow==None else lastRow
 lastColumn = objectiveSheet.cells.last_cell.column if lastColumn==None else lastColumn
 lastRows,lastColumns = [],[]
 for col in range(1,lastColumn):
 lastRows.append(objectiveSheet.range((lastRow, col)).end('up').row)
 # extract last row of every column, then max(). Or you can compare the next 
 # column's last row number to the last column's last row number. Here you get
 # the last row with data, you can also go further get the last column with data:
 for row in range(1,lastRow):
 lastColumns.append(objectiveSheet.range((row, lastColumn)).end('left').column)
 return max(lastRows),max(lastColumns)
 
lastCellContainData(objectiveSheet,lastRow=5000,lastColumn=300)
</code></pre>
I added lastRow and lastColumn. To make the program more effective, you can set these parameters according to the approximate shape of the data you're dealing with.
<h1>Solution 2</h1>
xlwings is honored for being wrapper of pywin32. I don't know if your situation allows for keyboard or mouse. If so, first you ctrl+tab switch to the workbook, then ctrl+a to select the region containing data, then you call <code>workbook_all.selection.rows.count</code>.
another way:
When you know where right bottom cell of your data locates faintly, say AAA10000, just call <code>objectiveSheet.range('A1:'+'AAA10000').current_region.rows.count</code>

blocks|key|3220399|text|更新：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|3220400|过了一段时间，这些解决方案对我来说都不是很直观的，所以我决定编译如下：代码：|3220401|import+xlwings+as+Objxlwings
import+xlwings.constants
def+Return_RangeLastCell(ObjWS):
++++return+ObjWS.api.Cells.SpecialCells(xlwings.constants.CellType.xlCellTypeLastCell)|code-block|syntax|javascript|3220402|我试图保持与从Excel调用它的方法的一致性，以保持它的简单性|3220403|然后，在我的主要代码中，我就这样称呼它：|3220404|ObjWS=Objxlwings.Book('Book1.xlsx').sheets["Sheet1"]
print(Return_RangeLastCell(ObjWS).Column)|3220405|entityMap^0|0|3|0|Z|3|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|X|8|@$9|Y|A|Z|B|C]]|D|@]|E|$]]|$1|H|3|I|5|J|7|10|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|11|8|@]|D|@]|E|$]]|$1|O|3|P|5|6|7|12|8|@]|D|@]|E|$]]|$1|Q|3|R|5|J|7|13|8|@]|D|@]|E|$K|L]]|$1|S|3|-4|5|6|7|14|8|@]|D|@]|E|$]]]|T|$]]

Update:
 After a while none of the solutions were really intuitive to me, so I decided to compile the following:
Code:
<pre><code>import xlwings as Objxlwings
import xlwings.constants
def Return_RangeLastCell(ObjWS):
 return ObjWS.api.Cells.SpecialCells(xlwings.constants.CellType.xlCellTypeLastCell)
</code></pre>
I tried to keep consistency with the way to call it from Excel to keep it simple
 Then on my main code, I just call it like so:
<pre><code>ObjWS=Objxlwings.Book('Book1.xlsx').sheets[&quot;Sheet1&quot;]
print(Return_RangeLastCell(ObjWS).Column)
</code></pre>

I am trying to find the last row in a column with data. to replace the vba function: <code>LastRow = sht.Cells(sht.Rows.Count, "A").End(xlUp).Row</code>

I am trying this, but this pulls in all rows in Excel. How can I just get the last row.

<pre><code>from xlwings import Workbook, Range
wb = Workbook()
print len(Range('A:A'))
</code></pre>

xlwings function to find the last row with data

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在试图找到包含数据的列中的最后一行。替换vba函数：LastRow = sht.Cells(sht.Rows.Count, "A").End(xlUp).Row我正在尝试这样做，但这会将Excel中的所有行都拉进来。我怎么才能拿到最后一排。from xlwings import Workbook, Rangewb ...

问函数来查找数据的最后一行。
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问函数来查找数据的最后一行。EN