Spreadsheet Tools Manual

Overview

This skill provides instructions and code for manipulating spreadsheets, generating formulas, and analyzing data.

Working with pandas and openpyxl

Reading and Writing Excel Files

import pandas as pd

# Read Excel file
df = pd.read_excel('data.xlsx', sheet_name='Sheet1')

# Write DataFrame to a new Excel file
df.to_excel('output.xlsx', index=False)