content_views"
class="htmledit_views">
今天在网上偶尔发现一个开源项目,Linq to class="tags" href="/tags/EXCEL.html" title=excel>excel,感觉挺有意思的c;不过这个可能要class="tags" href="/tags/.NET.html" title=.net>.net 3.0以上才可以用吧
代码类似以下的
class="prettyprint" style="font-size: 12px; padding-top: 0.5em; padding-right: 0.5em; padding-bottom: 0.5em; padding-left: 0.5em; overflow-x: auto; overflow-y: auto; font-family: Monaco, 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Lucida Console', monospace; max-width: 70em; background-color: rgb(238, 238, 238); ">class="kwd" style="color: rgb(0, 0, 136); ">varclass="pln" style="color: rgb(0, 0, 0); "> class="tags" href="/tags/EXCEL.html" title=excel>excel class="pun" style="color: rgb(102, 102, 0); ">=class="pln" style="color: rgb(0, 0, 0); "> class="kwd" style="color: rgb(0, 0, 136); ">newclass="pln" style="color: rgb(0, 0, 0); "> class="typ" style="color: rgb(102, 0, 102); ">ExcelQueryFactoryclass="pun" style="color: rgb(102, 102, 0); ">(class="str" style="color: rgb(0, 136, 0); ">"class="tags" href="/tags/EXCEL.html" title=excel>excelFileName"class="pun" style="color: rgb(102, 102, 0); ">);class="pln" style="color: rgb(0, 0, 0); ">
class="kwd" style="color: rgb(0, 0, 136); ">varclass="pln" style="color: rgb(0, 0, 0); "> indianaCompanies class="pun" style="color: rgb(102, 102, 0); ">=class="pln" style="color: rgb(0, 0, 0); "> class="kwd" style="color: rgb(0, 0, 136); ">fromclass="pln" style="color: rgb(0, 0, 0); "> c class="kwd" style="color: rgb(0, 0, 136); ">inclass="pln" style="color: rgb(0, 0, 0); "> class="tags" href="/tags/EXCEL.html" title=excel>excelclass="pun" style="color: rgb(102, 102, 0); ">.class="typ" style="color: rgb(102, 0, 102); ">Worksheetclass="pun" style="color: rgb(102, 102, 0); "><class="typ" style="color: rgb(102, 0, 102); ">Companyclass="pun" style="color: rgb(102, 102, 0); ">>()class="pln" style="color: rgb(0, 0, 0); ">
class="kwd" style="color: rgb(0, 0, 136); ">whereclass="pln" style="color: rgb(0, 0, 0); "> cclass="pun" style="color: rgb(102, 102, 0); ">.class="typ" style="color: rgb(102, 0, 102); ">Stateclass="pln" style="color: rgb(0, 0, 0); "> class="pun" style="color: rgb(102, 102, 0); ">==class="pln" style="color: rgb(0, 0, 0); "> class="str" style="color: rgb(0, 136, 0); ">"IN"class="pln" style="color: rgb(0, 0, 0); ">
class="kwd" style="color: rgb(0, 0, 136); ">selectclass="pln" style="color: rgb(0, 0, 0); "> cclass="pun" style="color: rgb(102, 102, 0); ">;
这样的Linq方式
c;相信在遍历值和查找方面会相当方便
下面是一则介绍文章
ca, Arial, 'LiHei Pro', �s�ө���, sans-serif; line-height: 18px; ">
color: initial; font-size: 16px; font: inherit; vertical-align: baseline; display: block; font-weight: bold; color: rgb(51, 51, 51); width: 658px; border-bottom-color: rgb(153, 153, 153); border-bottom-style: solid; line-height: 1.5em; ">讀取 Excel 你還在用 NPOI 嗎?快來試試 LinqToExcel
http://demo.t
c/Post/639
下面是项目的官方链接
http://code.google.com/p/class="tags" href="/tags/LINQ.html" title=linq>linqtoclass="tags" href="/tags/EXCEL.html" title=excel>excel/