基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：813200300

本次赞助数额为： 1 元　

支付宝支付

微信支付

   源码介绍

---

C# 调用Excel 打印预览

  private void button1_Click(object sender, EventArgs e)
        {

            Microsoft.Office.Interop.Excel.Application excelApp = null;
            Microsoft.Office.Interop.Excel.Workbook workBook;
            Microsoft.Office.Interop.Excel.Worksheet workSheet = null;
            Microsoft.Office.Interop.Excel.Range range;

            excelApp = new Microsoft.Office.Interop.Excel.Application();

            workBook = excelApp.Workbooks.Add(XlWBATemplate.xlWBATWorksheet);

            workSheet = (Worksheet)workBook.Worksheets[1];

            //Set SheetName
            workSheet.Name = "DemoSheet";

            //Merge Cell
            range = workSheet.get_Range("B1", "E1");
            range.Merge(range.MergeCells);

            range.Value2 = "Test Table";
            range.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlVAlign.xlVAlignCenter;
            range.Font.Size  = 18;
            range.RowHeight = 40;
            range.Font.Color = System.Drawing.Color.Red.ToArgb();
            range.Font.Bold = true;
            System.Runtime.InteropServices.Marshal.ReleaseComObject(range);