欢迎访问 生活随笔!

生活随笔

当前位置: 首页 > 编程资源 > 编程问答 >内容正文

编程问答

WOrd ,excel实现打印功能

发布时间:2025/7/25 编程问答 49 豆豆
生活随笔 收集整理的这篇文章主要介绍了 WOrd ,excel实现打印功能 小编觉得挺不错的,现在分享给大家,帮大家做个参考.

            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

总结

以上是生活随笔为你收集整理的WOrd ,excel实现打印功能的全部内容,希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错,欢迎将生活随笔推荐给好友。