.net读取Excel批注

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

原创最新推荐文章于 2023-05-11 16:16:52 发布 · 649 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#C#读取Excel批注

随笔专栏收录该内容

1 篇文章

订阅专栏

本文介绍了一种使用C#读取Excel文件中单元格批注的方法。通过Microsoft.Office.Interop.Excel命名空间提供的API，实现了打开指定路径的Excel文件、定位到特定工作表和单元格，并获取该单元格的批注内容。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

之前查过好多资料都没有找到合适的C#去读取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();
                }
            }