C#对excel一些基本操作

最新推荐文章于 2018-03-16 18:59:23 发布

遠蜀黍

最新推荐文章于 2018-03-16 18:59:23 发布

阅读量649

点赞数

分类专栏： c#

本文链接：https://blog.csdn.net/rekrad/article/details/8454790

版权

c# 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

代码一般可以直接copy使用，也许会在工程里面未引用，未引用的要自己添加引用（office com接口引用方式：右键工程→addreference→com页→Microsoft Excel xx.0 Object Library）。以下代码仅仅打开，给某个单元格设置颜色，然后关闭。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using System.Data;
using Microsoft.Office.Interop;
using Microsoft.Office.Interop.Excel;

namespace TestCsConsole
{
    class Excel_Parser_Impl : IExcel_Parser
    {
        private Microsoft.Office.Interop.Excel.Application      app     = null;
        private Microsoft.Office.Interop.Excel.Workbook         wb      = null;
        private Microsoft.Office.Interop.Excel.Worksheet        ws      = null;
        private Microsoft.Office.Interop.Excel.Range            range   = null;
        private string                                          filePath;

        public  bool LoadFile(string FileName)
        {
            filePath = FileName;
            try
            {
                app = new Microsoft.Office.Interop.Excel.ApplicationClass();
                wb = app.Workbooks.Open(filePath, false, System.Type.Missing, System.Type.Missing, System.Type.Missing,
                    System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing,
                    System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing);
                app.Visible = false;
            }
            catch (System.Exception ex)
            {
                MessageBox.Show("Excel操作出错：" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return false;
            }
            finally
            {
            }
            return true;
        }

        public  void CloseFile()
        {
            wb.Save();
            app.Quit();
            app = null;
            return;
        }

        public  void SetCellColor(string TabSheetName, System.Drawing.Color CellColor, int Col, int Row)
        {
            
            if (true)
            {
                try
                {
                    ws = (Microsoft.Office.Interop.Excel.Worksheet)wb.Worksheets.get_Item(TabSheetName);
                    range = (Range)ws.Cells[Row, Col];
                    range.Interior.Color = System.Drawing.ColorTranslator.ToOle(CellColor);
                    
                    app.DisplayAlerts = false;
                    app.AlertBeforeOverwriting = false;
                    
                }
                catch (System.Exception ex)
                {
                    MessageBox.Show("Excel操作出错：" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                finally
                {
                }
            }
            return;
        }
    }
}