LinqToExcel：使用LINQ从电子表格和csv文件中检索数据-源码
欢迎来到LinqToExcel项目
Linq to Excel是一个.Net库，您可以使用LINQ语法查询Excel电子表格。
将LinqToExcel添加到您的项目
NuGet
您可以使用NuGet快速将LinqToExcel添加到您的项目中。 只需搜索linqtoexcel并安装该软件包。
访问数据库引擎
为了使用LinqToExcel，您需要安装Microsoft 。 如果尚未安装，则会出现以下异常：
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.'
提供32位和64位版本，请选择与您的项目设置匹配的版本。 您一次只能安装其中之一。
查询带有标题行的工作表
默认查询期望第一行是标题行，其中包含与正在使用的通用类的属性名称匹配的列名称。 它还希望数据位于名为“ Shee
文件下载
资源详情
[{"title":"（ 86 个子文件 134KB ） LinqToExcel：使用LINQ从电子表格和csv文件中检索数据-源码","children":[{"title":"LinqToExcel-master","children":[{"title":".gitignore <span style='color:#111;'> 157B </span>","children":null,"spread":false},{"title":"src","children":[{"title":"LinqToExcel.sln <span style='color:#111;'> 1.57KB </span>","children":null,"spread":false},{"title":"LinqToExcel.Tests","children":[{"title":"NoHeader_SQLStatements_UnitTests.cs <span style='color:#111;'> 2.00KB </span>","children":null,"spread":false},{"title":"UnSupportedMethods.cs <span style='color:#111;'> 7.00KB </span>","children":null,"spread":false},{"title":"NamedRange_SQLStatements_UnitTests.cs <span style='color:#111;'> 2.50KB </span>","children":null,"spread":false},{"title":"Range_SQLStatements_UnitTests.cs <span style='color:#111;'> 4.42KB </span>","children":null,"spread":false},{"title":"Row_IntegrationTests.cs <span style='color:#111;'> 1.76KB </span>","children":null,"spread":false},{"title":"WorkSheetNameTests.cs <span style='color:#111;'> 1.02KB </span>","children":null,"spread":false},{"title":"Convention_IntegrationTests.cs <span style='color:#111;'> 14.51KB </span>","children":null,"spread":false},{"title":"InvalidColumnNamesUsed.cs <span style='color:#111;'> 6.15KB </span>","children":null,"spread":false},{"title":"NamedRange_IntegrationTests.cs <span style='color:#111;'> 3.35KB </span>","children":null,"spread":false},{"title":"ColumnMappings_SQLStatements_UnitTests.cs <span style='color:#111;'> 5.58KB </span>","children":null,"spread":false},{"title":"ColumnMappings_IntegrationTests.cs <span style='color:#111;'> 6.20KB </span>","children":null,"spread":false},{"title":"ExcelQueryFactoryTests.cs <span style='color:#111;'> 17.77KB </span>","children":null,"spread":false},{"title":"SkipEmptyRows_UnitTests.cs <span style='color:#111;'> 2.48KB </span>","children":null,"spread":false},{"title":"Convention_SQLStatements_UnitTests.cs <span style='color:#111;'> 17.73KB </span>","children":null,"spread":false},{"title":"CSV_SQLStatements_UnitTests.cs <span style='color:#111;'> 2.35KB </span>","children":null,"spread":false},{"title":"RowTest.cs <span style='color:#111;'> 1.68KB </span>","children":null,"spread":false},{"title":"CompanyNameWithUnmappedCells.cs <span style='color:#111;'> 344B </span>","children":null,"spread":false},{"title":"ExcelFiles","children":[{"title":"NoHeader.csv <span style='color:#111;'> 292B </span>","children":null,"spread":false},{"title":"Companies.xls <span style='color:#111;'> 32.00KB </span>","children":null,"spread":false},{"title":"EmptyRows.xls <span style='color:#111;'> 7.00KB </span>","children":null,"spread":false},{"title":"Companies.xlsb <span style='color:#111;'> 10.04KB </span>","children":null,"spread":false},{"title":"WorksheetNames.xlsx <span style='color:#111;'> 10.58KB </span>","children":null,"spread":false},{"title":"Companies.xlsx <span style='color:#111;'> 15.35KB </span>","children":null,"spread":false},{"title":"NamedRanges.xlsx <span style='color:#111;'> 13.70KB </span>","children":null,"spread":false},{"title":"Companies.xlsm <span style='color:#111;'> 9.77KB </span>","children":null,"spread":false},{"title":"NoHeader.xls <span style='color:#111;'> 17.50KB </span>","children":null,"spread":false},{"title":"Companies.csv <span style='color:#111;'> 315B </span>","children":null,"spread":false}],"spread":false},{"title":"ConfiguredWorksheetName_IntegrationTests.cs <span style='color:#111;'> 1.80KB </span>","children":null,"spread":false},{"title":"CompanyBadWithAllowFieldTypeConversionExceptions.cs <span style='color:#111;'> 885B </span>","children":null,"spread":false},{"title":"LinqToExcel.Tests.csproj <span style='color:#111;'> 2.26KB </span>","children":null,"spread":false},{"title":"CellTest.cs <span style='color:#111;'> 1.67KB </span>","children":null,"spread":false},{"title":"App.config <span style='color:#111;'> 763B </span>","children":null,"spread":false},{"title":"Transformations.cs <span style='color:#111;'> 207B </span>","children":null,"spread":false},{"title":"NoHeader_IntregrationTests.cs <span style='color:#111;'> 5.59KB </span>","children":null,"spread":false},{"title":"Row_SQLStatement_UnitTests.cs <span style='color:#111;'> 4.17KB </span>","children":null,"spread":false},{"title":"Range_IntegrationTests.cs <span style='color:#111;'> 2.76KB </span>","children":null,"spread":false},{"title":"PersistentConnection_IntegrationTests.cs <span style='color:#111;'> 1.41KB </span>","children":null,"spread":false},{"title":"Excel2007_IntegrationTests.cs <span style='color:#111;'> 2.58KB </span>","children":null,"spread":false},{"title":"ConnectionString_UnitTests.cs <span style='color:#111;'> 16.32KB </span>","children":null,"spread":false},{"title":"IndexToColumnNamesTests.cs <span style='color:#111;'> 2.39KB </span>","children":null,"spread":false},{"title":"CompanyWithColumnAnnotations.cs <span style='color:#111;'> 555B </span>","children":null,"spread":false},{"title":"CompanyGoodWithAllowFieldTypeConversionExceptions.cs <span style='color:#111;'> 588B </span>","children":null,"spread":false},{"title":"LogManagerFactory.cs <span style='color:#111;'> 1.33KB </span>","children":null,"spread":false},{"title":"IMEX_Tests.cs <span style='color:#111;'> 989B </span>","children":null,"spread":false},{"title":"SQLLogStatements_Helper.cs <span style='color:#111;'> 3.79KB </span>","children":null,"spread":false},{"title":"Company.cs <span style='color:#111;'> 307B </span>","children":null,"spread":false},{"title":"ConfiguredWorksheetName_SQLStatements_UnitTests.cs <span style='color:#111;'> 991B </span>","children":null,"spread":false},{"title":"CompanyNullable.cs <span style='color:#111;'> 273B </span>","children":null,"spread":false},{"title":"CSV_IntegrationTests.cs <span style='color:#111;'> 1.93KB </span>","children":null,"spread":false},{"title":"CompanyWithCity.cs <span style='color:#111;'> 125B </span>","children":null,"spread":false},{"title":"InvalidCastTests.cs <span style='color:#111;'> 1.20KB </span>","children":null,"spread":false}],"spread":false},{"title":"LinqToExcel","children":[{"title":"IExcelQueryFactory.cs <span style='color:#111;'> 14.37KB </span>","children":null,"spread":false},{"title":"Exceptions","children":[{"title":"ExcelException.cs <span style='color:#111;'> 1.61KB </span>","children":null,"spread":false}],"spread":true},{"title":"Attributes","children":[{"title":"ExcelColumnAttribute.cs <span style='color:#111;'> 467B </span>","children":null,"spread":false}],"spread":true},{"title":"ExcelQueryFactory.cs <span style='color:#111;'> 36.84KB </span>","children":null,"spread":false},{"title":"Extensions","children":[{"title":"CommonExtensions.cs <span style='color:#111;'> 3.21KB </span>","children":null,"spread":false}],"spread":true},{"title":"Logging","children":[{"title":"ILogManagerFactory.cs <span style='color:#111;'> 248B </span>","children":null,"spread":false},{"title":"ILogProvider.cs <span style='color:#111;'> 410B </span>","children":null,"spread":false}],"spread":true},{"title":"Domain","children":[{"title":"IContainsUnmappedCells.cs <span style='color:#111;'> 278B </span>","children":null,"spread":false},{"title":"Cell.cs <span style='color:#111;'> 1.17KB </span>","children":null,"spread":false},{"title":"Row.cs <span style='color:#111;'> 1.42KB </span>","children":null,"spread":false},{"title":"StrictMappingException.cs <span style='color:#111;'> 431B </span>","children":null,"spread":false},{"title":"RowNoHeader.cs <span style='color:#111;'> 347B </span>","children":null,"spread":false},{"title":"IAllowFieldTypeConversionExceptions.cs <span style='color:#111;'> 537B </span>","children":null,"spread":false}],"spread":true},{"title":"License.txt <span style='color:#111;'> 1.03KB </span>","children":null,"spread":false},{"title":"Query","children":[{"title":"OleDbServices.cs <span style='color:#111;'> 2.28KB </span>","children":null,"spread":false},{"title":"ExcelQueryable.cs <span style='color:#111;'> 1.41KB </span>","children":null,"spread":false},{"title":"StrictMappingType.cs <span style='color:#111;'> 843B </span>","children":null,"spread":false},{"title":"ProjectorBuildingExpressionTreeVisitor.cs <span style='color:#111;'> 2.55KB </span>","children":null,"spread":false},{"title":"ExcelQueryExecutor.cs <span style='color:#111;'> 20.65KB </span>","children":null,"spread":false},{"title":"ResultObjectMapping.cs <span style='color:#111;'> 862B </span>","children":null,"spread":false},{"title":"ExcelQueryConstructorArgs.cs <span style='color:#111;'> 988B </span>","children":null,"spread":false},{"title":"SqlParts.cs <span style='color:#111;'> 1.39KB </span>","children":null,"spread":false},{"title":"ExcelQueryArgs.cs <span style='color:#111;'> 3.94KB </span>","children":null,"spread":false},{"title":"SqlGeneratorQueryModelVisitor.cs <span style='color:#111;'> 8.42KB </span>","children":null,"spread":false},{"title":"TrimSpacesType.cs <span style='color:#111;'> 651B </span>","children":null,"spread":false},{"title":"WhereClauseExpressionTreeVisitor.cs <span style='color:#111;'> 11.12KB </span>","children":null,"spread":false},{"title":"ExcelUtilities.cs <span style='color:#111;'> 10.08KB </span>","children":null,"spread":false}],"spread":false},{"title":"LinqToExcel.snk <span style='color:#111;'> 596B </span>","children":null,"spread":false},{"title":"LinqToExcel.csproj <span style='color:#111;'> 1.99KB </span>","children":null,"spread":false}],"spread":false}],"spread":true},{"title":"CHANGELOG.md <span style='color:#111;'> 1.84KB </span>","children":null,"spread":false},{"title":"README.md <span style='color:#111;'> 13.65KB </span>","children":null,"spread":false},{"title":"License.txt <span style='color:#111;'> 1.03KB </span>","children":null,"spread":false},{"title":".gitattributes <span style='color:#111;'> 44B </span>","children":null,"spread":false}],"spread":true}],"spread":true}]
评论信息
其他资源
- xilinx ise 14.7 破解license
- mipi_M-PHY_specification_v2-0
- 语音信号的采集和处理 matlab
- C#使用serialPort实时显示收到的数据
- GPS软件接收机
- CvvImage.h和CvvImage.cpp
- SAP Dialog 學習
- 高等代数 北大第3版 高清
- 第一行代码（word版）—Android(全书)
- Fundamentals of Photonics B.Saleh
- 完整版 Photoshop教程(完整版).ppt
- javaweb：javaweb应用商城-源码
- 宠物商店（SSH实现）
- ANSYS接触分析(针对初学者和中级分析人员)
- 针对非线性卡尔曼滤波算法发散的抑制方法研究
- docker练习镜像
- README.md
- BHEPL直方图均衡化算法
- 冒险岛V079物品ID.txt
- C++项目实践
- 锐捷客户端4.85破解文件
- 物流系统（毕业设计）
- 帆软校招笔试拍照 与 机试(两份)
- AD-DC矩阵变换器及其应用研究
免责申明
【只为小站】的资源来自网友分享，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论 【只为小站】 经营者是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二条之规定，若资源存在侵权或相关问题请联系本站客服人员，zhiweidada#qq.com，请把#换成@，本站将给予最大的支持与配合，做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明
本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二条之规定，若资源存在侵权或相关问题请联系本站客服人员，zhiweidada#qq.com，请把#换成@，本站将给予最大的支持与配合，做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明