MiniExcel
MiniExcel copied to clipboard
Support join query in multiple Workbooks or Worksheets
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?