LinqToExcel：使用LINQ从电子表格和csv文件中检索数据-源码

[{"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}]