Skip to content

Instantly share code, notes, and snippets.

@datagy
Created March 25, 2020 21:20
Show Gist options
  • Select an option

  • Save datagy/bc02a010fda96d070e4ddc5aa76140ad to your computer and use it in GitHub Desktop.

Select an option

Save datagy/bc02a010fda96d070e4ddc5aa76140ad to your computer and use it in GitHub Desktop.
# Section 1
import openpyxl
files = [] #include paths to your files here
values = []
# Section 2
for file in files:
wb = openpyxl.load_workbook(file)
sheet = wb['Sheet1']
value = sheet['F5'].value
values.append(value)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment