int row_index = 2;
foreach (DataRow row in dataTableSourceSystem.Rows)
{
xlWorkSheet.get_Range("AM" + row_index.ToString(), System.Reflection.Missing.Value).Value2 = row["LookupShortName"].ToString();
row_index++;
}
Range range = xlWorkSheet.get_Range("G2,G50");
range.Validation.Add(XlDVType.xlValidateList, XlDVAlertStyle.xlValidAlertStop, XlFormatConditionOperator.xlBetween, "=$AM2:$AM50", System.Reflection.Missing.Value);
最后一行抛出了异常0x800A03EC
Am2
到Am50
有值。
请问有人可以帮忙吗?