投稿

xlwings：Python for Excel

2.6万

19

2020-01-24 20:36:23

https://www.xlwings.org/ xlwings: Python for Excel 加入扣扣群：208022794，获取课程资料~

石豆豆小盆友发消息

【苏星河】软件界的富二代，阿里千问有多狠？

苏星河牛通

02_01 Install the Anaconda Python distribution _ xlwings Training

04:16

02_02 Python default installation

08:05

02_03 Upgrade xlwings

06:49

02_04 Jupyter Notebook

02:57

03_02 How does it work!

01:36

03_03 xw.view(), Connect to a book, Range object

09:46

03_04 2d Ranges

02:41

03_05 1d Ranges

03:22

03_06 autofit and background color

01:19

03_07 Range indexing and slicing

01:29

03_08 Full qualification with app object and Multiple Excel instances

04:01

03_09 Active Objects

02:23

03_10 Sheets with Range shortcut (sheet[...])

03:36

03_11 Excel charts & Matplotlib

08:05

03_12 Excel's Table Objects

04:00

03_13 Efficiency

03:16

03_14 Workaround for missing features

03:55

03_15 Calling VBA Subs and Functions

02:58

04_01 Default and dict converters

05:56

04_02 NumPy and Pandas converters

07:15

05_01 How does it work!

02:27

05_02 Excel add-in installation

06:12

05_03 xlwings quickstart (CLI) & RunPython (VBA)

07:40

05_04 Excel add-in settings and config files

12:13

06_01 How does it work!

02:47

06_02 One-off preparations

01:43

06_03 Our first UDF Hello World

05:50

06_04 Array Formulas

05:05

06_05 Numpy and Pandas converters & options @xw.arg and @xw.ret decorators

06:35

06_06 Dynamic Arrays

05:07

06_07 Excel add-in： UDF specific settings

03:08

06_08 In-Excel SQL extension

03:20

06_09 A practical example

03:08

06_10 Asynchronous Functions

02:29

07_01 Debugging RunPython

07:58

07_02 Debugging UDFs (Win only)

08:07

07_03 Real time feeds：Write from Python to Excel

03:31

07_04 Real time feeds：Read Excel from Python

02:37

07_05 Custom xlwings Extensions

11:56

07_06 Custom Converters

14:21

07_07 Call Python functions from VBA in other office apps (e.g. MS Access) (Win

08:54

07_08 REST API

10:11

08_01 Introduction to unit tests and Python's unittest module

10:58

08_02 Use Python and xlwings to unit test your mission critical Excel tools

11:32

09_01 Prototyping web apps with xlwings

08:44

09_02 Python package

06:03

09_03 xlwings as standalone VBA module

03:10

09_04 Frozen executable (Win only)

08:00

顶部