MiniExcel icon indicating copy to clipboard operation
MiniExcel copied to clipboard

Support join query in multiple Workbooks or Worksheets

Open tsiank opened this issue 3 years ago • 0 comments

Now if I query worksheet1 and worksheet2, my code is like:

var sheet1Result = MiniExcel.Query<Sheet1>(worksheet1); var sheet2Result = MiniExcel.Query<Sheet2>(worksheet2);

var joinResult = from sheet1 in sheet1Result join sheet2 in sheet2Result on sheet1.ID equals sheet2.ID select new {sheet1.Name, sheet1.Sex, sheet2.Birth, sheet2.Address};

Is there any possible to support join query in MiniExcel cleaner?

tsiank avatar Jan 12 '22 02:01 tsiank