Advertisement
teslariu

intro a openpyxl

Nov 19th, 2022
925
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.46 KB | None | 0 0
  1. #!/usr/bin/env python
  2. # -*- coding: utf-8 -*-
  3.  
  4. # para descargar openpyxl
  5. # python -m pip install openpyxl
  6.  
  7. from openpyxl import Workbook
  8. # creo un libro de Excel
  9. libro = Workbook()
  10.  
  11. # creo una hoja
  12. hoja = libro.active
  13.  
  14. # Agrego el nro 42 a la celda A1
  15. hoja['A1'] = 42
  16.  
  17. # Agrego 3 nros a las celdas A2,B2,C2
  18. hoja.append([1, 2, 3])
  19.  
  20. # Imprimo la hora
  21. import datetime
  22. hoja['A3'] = datetime.datetime.now()
  23.  
  24. # Grabo el libro
  25. libro.save("PYTHON.xlsx")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement