本文介绍OFFEBASE.dll类库，通过使用`ReadAsTable`方法将xlsx文件转换为DataTable，并演示如何通过ToSqlserver方法导入到Sqlserver数据库。可能需要VFPOLEDBSetup.msi安装。资源包括OFFEBASE.dll文件及相关源代码文件。
代码为dll类库，使用方法：引入命名空间：using OFFEBASE;调用方法DataTable Mtable = EXCellToDatabase.ReadAsTable(xlsx文件路径,表的sheet名);然后 Mtable.ToSqlserver(SqlConnection)就可以了，目前只写了Sqlserver，其他数据库操作一样(备注：有可能需要安装VFPOLEDBSetup.msi，为了方便大家，我已经打包了)
资源下载此资源下载价格为3D币，请先登录
资源文件列表
OFFEBASE/OFFEBASE/bin/Debug/OFFEBASE.dll , 7168
OFFEBASE/OFFEBASE/bin/Debug/OFFEBASE.pdb , 13824
OFFEBASE/OFFEBASE/Class1.cs , 4623
OFFEBASE/OFFEBASE/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache , 6521
OFFEBASE/OFFEBASE/obj/Debug/OFFEBASE.csproj.FileListAbsolute.txt , 292
OFFEBASE/OFFEBASE/obj/Debug/OFFEBASE.dll , 7168
OFFEBASE/OFFEBASE/obj/Debug/OFFEBASE.pdb , 13824
OFFEBASE/OFFEBASE/obj/Debug/TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs , 0
OFFEBASE/OFFEBASE/obj/Debug/TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs , 0
OFFEBASE/OFFEBASE/obj/Debug/TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs , 0
OFFEBASE/OFFEBASE/OFFEBASE.csproj , 2404
OFFEBASE/OFFEBASE/Properties/AssemblyInfo.cs , 1336
OFFEBASE/OFFEBASE.sln , 914
OFFEBASE/OFFEBASE.v11.suo , 36352
OFFEBASE/VFPOLEDBSetup.msi , 1292288
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
