Advertisement
WupEly

Untitled

Nov 21st, 2022
39
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. import jpype
  2. import asposecells
  3. jpype.startJVM()
  4. from asposecells.api import *
  5.  
  6. workbook = Workbook("test.xlsx")
  7.  
  8. worksheet = workbook.getWorksheets().get(0)
  9.  
  10. cells = worksheet.getCells()
  11. cells.getMaxColumn()
  12. for row in range(cells.getMaxRow() + 1):
  13. line = []
  14. for column in range(cells.getMaxColumn() + 1):
  15. line.append(cells.get(row, column).getDisplayStringValue())
  16. print(line)
  17.  
  18.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement