winform操作Excel文件

最新推荐文章于 2024-08-03 02:28:13 发布

redder_xu

最新推荐文章于 2024-08-03 02:28:13 发布

阅读量4.4k

点赞数

分类专栏： winform 文章标签： excel winform exception object string null

本文链接：https://blog.csdn.net/redder_xu/article/details/6753418

版权

这篇博客展示了如何在Winform应用程序中操作Excel文件，包括打开、读取、修改和保存Excel文件。通过创建Microsoft.Office.Interop.Excel对象，实现了读取单元格值、设置单元格值、获取所有单元格值到DataTable等功能，并提供了异常处理机制。

摘要由CSDN通过智能技术生成

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Reflection;
using System.IO;
using Microsoft.Office.Interop.Excel;//关键

namespace WindowsFormsApplication5
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private Microsoft.Office.Interop.Excel.Application excelApplication = null;
        private Workbooks excelWorkBooks = null;
        private Workbook excelWorkBook = null;
        private Worksheet excelWorkSheet = null;
        private Range excelRange = null;//Excel Range Object,多种用途
        public int ActiveSheetIndex = 0;

        private void Form1_Load(object sender, EventArgs e)
        {
            excelApplication = null;//Excel Application Object
            excelWorkBooks = null;//Workbooks
            excelWorkBook = null;//Excel Workbook Object
            excelWorkSheet = null;//Excel Worksheet Object
            ActiveSheetIndex = 1;

            //测试以下的函数是否正确
            OpenExcelFile("F:\\ee.xls");
            //setOneCellValue(2, 2, "i love u");
            //MessageBox.Show("cell:"+getOneCellValue(2,2));
            //MessageBox.Show("value:" + getCellsValue(excelWorkSheet.Cells[1,2], excelWorkSheet.Cells[2,3])[0]);
            setCellsValue(excelWorkSheet.Cells[2, 2], excelWorkSheet.Cells[3, 3], "same");
            SetActiveWorkSheet(1);
            System.Data.DataTable dt = new System.Data.DataTable();
            dt = getAllCellsValue();
            dataGridView1.DataSource = dt;
            dt.TableName = "table1";
            dt.AcceptChanges();

            //MessageBox.Show("value:" + getTotalRowCount().ToString());
            //MessageBox.Show("value:" + getTotalColumnCount().ToString());
            saveExcel("F:\\save2.xls");
        }

        public void saveExcel(string excelSaveFileName)
        {
            if (File.Exists(excelSaveFileName))
            {
                if (MessageBox.Show(excelSaveFileName + "已存在,需要覆盖吗？", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
                {
                    File.Delete(excelSaveFileName);
                    excelWorkSheet.SaveAs(excelSaveFileName, Excel.XlFileFormat.xlTemplate, Type.Missin