Settings and activity
3 results found
-
1,272 votes
An error occurred while saving the comment -
3 votes
An error occurred while saving the comment Hm Mak commented
Sample code i use:
FileInfo fi = new FileInfo(@"D:\OneDrive\data.xlsx");
using (ExcelPackage excelPackage = new ExcelPackage(fi))
{
ExcelWorksheet data = excelPackage.Workbook.Worksheets[0];var start = data.Dimension.Start;
var end = data.Dimension.End;
for (int row = start.Row + 1; row <= end.Row; row++)
{
var username = data.Cells[row, 2].Text.Trim();
var password = data.Cells[row, 3].Text.Trim();
// do something
} -
3 votes
In my opinion, this is a bit of an unrealistic ask. If TSQL could have that feature, microsoft would have done it already, and they wouldn't have invent Linq queries.
This is because when you need to re-engineer or write a subset of the Tsql language. That is what the linq queries are designed to overcome the shortcomings of TSQL structure queries.