[不是问题]上传excel并更新字段 [英] [Not a question] Upload an excel and update the fields

问题描述

需要一个解决方案：

需要上传一个excel和代码来解析excel并更新Web表单中的字段。

解决方案

您需要的是Open XML SDK：

http://www.microsoft.com/en-us/download/details.aspx?id=30425 [ ^ ]。



这样，你可以支持新的XML基于Office格式（如.DOCX，.XLSX），ECMA-376标准：

http：/ /en.wikipedia.org/wiki/Microsoft_Office_XML_formats [ ^ ]，

http://en.wikipedia.org/wiki/Office_Open_XML [< a href =http://en.wikipedia.org/wi ki / Office_Open_XMLtarget =_ blanktitle =New Window> ^ ]。



重要的是，它不需要安装MS Office。另请参阅Microsoft文章警告不要在服务器端环境中使用Office Interop：

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757#kb2 [ ^ ]，

http://support.microsoft.com/kb/257757/en-us [ ^ ]。

-SA

Need a solution:
Need to upload an excel and the code to parse the excel and update the fields in the web forms.

解决方案

What you need is the Open XML SDK:
http://www.microsoft.com/en-us/download/details.aspx?id=30425[^].

This way, you can support new XML-based Office formats (such as .DOCX, .XLSX), ECMA-376 standard:
http://en.wikipedia.org/wiki/Microsoft_Office_XML_formats[^],
http://en.wikipedia.org/wiki/Office_Open_XML[^].

Importantly, it does not require MS Office installation. See also Microsoft articles warning against using of Office Interop in server-side environment:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757#kb2[^],
http://support.microsoft.com/kb/257757/en-us[^].

—SA

这篇关于[不是问题]上传excel并更新字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！