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}]
评论信息
其他资源
- 16PSK调制解调过程MATLAB
- ADS1220驱动代码
- mnist_uint8.mat下载
- Android日志分析工具-V3.6.4
- 华为OLT网管系统2.10.2.rar
- java 将amr转换为MP3文件
- 数理逻辑与集合论第二版·
- Netty一个端口支持tcp和websocket
- JAVA经典坦克大战 源码 下载
- Apache Ambari 2.7.4源码编译安装参考-CentOS7.pdf
- Java面试考核目标.docx
- 一个简单的登录页面.zip
- 51单片机 RTL8019AS 网卡驱动程序(有程序)
- C++&Win32编写记事本程序
- MVC酒店管理系统
- 近似熵算法
- JAVA+SQL酒店管理系统
- 公路测量放样程序(简单、方便)
- STM32F1开发指南-库函数版本_V3.2
- 仿破碎银河系单机版
- 支持所有中文的adb.exe文件
- 学习cocos2d-x 3.0自己写的游戏2048
- 最小外接矩形
免责申明
【只为小站】的资源来自网友分享，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论 【只为小站】 经营者是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二条之规定，若资源存在侵权或相关问题请联系本站客服人员，zhiweidada#qq.com，请把#换成@，本站将给予最大的支持与配合，做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明
本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二条之规定，若资源存在侵权或相关问题请联系本站客服人员，zhiweidada#qq.com，请把#换成@，本站将给予最大的支持与配合，做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明