Skip to content

Instantly share code, notes, and snippets.

@stephensmitchell

stephensmitchell/Reading-from-a-Spreadsheet.py

Created October 14, 2025 10:35
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save stephensmitchell/393a7b595aefb7b583de1b7c2accec73 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save stephensmitchell/393a7b595aefb7b583de1b7c2accec73 to your computer and use it in GitHub Desktop.
Download ZIP
Reading from a Spreadsheet
Raw
Reading-from-a-Spreadsheet.py
#https://help.alibre.com/articles/#!alibre-help-v28/reading-from-a-spreadsheet
from openpyxl import load_workbook
# open a workbook, replace with your own path
wb = load_workbook(filename = 'C:\\Users\\<username>\\Downloads\\Book1.xlsx')
# get access to the sheet
Sheet1 = wb['Sheet1']
# get the value in cell C3
print Sheet1['C3'].value
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment