xlwings

Analyze 46 million taxi rides in 4 seconds in Excel with DuckDB and Parquet files

xlwings

Analyze 46 million taxi rides in 4 seconds in Excel with DuckDB and Parquet files

5:41

Part 8 (xlwings Server): Task Pane Development

xlwings

Part 8 (xlwings Server): Task Pane Development

5:17

Part 8 (xlwings Server): Custom Scripts

xlwings

Part 8 (xlwings Server): Custom Scripts

18:06

Part 8 (xlwings Server): Custom Functions

xlwings

Part 8 (xlwings Server): Custom Functions

33:31

Part 7: Frozen executable (Win only)

xlwings

Part 7: Frozen executable (Win only)

7:34

Part 7: xlwings as standalone VBA module

xlwings

Part 7: xlwings as standalone VBA module

2:52

Part 7: xlwings as standalone VBA module

xlwings

Part 7: xlwings as standalone VBA module

2:52

Part 7: Python package

xlwings

Part 7: Python package

5:47

Part 7: Prototyping web apps with xlwings

xlwings

Part 7: Prototyping web apps with xlwings

8:24

Part 6: Use Python and xlwings to unit test your mission critical Excel tools

xlwings

Part 6: Use Python and xlwings to unit test your mission critical Excel tools

11:15

Part 6: Introduction to unit tests and Python's unittest module

xlwings

Part 6: Introduction to unit tests and Python's unittest module

10:40

Part 5: Custom Converters

xlwings

Part 5: Custom Converters

14:05

Part 5: Custom xlwings Extensions

xlwings

Part 5: Custom xlwings Extensions

11:36

Part 5: Real time feeds: Read Excel from Python

xlwings

Part 5: Real time feeds: Read Excel from Python

2:24

Part 5: Real time feeds: Write from Python to Excel

xlwings

Part 5: Real time feeds: Write from Python to Excel

3:12

Part 5: Debugging UDFs (Win only)

xlwings

Part 5: Debugging UDFs (Win only)

7:55

Part 5: Debugging RunPython

xlwings

Part 5: Debugging RunPython

7:29

Part 4: Asynchronous Functions

xlwings

Part 4: Asynchronous Functions

2:15

Part 4: A practical UDF example

xlwings

Part 4: A practical UDF example

2:43

Part 4: In-Excel SQL extension

xlwings

Part 4: In-Excel SQL extension

2:41

Part 4: Excel add-in: UDF specific settings

xlwings

Part 4: Excel add-in: UDF specific settings

2:43

Part 4: Numpy and Pandas converters & options: @xw.arg and @xw.ret decorators

xlwings

Part 4: Numpy and Pandas converters & options: @xw.arg and @xw.ret decorators

6:12

Part 4: Array Formulas

xlwings

Part 4: Array Formulas

4:48

Part 4: Our first UDF: Hello World

xlwings

Part 4: Our first UDF: Hello World

5:24

Part 4: One-off preparations

xlwings

Part 4: One-off preparations

1:23

Part 4: User-defined functions (UDFs) - How does it work?!

xlwings

Part 4: User-defined functions (UDFs) - How does it work?!

2:22

Part 3: Excel add-in: settings / config files

xlwings

Part 3: Excel add-in: settings / config files

11:42

Part 3: xlwings quickstart (CLI) & RunPython (VBA)

xlwings

Part 3: xlwings quickstart (CLI) & RunPython (VBA)

6:21

Part 3: Excel add-in: installation

xlwings

Part 3: Excel add-in: installation

5:47

Part 3: RunPython - How does it work?!

xlwings

Part 3: RunPython - How does it work?!

1:57

Part 2: NumPy and Pandas converters

xlwings

Part 2: NumPy and Pandas converters

6:49

Part 2: Default and dict converters

xlwings

Part 2: Default and dict converters

5:30

Part 1: Calling VBA Subs/Functions

xlwings

Part 1: Calling VBA Subs/Functions

2:35

Part 1: Workaround for missing features

xlwings

Part 1: Workaround for missing features

3:32

Part 1: Efficiency

xlwings

Part 1: Efficiency

2:59

Part 1: Excel's Table Objects

xlwings

Part 1: Excel's Table Objects

3:39

Part 1: Excel charts & Matplotlib

xlwings

Part 1: Excel charts & Matplotlib

7:36

Part 1: Sheets with Range shortcut (sheet[...])

xlwings

Part 1: Sheets with Range shortcut (sheet[...])

3:08

Part 1: Active Objects

xlwings

Part 1: Active Objects

1:54

Part 1: Full qualification with app object / Multiple Excel instances

xlwings

Part 1: Full qualification with app object / Multiple Excel instances

3:40

Part 1: Range indexing/slicing

xlwings

Part 1: Range indexing/slicing

1:01

Part 1: autofit and background color

xlwings

Part 1: autofit and background color

0:52

Part 1: 1d Ranges

xlwings

Part 1: 1d Ranges

2:59

Part 1: 2d Ranges

xlwings

Part 1: 2d Ranges

2:18

Part 1: xw.view(), Connect to a book, Range object

xlwings

Part 1: xw.view(), Connect to a book, Range object

9:23

Part 1: xlwings Basics - How does it work?!

xlwings

Part 1: xlwings Basics - How does it work?!

1:14

Intro: Jupyter Notebook

xlwings

Intro: Jupyter Notebook

2:38

xlwings Lite: a better way to use Python in Excel

xlwings

xlwings Lite: a better way to use Python in Excel

5:42

Stream Bitcoin prices to Excel via streaming functions

xlwings

Stream Bitcoin prices to Excel via streaming functions

3:56

Excel Custom Functions ("UDFs") with Python and Azure Functions (webinar)

xlwings

Excel Custom Functions ("UDFs") with Python and Azure Functions (webinar)

30:56

Python in Excel: How to write =PY cells in VS Code

xlwings

Python in Excel: How to write =PY cells in VS Code

5:29

How to use GitHub Copilot with VBA in Excel

xlwings

How to use GitHub Copilot with VBA in Excel

6:33

Use Python to write Custom Functions for Excel (Win/macOS/Web)

xlwings

Use Python to write Custom Functions for Excel (Win/macOS/Web)

8:09

Build Office.js add-ins for Excel with Python

xlwings

Build Office.js add-ins for Excel with Python

1:02:26

Connect Google Sheets to SQLite

xlwings

Connect Google Sheets to SQLite

7:06

How to build web apps with Google Sheets and Python

xlwings

How to build web apps with Google Sheets and Python

52:42

Edit your Excel VBA with VS Code (with auto-sync)

xlwings

Edit your Excel VBA with VS Code (with auto-sync)

10:00

The new xlwings Remote Interpreter

xlwings

The new xlwings Remote Interpreter

54:36

Automate Excel on the web with Python & xlwings (Development environment)

xlwings

Automate Excel on the web with Python & xlwings (Development environment)

6:51

Automate Google Sheets with Python & xlwings (Development environment)

xlwings

Automate Google Sheets with Python & xlwings (Development environment)

10:39

Webinar: Automate your PDF factsheets with xlwings Reports

xlwings

Webinar: Automate your PDF factsheets with xlwings Reports

49:44

Bulk Create QR Codes in Excel with Python

xlwings

Bulk Create QR Codes in Excel with Python

9:50

xlwings PRO: How to release tools with the one-click installer

xlwings

xlwings PRO: How to release tools with the one-click installer

12:46

Python for Excel (O'Reilly Book)

xlwings

Python for Excel (O'Reilly Book)

17:24

What Makes Excel's Lambda Functions so Awesome (and what doesn't)?

xlwings

What Makes Excel's Lambda Functions so Awesome (and what doesn't)?

11:32

Do you know what Spreadsheets are used for in your company and why they are necessary? by Sam Arthur

xlwings

Do you know what Spreadsheets are used for in your company and why they are necessary? by Sam Arthur

