C#编程：轻松读写Excel文件的示例

using System;
using System.Collections.Generic;
using System.Reflection;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Windows.Forms;
using Microsoft.Office.Interop.Excel;
using ExcelApplication=Microsoft.Office.Interop.Excel.ApplicationClass;


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

        private void button1_Click(object sender, EventArgs e)
        {
            ExcelApplication excel = new ExcelApplication();
            try
            {
                excel.Visible = false;
                //excel.Workbooks.Add(Missing.Value);

                //excel.Sheets.Add(Missing.Value);
                Workbook book = excel.Workbooks.Add(Missing.Value);
                Worksheet sheet = (Worksheet)excel.Sheets[1];
                sheet.Name = "销售表";
                //Worksheet sheet = (Worksheet)excel.ActiveSheet;// 获取当前工作表  
                Range range = null;// 创建一个空的单元格对象 
                /*string tmp = "a_b_c";
                string[] my = tmp.Split('_');
                foreach (string str in my)
                {
                    MessageBox.Show(str);
                }*/

                 
                range = sheet.get_Range("B1", Missing.Value);// 获取单个单元格 
                range.Value2 = "Fruits";// 设置单元格的值   
                //sheet.Cells[1, 2] = "Fruits333";
                range = sheet.get_Range("B2",Missing.Value);
                range.Value2 = "Apple";
                range = sheet.get_Range("B3",Missing.Value);
                range.Value2 = "Pear";
                range = sheet.get_Range("B4", Missing.Value);
                range.Value2 = "peach";
                range = sheet.get_Range("C1", Missing.Value);
                range.Value2 = "price";
                for (int rowsint = 2; rowsint <= 4; rowsint++ )
                {
                    range = sheet.get_Range("C"+rowsint, Missing.Value);
                    range.Value2 = rowsint+4;// 设置单元格的值
                }