LinqToExcel：使用LINQ从电子表格和CSV文件中检索数据

【实例简介】

Linq to Excel是一个.Net库，允许您使用LINQ语法查询Excel电子表格。查看介绍视频。

使用标题行查询工作表
默认查询期望第一行是包含与正在使用的通用类的属性名称匹配的列名称的标题行。它还期望数据在名为“Sheet1”的工作表中。

【实例截图】
【核心代码】
文件清单
└── LinqToExcel-8759172638ce31c6a98eaf516427069379683947
    ├── CHANGELOG.md
    ├── License.txt
    ├── README.md
    └── src
        ├── LinqToExcel
        │   ├── Attributes
        │   │   └── ExcelColumnAttribute.cs
        │   ├── Domain
        │   │   ├── Cell.cs
        │   │   ├── IAllowFieldTypeConversionExceptions.cs
        │   │   ├── IContainsUnmappedCells.cs
        │   │   ├── Row.cs
        │   │   ├── RowNoHeader.cs
        │   │   └── StrictMappingException.cs
        │   ├── ExcelQueryFactory.cs
        │   ├── Exceptions
        │   │   └── ExcelException.cs
        │   ├── Extensions
        │   │   └── CommonExtensions.cs
        │   ├── IExcelQueryFactory.cs
        │   ├── License.txt
        │   ├── LinqToExcel.csproj
        │   ├── LinqToExcel.snk
        │   ├── Logging
        │   │   ├── ILogManagerFactory.cs
        │   │   └── ILogProvider.cs
        │   └── Query
        │       ├── ExcelQueryable.cs
        │       ├── ExcelQueryArgs.cs
        │       ├── ExcelQueryConstructorArgs.cs
        │       ├── ExcelQueryExecutor.cs
        │       ├── ExcelUtilities.cs
        │       ├── OleDbServices.cs
        │       ├── ProjectorBuildingExpressionTreeVisitor.cs
        │       ├── ResultObjectMapping.cs
        │       ├── SqlGeneratorQueryModelVisitor.cs
        │       ├── SqlParts.cs
        │       ├── StrictMappingType.cs
        │       ├── TrimSpacesType.cs
        │       └── WhereClauseExpressionTreeVisitor.cs
        ├── LinqToExcel.sln
        └── LinqToExcel.Tests
            ├── App.config
            ├── CellTest.cs
            ├── ColumnMappings_IntegrationTests.cs
            ├── ColumnMappings_SQLStatements_UnitTests.cs
            ├── CompanyBadWithAllowFieldTypeConversionExceptions.cs
            ├── Company.cs
            ├── CompanyGoodWithAllowFieldTypeConversionExceptions.cs
            ├── CompanyNameWithUnmappedCells.cs
            ├── CompanyNullable.cs
            ├── CompanyWithCity.cs
            ├── CompanyWithColumnAnnotations.cs
            ├── ConfiguredWorksheetName_IntegrationTests.cs
            ├── ConfiguredWorksheetName_SQLStatements_UnitTests.cs
            ├── ConnectionString_UnitTests.cs
            ├── Convention_IntegrationTests.cs
            ├── Convention_SQLStatements_UnitTests.cs
            ├── CSV_IntegrationTests.cs
            ├── CSV_SQLStatements_UnitTests.cs
            ├── Excel2007_IntegrationTests.cs
            ├── ExcelFiles
            │   ├── Companies.csv
            │   ├── Companies.xls
            │   ├── Companies.xlsb
            │   ├── Companies.xlsm
            │   ├── Companies.xlsx
            │   ├── EmptyRows.xls
            │   ├── NamedRanges.xlsx
            │   ├── NoHeader.csv
            │   ├── NoHeader.xls
            │   └── WorksheetNames.xlsx
            ├── ExcelQueryFactoryTests.cs
            ├── IMEX_Tests.cs
            ├── IndexToColumnNamesTests.cs
            ├── InvalidCastTests.cs
            ├── InvalidColumnNamesUsed.cs
            ├── LinqToExcel.Tests.csproj
            ├── LogManagerFactory.cs
            ├── NamedRange_IntegrationTests.cs
            ├── NamedRange_SQLStatements_UnitTests.cs
            ├── NoHeader_IntregrationTests.cs
            ├── NoHeader_SQLStatements_UnitTests.cs
            ├── PersistentConnection_IntegrationTests.cs
            ├── Range_IntegrationTests.cs
            ├── Range_SQLStatements_UnitTests.cs
            ├── Row_IntegrationTests.cs
            ├── Row_SQLStatement_UnitTests.cs
            ├── RowTest.cs
            ├── SkipEmptyRows_UnitTests.cs
            ├── SQLLogStatements_Helper.cs
            ├── Transformations.cs
            ├── UnSupportedMethods.cs
            └── WorkSheetNameTests.cs

11 directories, 84 files