嘿伙計們，我的問題是當我讀取單元格并且在單元格中什么都沒有時我有錯誤我該如何檢查？
var aExcel = sh.Cells[26, 2].Value.ToString();
double test = Convert.ToDouble(aExcel);
還有一個問題，我怎樣才能讀取更多的單元格？因為我的代碼太長了...
var aExcel = sh.Cells[26, 2].Value.ToString();
var bExcel = sh.Cells[27, 2].Value.ToString();
var cExcel = sh.Cells[28, 2].Value.ToString();
var dExcel = sh.Cells[29, 2].Value.ToString();
var eExcel = sh.Cells[30, 2].Value.ToString();
var fExcel = sh.Cells[31, 2].Value.ToString();
double test1 = Convert.ToDouble(aExcel);
double test2 = Convert.ToDouble(bExcel);
double test3 = Convert.ToDouble(cExcel);
double test4 = Convert.ToDouble(dExcel);
double test5 = Convert.ToDouble(aExcel);
uj5u.com熱心網友回復：
對于您的第二個問題，這里是示例代碼：
List<Double> datas = new List<Double>();
int excelStartRow = 26;
int excelEndRow = 21;
for (int i = excelStartRow; i <= excelEndRow; i )
{
var aExcel = sh.Cells[i, 2];
if (aExcel != null)
{
double value = Convert.ToDouble(aExcel.Value.ToString());
datas.Add(value);
}
}
uj5u.com熱心網友回復：
你可以這樣檢查：
if(sh.Cells[26, 2] != null)
{
//do something
}
代碼：
double test;
var aExcel = sh.Cells[26, 2];
if(aExcel != null){
test = Convert.ToDouble(aExcel.Value.ToString());
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/367242.html