<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[m0_73209313的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/m0_73209313</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; m0_73209313]]></copyright><item><title><![CDATA[EXCEL VBA与SQL server的交互（二）]]></title><link>https://blog.youkuaiyun.com/m0_73209313/article/details/131426057</link><guid>https://blog.youkuaiyun.com/m0_73209313/article/details/131426057</guid><author>m0_73209313</author><pubDate>Tue, 27 Jun 2023 21:56:14 +0800</pubDate><description><![CDATA[有了ADO就不同的，只要按照ADO的规则，那么对于SQL server和MySQL来说插入的语句的写法是一样的。我们使用VBA与外部数据源做交互的时候都会使用到ADO，比如和SQL server的交互、和计算机本地文本文件的交互、和Oracle的交互、和Mysql的交互、以及和Access的交互等。接下来要讲的偏技术，主要讲解VBA与SQL server交互的原理，也是为第三篇，代码的优化做铺垫；而ADO的优势就是，不管访问的是什么外部数据源，ADO的使用者只需要一组相同的命令。]]></description><category></category></item><item><title><![CDATA[EXCEL VBA与SQL server的交互（一）]]></title><link>https://blog.youkuaiyun.com/m0_73209313/article/details/131359450</link><guid>https://blog.youkuaiyun.com/m0_73209313/article/details/131359450</guid><author>m0_73209313</author><pubDate>Sat, 24 Jun 2023 11:20:46 +0800</pubDate><description><![CDATA[本文简单的介绍了VBA如何连接数据库，查询并获取数据，以及保存数据]]></description><category></category></item><item><title><![CDATA[EXCEL与PYTHON系列第二篇---xlwings(1)]]></title><link>https://blog.youkuaiyun.com/m0_73209313/article/details/127380579</link><guid>https://blog.youkuaiyun.com/m0_73209313/article/details/127380579</guid><author>m0_73209313</author><pubDate>Tue, 18 Oct 2022 07:57:49 +0800</pubDate><description><![CDATA[python xlwings VBA pandas]]></description><category></category></item><item><title><![CDATA[EXCEL与PYTHON系列第一篇---Pandas(2)to_excel详解-xlsxwriter及openpylx]]></title><link>https://blog.youkuaiyun.com/m0_73209313/article/details/127356551</link><guid>https://blog.youkuaiyun.com/m0_73209313/article/details/127356551</guid><author>m0_73209313</author><pubDate>Mon, 17 Oct 2022 08:26:59 +0800</pubDate><description><![CDATA[python pandas xlwings xlsxwriter]]></description><category></category></item><item><title><![CDATA[EXCEL与PYTHON系列第一篇---Pandas(1)read_excel详解]]></title><link>https://blog.youkuaiyun.com/m0_73209313/article/details/127313149</link><guid>https://blog.youkuaiyun.com/m0_73209313/article/details/127313149</guid><author>m0_73209313</author><pubDate>Fri, 14 Oct 2022 08:43:19 +0800</pubDate><description><![CDATA[python pandas与excel的搭配使用，read_excel详解]]></description><category></category></item><item><title><![CDATA[详解Excel中最常用的查找公式Vlookup及Sumifs]]></title><link>https://blog.youkuaiyun.com/m0_73209313/article/details/127301963</link><guid>https://blog.youkuaiyun.com/m0_73209313/article/details/127301963</guid><author>m0_73209313</author><pubDate>Thu, 13 Oct 2022 15:15:28 +0800</pubDate><description><![CDATA[详解excel数据查找分析定位中最常用的两个函数，vlookup以及sumifs]]></description><category></category></item><item><title><![CDATA[在Excel VBA中使用字典]]></title><link>https://blog.youkuaiyun.com/m0_73209313/article/details/127301177</link><guid>https://blog.youkuaiyun.com/m0_73209313/article/details/127301177</guid><author>m0_73209313</author><pubDate>Thu, 13 Oct 2022 14:44:56 +0800</pubDate><description><![CDATA[在EXCEL VBA中调用字典，提取唯一值]]></description><category></category></item></channel></rss>