C#操作Excel_se7en3_新浪博客

需引入Microsoft Excel 11.0 object library

private void button1_Click(object sender, EventArgs e)
        {
            string fileName = "";
            SaveFileDialog sfDialog = new SaveFileDialog();
            sfDialog.DefaultExt = "xls";
            sfDialog.AddExtension = true;
            sfDialog.Filter = "Excel 文件(*.xls)|*.xls|所有文件(*.*)|*.*";

            if (sfDialog.ShowDialog() == DialogResult.OK)
            {

                fileName = sfDialog.FileName;
            }
            else
            {
                MessageBox.Show("无法保存文件！");
                return;
            }
            Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();
            excelApp.Visible = true;

            Excel.Workbook book = excelApp.Workbooks.Add(true);
            //Excel.Worksheet sheet = (Excel.Worksheet)book.Sheets.Add(Type.Missing, Type.Missing, Type.Missing, Type.Missing);
            Excel.Worksheet sheet = (Excel.Worksheet)book.Sheets[1];
            sheet.Name = "Test";

            //设置头部格式
            sheet.get_Range("A1", "D1").HorizontalAlignment = Excel.Constants.xlCenter;
            //sheet.get_Range("A1", "D1").Font.Color = Color.Red;
            sheet.get_Range("A1", "D1").Font.Bold = true;
            sheet.get_Range("A1", "D1").Font.Size = 20;
            sheet.get_Range("A1", "D1").Font.ColorIndex = 18;
            sheet.get_Range("A1", "D1").RowHeight = 40;
            sheet.get_Range("A1", "D1").Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
            sheet.get_Range("A1", "D1").Interior.ColorIndex = 36;

            sheet.get_Range("A1", Type.Missing).Value2 = "A1";
            sheet.get_Range("B1", Type.Missing).Value2 = "B1";
            sheet.get_Range("C1", Type.Missing).Value2 = "C1";
            sheet.get_Range("D1", Type.Missing).Value2 = "D1";

            Excel.Range range = sheet.get_Range("A2",Type.Missing);
           
            range.Value2 = "value2";

            //excelApp.Save(fileName);
            book.Save().SaveAs(fileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
            //sheet.SaveAs(fileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
        }

 

转自：http://hi.baidu.com/luoyuonline/blog/item/0f65d51083d713c1a7ef3f9d.html