OpenPyXL

import openpyxl
## Workbook
wb = openpyxl.load_workbook('sample.xlsx')
wb = openpyxl.Workbook()
wb.save('sample.xlsx')
wb.sheetnames
## Worksheet
ws = wb['Sheet']
ws = wb.worksheets[0]
ws.title
## Cell A1
c1 = ws['A1']
c1 = ws.cell(1, 1)
c1.coordinate
c1.row
c1.column
c1.value = 100

## Cell A2
c2 = ws['A2']
c2 = ws.cell(2, 1)
c2.value = "=SUM(A1:A1)"
## Region
r1 = ws['A1:C3']

Daiphys is a professional-service company for research and development of leading-edge technologies in physics and engineering.
Get started accelerating your business through our deep expertise in R&D with AI, quantum computing, and space development; please get in touch with Daiphys today!

Name*


Email*


Message*


* Indicates required field

Daiphys Technologies LLC - https://www.daiphys.com/

  • Last modified: 2023/05/11 05:18
  • by Daiphys