search

mini-software / MiniExcel

Fast, Low-Memory, Easy Excel .NET helper to import/export/template spreadsheet (support Linux, Mac)
https://www.nuget.org/packages/MiniExcel/
Apache License 2.0
2.66k stars 325 forks source link

M #634

Open xiaolipro opened 1 month ago

xiaolipro commented 1 month ago

Excel Type

MiniExcel Version

master分支最新代码

[Fact()]
public void QueryCastToIDictionary()
{
    var path = @"../../../../../samples/xlsx/TestCenterEmptyRow/TestCenterEmptyRow.xlsx";
    foreach (IDictionary<string, object> row in MiniExcel.QueryRange(path, endCell:"c3"))
    {
    }
}

期望

只读取左上角a1到右下角c3的矩阵数据 ![Uploading image.png…]()

实际

仍然无法控制住读取的范围，ABCD列全被读出来了 ![Uploading image.png…]()

xiaolipro commented 1 month ago

我尝试追踪了一下源码，col算出来是-1，没有起到限制作用