i am using ironxl to import excel data into C# dictionary and i am unable to run the script
public Dictionary<string, int> ReadInputData_3()
{
// Check if the file exists
Dictionary<string, int> dataDictionary = new Dictionary<string, int>();
WorkBook workBook = WorkBook.Load("..\..\..\ModbusTestJig.Helpers\Input_data\Input_data.xlsx");
//WorkSheet workSheet = workBook.WorkSheets.First();
WorkSheet workSheet = workBook.WorkSheets[0];
foreach (var row in workSheet.Rows)
{
var key = row.Columns[0].Value.ToString(); // Assuming key is in the first column (column index 0)
var value = row.Columns[1].Value.ToString(); // Assuming value is in the second column (column index 1)
if (!string.IsNullOrEmpty(key))
{
dataDictionary.Add(key,int.Parse(value));
//dataDictionary[key] = value;
}
}
return dataDictionary;
}
New contributor
coderatnam is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.