ExcelImport: Only first [ColumnIndex] is valid.

[Nongzhsh]

Package: Magicodes.IE.Excel 2.5.4.3

I'm trying to debug ImportTestColumnIndex_Test

Magicodes.IE/src/Magicodes.ExporterAndImporter.Tests/ExcelImporter_Tests.cs

Line 876 in 149443d

[Fact(DisplayName = "ColumnIndex测试")]

I have modified some code.
DTO like:

public class ImportTestColumnIndex
{
    [ImporterHeader(ColumnIndex = 1)]
    public string Name { get; set; }

    [ImporterHeader(Name = "年龄", ColumnIndex = 3)]
    public int? Age { get; set; }
}

Unit test code like:

[Fact(DisplayName = "ColumnIndex测试")]
public async Task ImportTestColumnIndex_Test()
{
    var filePath = Path.Combine(Directory.GetCurrentDirectory(), "TestFiles", "Import", "ColumnIndex导入测试.xlsx");
    var import = await Importer.Import<ImportTestColumnIndex>(filePath);
    import.HasError.ShouldBeFalse();
    import.TemplateErrors.Count.ShouldBe(0);
    import.ImporterHeaderInfos.Count.ShouldBe(2);
    import.Data.ElementAt(0).Age.ShouldBe(11);
}

Excel data:

----- Test Execution Summary -----
Magicodes.ExporterAndImporter.Tests.ExcelImporter_Tests.ImportTestColumnIndex_Test:
Outcome: Failed
Error Message:
Shouldly.ShouldAssertException : import.Data.ElementAt(0).Age
should be
11
but was
null
Stack Trace:
at Magicodes.ExporterAndImporter.Tests.ExcelImporter_Tests.ImportTestColumnIndex_Test() in d:\Github\Magicodes.IE\src\Magicodes.ExporterAndImporter.Tests\ExcelImporter_Tests.cs:line 884
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.GetResult()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.GetResult()
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.GetResult()

Total tests: 1. Passed: 0. Failed: 1. Skipped: 0

All Age column data is null! [裂开]

[Nongzhsh]

Oh,there is a bug when judging isColumnExist ,should be continue.

Magicodes.IE/src/Magicodes.ExporterAndImporter.Excel/Utility/ImportHelper.cs

Line 597 in 149443d

break;