为excel添加批注.txt

来自「C# 是创新性的新式编程语言」· 文本 代码 · 共 13 行

Application xlApp=new ApplicationClass();		
			Workbook xlBook=xlApp.Workbooks.Add(Missing.Value);
			Worksheet xlSheet=(Worksheet)xlBook.Sheets[1];
			xlApp.Cells[1,1]="名称";
			xlApp.Cells[1,2]="种类";			

			Range rng = xlApp.get_Range("B1", "B1");
			
			if (rng.Comment != null ) 
			{
				rng.Comment.Delete();
			}
			rng.AddComment("Comment added " + DateTime.Now);