Excel VBA vs Python xlwings

Excel VBA vs Python xlwings

9 chapters

30 sections

0 images

Document Index

In-Depth Exploration of the Excel Object Model

6 sections

Overview of the Excel Object Model Excel Application Object Workbook Object Worksheet Object Cell Object Application Examples of the Excel Object Model

Interface Design

3 sections

Forms Controls Interface Design Example

File Operations

2 sections

Reading/Writing Text Files Reading/Writing Binary Files

Excel Worksheet Functions

2 sections

Overview of Excel Worksheet Functions Commonly Used Excel Worksheet Functions

Excel Graphics

3 sections

Creating Graphics Shape Transformations Picture Operations

Excel Charts

3 sections

Creating Charts Charts and Series Coordinate Systems

Excel Pivot Tables

5 sections

Creation and Reference of Pivot Tables Editing Pivot Tables Layout and Style of Pivot Tables Sorting and Filtering of Pivot Tables Calculations in Pivot Tables

Regular Expressions

2 sections

Overview of Regular Expressions Rules for Writing Regular Expressions

Statistical Analysis

4 sections

Importing Data Data Cleaning Data Preprocessing Descriptive Statistics