Skip to content

Instantly share code, notes, and snippets.

@documentprocessing

documentprocessing/udpate-existing-column-in-XLS-with-Pyexcel-XLS.py

Created March 26, 2024 19:11
Show Gist options
  • Save documentprocessing/7fc53c8bbcec1c0393f2e794d4864d83 to your computer and use it in GitHub Desktop.
Save documentprocessing/7fc53c8bbcec1c0393f2e794d4864d83 to your computer and use it in GitHub Desktop.
Download ZIP
Update existing Column in XLS file with Pyexcel-XLS
Raw
udpate-existing-column-in-XLS-with-Pyexcel-XLS.py
import pyexcel as p
#open a sample Excel file
sheet = p.get_sheet(file_name="example.xls")
#update data in existing column
sheet.column[2] = ["Column 3", 100, 200, 300]
#Save XLS file to disc
sheet.save_as("updateexisting.xls")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment