C# 插入excel 单元格数据、写入Excel数据

         /// <summary>
        /// 插入数据
        /// </summary>
        /// <param name="rowIndex">行号</param>
        /// <param name="columnIndex">列号</param>
        /// <param name="content">内容</param>
        /// <param name="comment">批注</param>
        public static void InsertCell(int rowIndex, int columnIndex, string content, string comment)
        {

            Microsoft.Office.Interop.Excel.ApplicationClass excel = wbb.Application as Microsoft.Office.Interop.Excel.ApplicationClass;

            Microsoft.Office.Interop.Excel.Workbook wb = excel.Workbooks[1];

            int a = wb.Application.ActiveCell.Row;

            Microsoft.Office.Interop.Excel.Worksheet ws = wb.Worksheets[1] as Microsoft.Office.Interop.Excel.Worksheet;

            range = ws.Cells;

            Microsoft.Office.Interop.Excel.Range oCell = range[rowIndex, columnIndex] as Microsoft.Office.Interop.Excel.Range;         

            oCell.Value2 = content;
        }

posted @ 2009-09-21 13:55  汉城  阅读(1005)  评论(0编辑  收藏  举报