真心求教Excel高手(一个星期没解决的问题)
private void isHaveA2Comment()
{
string file = templateTree.SelectedNode.Tag.ToString();//得到路径
Excel.Range rngA2;
workbook = ExcelEngine.Current.GetWorkbook(file);//得到workBook
Worksheet worksheet = (Excel.Worksheet)workbook.Worksheets[1];
rngA2 = worksheet.get_Range("A2", Missing.Value);
if (rngA2.Comment == null)//如果sheet1的rngA2为空,则给每个sheet的A2加上批注
{
for (int i = 1; i < workbook.Worksheets.Count + 1; i++)
{
worksheet = (Worksheet)workbook.Sheets[i];
string worksheetName = worksheet.Name.ToString();
rngA2 = worksheet.get_Range("A2", Missing.Value);
if (...)
{
rngA2.AddComment("1,unitId");
}
else if (...)
{
rngA2.AddComment("2,rows");
}
else if (...)
{
rngA2.AddComment("3,rows");
}
else
{
rngA2.AddComment("0,");
}
}
workbook.Close(true, Missing.Value, Missing.Value);
//workbook.Save();
}
}