WOrd ,excel实现打印功能

最新推荐文章于 2023-05-05 10:54:06 发布

转载最新推荐文章于 2023-05-05 10:54:06 发布 · 91 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/swarb/archive/2012/04/11/9924430.html

本文介绍了一种使用C#代码实现Word文档打印的方法。通过调用Microsoft.Office.Interop.Word库，可以实现选择文件并设置打印参数的功能，包括指定打印机名称及打印份数等。

            PrintDocument print = new PrintDocument();
            string sDefault = print.PrinterSettings.PrinterName;//默认打印机名
            string s = "";
            foreach (string sPrint in PrinterSettings.InstalledPrinters)//获取所有打印机名称
            {
                s = sPrint;
            }
            return;
            OpenFileDialog fileDialog = new OpenFileDialog();
            //fileDialog.Title = "请选择文件";
            //fileDialog.Filter = "excel03文件(*.xls)|*.xls";
            //fileDialog.FilterIndex = 1;
            //fileDialog.RestoreDirectory = true;

            if (fileDialog.ShowDialog() == DialogResult.OK)
            {
                #region excel
                //Microsoft.Office.Interop.Excel.ApplicationClass xlsApp = new Microsoft.Office.Interop.Excel.ApplicationClass();
                //xlsApp.Visible = true;
                //object oMissing = System.Reflection.Missing.Value;
                //Microsoft.Office.Interop.Excel.Workbook xlsWorkbook = xlsApp.Workbooks.Open(fileDialog.FileName, 0, true, 5, oMissing, oMissing, true, 1, oMissing, false, false, oMissing, false, oMissing, oMissing);
                //Microsoft.Office.Interop.Excel.Worksheet xlsWorksheet = (Microsoft.Office.Interop.Excel.Worksheet)xlsWorkbook.Worksheets[1];
                ////xlsWorksheet.PrintPreview(null);
                //xlsWorksheet.PrintOut(1, 2, 1, false, oMissing, true, false, oMissing);
                //xlsApp.Visible = false;
                //xlsWorksheet = null;
                #endregion
                #region word
                object wordFile = fileDialog.FileName;
                object oMissing = Missing.Value;
                object copies = "1";
                object oTrue = true;
                object oFalse = false;
                object doNotSaveChanges = Microsoft.Office.Interop.Word.WdSaveOptions.wdDoNotSaveChanges;
                Microsoft.Office.Interop.Word.Application appWord = new Microsoft.Office.Interop.Word.Application();
                appWord.Visible = false;
                appWord.DisplayAlerts = Microsoft.Office.Interop.Word.WdAlertLevel.wdAlertsNone;
                string defaultPrinter = appWord.ActivePrinter;
                Microsoft.Office.Interop.Word.Document doc = appWord.Documents.Open(
                    ref wordFile ,
                    ref oMissing,
                    ref oTrue ,
                    ref oFalse ,
                    ref oMissing,
                    ref oMissing,
                    ref oMissing,
                    ref oMissing,
                    ref oMissing,
                    ref oMissing,
                    ref oMissing,
                    ref oMissing,
                    ref oMissing,
                    ref oMissing,
                    ref oMissing,
                    ref oMissing);
                //弹出打印设置
                //appWord.Dialogs[Microsoft.Office.Interop.Word.WdWordDialog.wdDialogFilePrint].Show(ref oMissing);
                //appWord.Visible = false;
                appWord.ActivePrinter = "hp3030 ";
                doc.PrintOut(
                    ref oTrue,
                    ref oFalse,
                    ref oMissing,
                    ref oMissing,
                    ref oMissing,
                    ref oMissing,
                    ref oMissing,
                    ref copies,
                    ref oMissing,
                    ref oMissing,
                    ref oMissing,
                    ref oMissing,
                    ref oMissing,
                    ref oMissing,
                    ref oMissing,
                    ref oMissing,
                    ref oMissing,
                    ref oMissing);
                appWord.ActivePrinter = defaultPrinter;
                doc.Close(ref doNotSaveChanges, ref oMissing, ref oMissing);
                appWord.Quit(ref oMissing, ref oMissing, ref oMissing);
                doc = null;
                appWord = null;
                GC.Collect();
                #endregion word

}

转载于:https://www.cnblogs.com/swarb/archive/2012/04/11/9924430.html