Я использую Ironxl для импорта данных Excel в словарь C#, но не могу запустить скрипт:
public Dictionary ReadInputData_3()
{
// Check if the file exists
Dictionary dataDictionary = new Dictionary();
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;
}
Подробнее здесь: https://stackoverflow.com/questions/786 ... ing-ironxl
