Implement ISheet.Cells collection to return a cell range

[tonyqus]

In EPPlus, it implements a string indexer for cell range selection

worksheet.Cells["B1"].Value = "This is cell B1"; // Sets the value of Cell B1
worksheet.Cells[1, 2].Value = "This is cell B1"; // Also sets the value of Cell B1

worksheet.Cells["A1:B3,D1:E57"].Style.NumberFormat.Format = "#,##0"; //Sets the number format for a range containing two addresses.
worksheet.Cells["A:B"].Style.Font.Bold = true; //Sets font-bold to true for column A & B

Reference

https://github.com/EPPlusSoftware/EPPlus/wiki/Addressing-a-worksheet

[tonyqus]

#257

[tonyqus]

ClosedXML also has a similar feature
https://github.com/closedxml/closedxml/wiki/Selecting-Cells-and-Ranges