Arling_的博客

C# 读取MS数据库并写入到Excel(调用NOPI方式实现)注:NPOI可以在没有安装Office及WPS的情况下对Word或Excel文档进行读写操作NOPI组件需自行下载using System.Data.SqlClient;using System.Windows.Forms;using System.IO;using NPOI.HSSF.UserModel;using NPOI.SS.UserModel;using NPOI.XSSF.UserModel; DataTab

添加一个按钮和CommonDialog控件 如下图工程引用如下图源代码:Private Sub Command1_Click() Dim sourceFilePath As String Me.CommonDialog1.Filter = "Excel (*.xls;*.xlsx)|*.xls;*.xlsx|" '过滤文件 Me.CommonDialog1.FilterIndex = 2 Me.CommonDialog1.ShowOpen