.net读取Excel批注

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

xuzifeng1990

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

阅读量579

点赞数 1

分类专栏：随笔文章标签： C#读取Excel批注

本文链接：https://blog.csdn.net/xuzifeng1990/article/details/40746945

版权

随笔专栏收录该内容

1 篇文章 0 订阅

订阅专栏

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