C#读取Excel批注

最新推荐文章于 2023-05-11 16:16:52 发布

weixin_30888413

最新推荐文章于 2023-05-11 16:16:52 发布

阅读量380

点赞数 1

CC 4.0 BY-SA版权

文章标签： c# runtime

原文链接：http://www.cnblogs.com/xushuaihao/p/4074607.html

本文提供了一个使用Microsoft Office Interop Excel库的C#示例代码，演示了如何打开一个Excel文件，读取指定工作表中单元格的注释文本，并关闭工作簿。该代码还包含了清理COM对象并确保没有遗留Excel进程的部分。

Microsoft.Office.Interop.Excel.Application myobject = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel._Workbook m_objBook = myobject.Workbooks.Open(@"H:\\aa.xlsx", m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt);
m_objsheets = m_objBook.Worksheets;
m_objSheet = (_Worksheet)m_objsheets.get_Item("Sheet1");
string pos = "A1";
m_objRange = m_objSheet.get_Range(pos, m_objOpt);
string s = m_objRange.Comment.Shape.AlternativeText;
m_objBook.Close(m_objOpt, m_objOpt, m_objOpt);
myobject.Workbooks.Close();
myobject.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objBook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(myobject);
m_objBook = null;
myobject = null;
GC.Collect();
foreach (System.Diagnostics.Process p in System.Diagnostics.Process.GetProcesses())
{
if (p.ProcessName.ToUpper() == "EXCEL")
{
p.Kill();
}
}