13:46

ExcelAnalyzer – Build better, faster and error-free spreadsheets (by Maarten Bessems)

xlwings

ExcelAnalyzer – Build better, faster and error-free spreadsheets (by Maarten Bessems)

21:53

xlwings Performance by Felix Zumstein

xlwings

xlwings Performance by Felix Zumstein

21:28

Git for Excel (webinar)

xlwings

Git for Excel (webinar)

52:12

Deployment of xlwings-powered spreadsheets (webinar)

xlwings

Deployment of xlwings-powered spreadsheets (webinar)

45:52

xlwings Reports: An introduction to Frames

xlwings

xlwings Reports: An introduction to Frames

3:30

How to embed your Python code in Excel with xlwings PRO (no more external source code file needed)

xlwings

How to embed your Python code in Excel with xlwings PRO (no more external source code file needed)

2:56

The new "Run main" button in the xlwings add-in (added in xlwings CE v0.16.0)

xlwings

The new "Run main" button in the xlwings add-in (added in xlwings CE v0.16.0)

2:13

Live data sharing & workflow automation: By David Jones at the xlwings meetup in London (16 Jan 20)

xlwings

Live data sharing & workflow automation: By David Jones at the xlwings meetup in London (16 Jan 20)

16:58

Reporting with Excel & Python: Talk by Felix Zumstein at the xlwings meetup in London (16 Jan 20)

xlwings

Reporting with Excel & Python: Talk by Felix Zumstein at the xlwings meetup in London (16 Jan 20)

24:37

Using xlwings & finmarketpy: Talk by Saeed Amen at the xlwings meetup in London (16 Jan 20)

xlwings

Using xlwings & finmarketpy: Talk by Saeed Amen at the xlwings meetup in London (16 Jan 20)

20:48

Python and Excel in Finance (Talk by Felix Zumstein at the PyData Meetup Zurich)

xlwings

Python and Excel in Finance (Talk by Felix Zumstein at the PyData Meetup Zurich)

24:32

xlwings reports

xlwings

xlwings reports

3:50

XLKitLearn: Learning Data Science in Excel (xlwings Meetup NYC)

xlwings

XLKitLearn: Learning Data Science in Excel (xlwings Meetup NYC)

27:27

Automated Testing of Excel Workbooks (xlwings Meetup NYC)

xlwings

Automated Testing of Excel Workbooks (xlwings Meetup NYC)

37:38

Git for Excel Workbooks (xlwings Meetup London)

xlwings

Git for Excel Workbooks (xlwings Meetup London)

50:10

The new dynamic arrays in Microsoft Excel with Python and xlwings

xlwings

The new dynamic arrays in Microsoft Excel with Python and xlwings

3:14

xltrail quickstart: Excel version control via drag and drop

xlwings

xltrail quickstart: Excel version control via drag and drop

5:00

xltrail quickstart: Git integration

xlwings

xltrail quickstart: Git integration

4:48

xltrail quickstart: Compare two Excel files ad-hoc

xlwings

xltrail quickstart: Compare two Excel files ad-hoc

2:40

Track Changes in Excel Files with xltrail version control

xlwings

Track Changes in Excel Files with xltrail version control

2:18

xlwings Excel REST API

xlwings

xlwings Excel REST API

2:05

Call Python from VBA in Microsoft Access (via xlwings)

xlwings

Call Python from VBA in Microsoft Access (via xlwings)

0:17

Git for Excel Files (Webinar)

xlwings

Git for Excel Files (Webinar)

59:59

xlwings: UDFs (User Defined Functions)

xlwings

xlwings: UDFs (User Defined Functions)

2:42

xlwings: Macros / Excel Tools

xlwings

xlwings: Macros / Excel Tools

2:25

xlwings: Excel automation / interaction

xlwings

xlwings: Excel automation / interaction

2:51

xlwings: Array based CORREL function powered by Python + Pandas

xlwings

xlwings: Array based CORREL function powered by Python + Pandas

1:56

次のページ