当前位置 : 主页 > 编程语言 > python >

Excel 扩展编程相关

来源:互联网 收集:自由互联 发布时间:2022-06-15
============================ 产品分析 ============================ Excel Automation Tools (Best of List) https://www.automateexcel.com/excel-automation-tools https://www.querystorm.com/ https://www.pyxll.com/ https://sqlspreads.com/sql-

============================

产品分析

============================

Excel Automation Tools (Best of List)

https://www.automateexcel.com/excel-automation-tools

https://www.querystorm.com/

https://www.pyxll.com/

https://sqlspreads.com/sql-spreads-benefits/

https://www.devart.com/excel-addins/sqlite.html

https://www.sqlforexcel.com/(开源)

============================

技术文章

============================

https://www.pyxll.com/blog/tools-for-working-with-excel-and-python/


xlwings : 从此可以 VBA 调用 Python 代码啦


Excel & Python

http://www.snb-vba.eu/VBA_Python_en.html


Interactive Data Analysis with Python and Excel

https://pbpython.com/xlwings-pandas-excel.html


xlwings: Use Python and Excel to Calculate Your Mortgage

https://matthewkudija.com/blog/2018/03/25/xlwings-mortgage/



Use Matplotlib from Excel with xlwings

https://newtonexcelbach.com/2016/02/14/use-matplotlib-from-excel-with-xlwings/


Writing UDFs in Excel With Python

https://www.myonlinetraininghub.com/writing-udfs-in-excel-with-python


浅谈Excel开发:一 Excel 开发概述



ExcelDna 官方文档

https://github.com/Excel-DNA/ExcelDna/wiki


【20180529】- VSTO和ExcelDna开发插件那个更好?

https://zhuanlan.zhihu.com/p/37949183


Pros and cons of VSTO vs Excel-DNA? [closed]

https://stackoverflow.com/questions/26974959/pros-and-cons-of-vsto-vs-excel-dna


为Excel XLL插件 UDF 函数增加chm帮助

https://github.com/Excel-DNA/ExcelDnaDoc


新人大餐:2018最新Office插件开发之ExcelDNA开发XLL插件免费教学视频,五分钟包教包会


============================

ExcelDNA示例

============================

ExcelDna项目完整工程演示及讲解


Charltsing 博主开源的ExcelDNA示例, 项目脚手架,  包含打包脚本

http://github.com/Charltsing/ExcelDnaProjectDemo



Excel催化剂开源的ExcelDNA示例

http://github.com/minren118/ExcelUdfByExcelCuiHuaJi


另一个示例, 注意 *.dna 配置文件的写法, 和调试说明

https://github.com/fb19801101/ExcelDna-CSharpAddin



在 Udf 函数中, 如何获取 Excel range

https://github.com/gaham/TransposeBy


调试步骤

https://stackoverflow.com/questions/25203326

Use "Debug"/"Attach to Process", from Visual Studio, and connect to Excel. Then open the xll from Excel. This will hopefully show you the error.


==================

sql 方式访问 excel

==================

https://stackoverflow.com/questions/18798522/how-to-run-a-sql-query-on-an-excel-table

https://smallbusiness.chron.com/use-sql-statements-ms-excel-41193.html

https://www.wikihow.com/Embed-a-SQL-Query-in-Microsoft-Excel


上一篇:Mixins and Python
下一篇:没有了
网友评论