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

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值