调用excel的打印预览

最新推荐文章于 2024-07-06 02:50:51 发布

Nemo_XP

最新推荐文章于 2024-07-06 02:50:51 发布

阅读量1.8k

点赞数

分类专栏： EXCEL操作

本文链接：https://blog.csdn.net/spw55381155/article/details/79895273

版权

EXCEL操作专栏收录该内容

21 篇文章 3 订阅

订阅专栏

一、打开Excel

String ExcelFile = System.Windows.Forms.Application.StartupPath + @"\Reports\" +

lStrFileName;

      Excel.Application xlsApp = new Excel.Application();
      //xlsApp.Visible = true;
      Excel.Workbooks xlsWbs = xlsApp.Workbooks;
      Excel.Workbook xlsWb = xlsWbs.Open(

ExcelFile,Missing.Value, false,Missing.Value,Missing.Value,

Missing.Value, Missing.Value, Missing.Value, Missing.Value,

Missing.Value, Missing.Value);
Excel.Worksheet xlsWs = (Excel.Worksheet)xlsWb.Worksheets[1];

二、预览

            //使excel可见
            xlsApp.Visible = true;
            //预览
            xlsWb.PrintPreview();

            //保存后退出，并释放资源
            xlsApp.DisplayAlerts = false;
            xlsWb.Save();
            //xlsWb.SaveAs(ExcelFile, Missing.Value, Missing.Value, Missing.Value, Missing.Value,

Missing.Value,Excel.XlSaveAsAccessMode.xlShared, Missing.Value,

                           Missing.Value, Missing.Value, Missing.Value, Missing.Value);
            xlsWs = null;
            xlsWb = null;
            xlsApp.Quit();
            xlsApp = null;

三、打印

     //使excel可见
            xlsApp.Visible = true;
            //打印
            xlsWb.PrintOutEx(1, 1, 1, Missing.Value, Missing.Value, Missing.Value, Missing.Value,

                             Missing.Value, Missing.Value);
            //保存后退出，并释放资源
            xlsApp.DisplayAlerts = false;
            xlsWb.Save();
            //xlsWb.SaveAs(ExcelFile, Missing.Value, Missing.Value, Missing.Value, Missing.Value,

Missing.Value,Excel.XlSaveAsAccessMode.xlShared, Missing.Value,

                           Missing.Value, Missing.Value, Missing.Value, Missing.Value);
            xlsWs = null;
            xlsWb = null;
            xlsApp.Quit();
            xlsApp = null;