无论如何导入excel数据并检测删除线（不是使用互操作 [英] Is there anyway to import excel data and detect strikethrough (not with interop

问题描述

无论如何都要用strinkthrough单词导入和检测数据？



i谷歌搜索了几个小时，发现OLEDB无法检测到，因为它像一个整体查询



datatable和Interop很慢有没有其他方法可以做到这一点？请建议



感谢

is there anyway to import and detect data with strinkthrough word?

i was googling for several hour and found that the OLEDB cannot detect that because it query out like a whole

datatable and with Interop is slow is there any another way to do that ? Please suggest

Thank

推荐答案

当然。更好的选择可能是根本不使用Excel。相反，您可以使用Microsoft Open XML SDK。请查看我过去的答案：

Microsot office Interop [ ^ ]，

如何从MS Visual Studio 2010中的添加引用添加microsoft excel 15.0对象库 [ ^ ]。



另请参阅此CodeProject文章：使用Open XML创建基本Excel工作簿 [ ^ ]。



请注意，Microsoft警告不要在某些情况下使用Office互操作，例如服务器端Web开发：

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

http://support.microsoft。 com / kb / 257757 / zh-CN [ ^ ]。

-SA

Sure. The better alternative could be not using Excel at all. Instead, you can use Microsoft Open XML SDK. Please see my past answers:
Microsot office Interop[^],
How to add microsoft excel 15.0 object library from Add Reference in MS Visual Studio 2010[^].

See also this CodeProject article: Creating basic Excel workbook with Open XML[^].

Note that Microsoft warned against using Office interop in certain situations, such as server-side Web development:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757#kb2[^],
http://support.microsoft.com/kb/257757/en-us[^].

—SA

这篇关于无论如何导入excel数据并检测删除线（不是使用互操作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！