How will you Import a .xlsx file to a sql database on a server that does not have Office installed on?
如何将.xlsx文件导入到未安装Office的服务器上的sql数据库？
Since you can't use Microsoft.Office.Interop.Excel
由于您无法使用Microsoft.Office.Interop.Excel
3 个解决方案
#1
1
There's a bunch of free native/XLSX file readers that are out there. Try taking a look at this one:
有很多免费的本机/ XLSX文件阅读器。试着看看这个：
http://koogra.sourceforge.net/
http://koogra.sourceforge.net/
If your workbook is fairly straightforward, this is probably all you will need.
如果您的工作簿非常简单，那么这可能就是您所需要的。
#2
0
If you've a little money to spend I cannot recommend this highly enough: http://www.gemboxsoftware.com/
如果你有一点钱可以用，我不能高度推荐这个：http：//www.gemboxsoftware.com/
#3
0
Are you stuck with native XLSX? Or are you open to Excel XML?
您是否坚持使用原生XLSX？或者您是否对Excel XML开放？
You know where I'm going with this...Excel XML is XML, and is "native" when opened in Excel (features intact).
你知道我要去哪里... Excel XML是XML，在Excel中打开时是“原生的”（功能完整）。
#1
1
There's a bunch of free native/XLSX file readers that are out there. Try taking a look at this one:
有很多免费的本机/ XLSX文件阅读器。试着看看这个：
http://koogra.sourceforge.net/
http://koogra.sourceforge.net/
If your workbook is fairly straightforward, this is probably all you will need.
如果您的工作簿非常简单，那么这可能就是您所需要的。
#2
0
If you've a little money to spend I cannot recommend this highly enough: http://www.gemboxsoftware.com/
如果你有一点钱可以用，我不能高度推荐这个：http：//www.gemboxsoftware.com/
#3
0
Are you stuck with native XLSX? Or are you open to Excel XML?
您是否坚持使用原生XLSX？或者您是否对Excel XML开放？
You know where I'm going with this...Excel XML is XML, and is "native" when opened in Excel (features intact).
你知道我要去哪里... Excel XML是XML，在Excel中打开时是“原生的”（功能完整）。