Excel 扩展编程相关
============================
产品分析
============================
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 代码啦
https://blog.csdn.net/stone0823/article/details/100553728
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 开发概述
https://www.cnblogs.com/yangecnu/p/Excel-Develpment-Introduction.html
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插件免费教学视频,五分钟包教包会
https://www.cnblogs.com/Charltsing/p/ExcelDnaVideoCourse.html
============================
ExcelDNA示例
============================
ExcelDna项目完整工程演示及讲解
https://www.cnblogs.com/Charltsing/p/ExcelDnaDemo.html
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
最新文章
- C++ 取得系统当前时间
- C# 将文件嵌入DLL 。Log4net 配置
- EXTJS4自学手册——EXT基本方法、属性(mixins多继承、statics、require)
- .Net平台下,分布式文件存储的实现
- loop指令
- 【HDU 2546】饭卡(DP+贪心)
- SpringMVC配置
- HTML中的鼠标光标属性
- C# Winform常见的Editor
- CodeForces 702 A Maximum Increase (贪心,高效算法)
- http://www.cnblogs.com/
- Sql Server专题一:索引(下)
- (Android)Wifi-Direct直连
- 第三章 go语言 程序的流程控制
- 无依赖简单易用的Dynamics 365公共视图克隆工具
- LeetCode算法题-Minimum Moves to Equal Array Elements(Java实现)
- ArcGis Classic COM Add-Ins插件开发的一般流程 C#
- NopCommerce 更改发票字体
- gcc请不要优化
- ajax done和always区别