VBA vs Python Fundamentals

VBA vs Python Fundamentals

12 chapters
56 sections
0 images

Document Index

Excel Programming and Python Programming Overview

4 sections

About Excel Scripting Writing Programs with Excel VBA Writing Programs with Python Programming Specifications

Constants and Variables

4 sections

Constants Variables and Their Operations Data Types of Variables Numbers

Expressions

7 sections

Arithmetic Operators Relational Operators Logical Operators Assignment Operators and Arithmetic Assignment Operators Membership Operators Identity Operators Operator Precedence

Getting Started with the Excel Object Model

3 sections

Excel Object Model General Process for Operating the Excel Object Model Common Operations Related to the Excel Object Model

Flow Control

5 sections

Decision Structures Loop Structures: for Loop Loop Structures: while Loop Other Structures in Excel VBA Other Statements

Strings

9 sections

Creating Strings Indexing and Slicing of Strings String Formatting Output Case Conversion of Strings Splitting and Joining Strings Searching and Replacing Strings Comparing Strings Trimming Spaces from Strings String Caching Mechanism in Python

Arrays

5 sections

Arrays in Excel VBA Arrays in Python: Lists Arrays in Python: Tuples Arrays in Python: NumPy Arrays Indexed Arrays in Python: Series and DataFrame

User-Defined Functions

5 sections

User-Defined Functions in Excel VBA User-Defined Functions in Python Examples of User-Defined Functions Reading/Writing Dictionary Data Dictionary Application Examples

Sets

4 sections

Concepts Related to Sets Creation and Modification of Sets Set Operations Examples of Set Applications

Functions

6 sections

Built-in Functions Third-Party Library Functions User-Defined Functions Scope and Lifetime of Variables Anonymous Functions in Python Examples of Function Applications

Modules and Projects

2 sections

Modules Projects

Debugging and Exception Handling

2 sections

Debugging in Excel VBA Exception Handling in Python