Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR PYTHON

excel with python

# Install openpyxl
# pip install openpyxl

# Read excel sheet
workbook = load_workbook(filename=file_path)
sheet = workbook.active
for temps in sheet.iter_rows(min_row=2, min_col=1, max_col=5, values_only=True):
  # Add you code
  # You should get all the parsed columns in temps as temps[0], temps[1] etc
Source by zetcode.com #
 
PREVIOUS NEXT
Tagged: #excel #python
ADD COMMENT
Topic
Name
2+3 =