fork download
copy 
  1. import openpyxl as px
  2.  
  3. wb = px.load_workbook(r"C:\Users\〇〇〇\Desktop\テスト.xlsx")
  4. ws = wb["Sheet1"]
  5.  
  6. lastrow = ws.max_row
  7.  
  8. for i in range(2, lastrow + 1):
  9.     suraisu = ws.cell(row=i,column=1).value
  10.     if suraisu != None:
  11.         ws.cell(row=i,column=1).value = str(suraisu)[2:5]
  12.  
  13.  
  14. def save():
  15.     wb.save(filename = r"C:\Users\〇〇〇\Desktop\テスト.xlsx")
  16. save()
  17.  
  18.  
Runtime error #stdin #stdout #stderr 0.17s 23840KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
stderr
copy 
Traceback (most recent call last):
  File "./prog.py", line 1, in <module>
    import openpyxl as px
ModuleNotFoundError: No module named 'openpyxl'
https://ideone.com/Ia6xjr
language:
Python 3 nbc (python 3.7.3)
created:
1 year ago
visibility:
secret

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!