Ok, so I'm trying to set the value of a cell with the excel interop library. I am able to do it with the following:
sheet.Cells[row, col] = value;
but it's terribly slow for how many I'm setting. So I'm trying to go this route:
Range excelRange = sheet.UsedRange;
excelRange.Cells.set_Item(row, col, value);
The code executes, but no data is put in the cell. Any suggestions on what I'm missing? Thanks!
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…