将Excel数据上传到SQL Server [英] Upload Excel Data to SQL Server

问题描述

大家好，

我要求使用带有c#的asp.net将Excel数据上传到32位和64位计算机环境中的SQL Server表.在生产服务器中，我们需要安装MS Office才能执行这些操作.请充分满足需求.预先感谢....

问候，
Jeevan.

Hi All,

I have a requirement to upload excel data to SQL Server table in 32bit and 64bit machines environment using asp.net with c#. In the production server we need to install MS Office to perform those operations. Please do the need full. Thanks in an advance....

Regards,
Jeevan.

推荐答案

我会检查ExcelWriter.您不需要打开excel的窗口.可能也可以使用Microsoft.Office.Interop.Excel.

I would check ExcelWriter. You do not need to have a window to open excel. It may also be possible to use Microsoft.Office.Interop.Excel.

这篇关于将Excel数据上传到SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！