Excel到PDF [英] Excel to PDF

问题描述

ApplicationClass excelApplication = new ApplicationClass();
            Workbook excelWorkBook = null;

            excelApplication.DisplayAlerts = false;

            string paramSourceBookPath = @"E:\indata\BAC\FileSplitter\Ready\EDOC0E15985105744D5BA91BECCCFB0D111F\Kelly_FaxImage_JobID_updated.xlsx";
            object paramMissing = Type.Missing;

            string paramExportFilePath = @"C:\Test.pdf";
            XlFixedFormatType paramExportFormat = XlFixedFormatType.xlTypePDF;
            XlFixedFormatQuality paramExportQuality =
                XlFixedFormatQuality.xlQualityStandard;
            bool paramOpenAfterPublish = false;
            bool paramIncludeDocProps = true;
            bool paramIgnorePrintAreas = true;
            object paramFromPage = Type.Missing;
            object paramToPage = Type.Missing;

            try
            {
                // Open the source workbook.
                
                excelWorkBook = excelApplication.Workbooks.Open(paramSourceBookPath,
                    paramMissing, paramMissing, paramMissing, paramMissing,
                    paramMissing, paramMissing, paramMissing, paramMissing,
                    paramMissing, paramMissing, paramMissing, paramMissing,
                    paramMissing, paramMissing);

                // Save it in the target format.
                if (excelWorkBook != null)
                    excelWorkBook.ExportAsFixedFormat(paramExportFormat,
                        paramExportFilePath, paramExportQuality,
                        paramIncludeDocProps, paramIgnorePrintAreas, paramFromPage,
                        paramToPage, paramOpenAfterPublish,
                        paramMissing);
            }
            catch (Exception ex)
            {
                // Respond to the error.
            }
            finally
            {
                // Close the workbook object.
                if (excelWorkBook != null)
                {
                    excelWorkBook.Close(false, paramMissing, paramMissing);
                    excelWorkBook = null;
                }

                // Quit Excel and release the ApplicationClass object.
                if (excelApplication != null)
                {
                    excelApplication.Quit();
                    excelApplication = null;
                }

                GC.Collect();
                GC.WaitForPendingFinalizers();
                GC.Collect();
                GC.WaitForPendingFinalizers();

我开发了使用c＃从excel导出到pdf的程序。一切都很好，但转换时显示progrssbar。我不知道如何禁用yhis。

---

S. Mukesh Kumar

i have developed program using c# for exporting from excel to pdf. everything is fine but while conversion it shows progrssbar. i dont wnat this how to disable yhis.

---

S. Mukesh Kumar

推荐答案

为什么进度条的外观有问题？

Why is the appearance of the progress bar a problem?

我可以理解想要在非常短的操作中压制它（1到7秒） - 尽管如此，你应该确保将光标改为等号（沙漏）。 可用性最佳实践是，超过7秒左右，使用进度条告知用户进度是必不可少的
： - ）

I can understand wanting to suppress it for very short operations (1 to 7 seconds) -- although then, you should be sure to change your cursor to the wait symbol (hourglass).  Usability best practices are that, beyond 7 seconds or so, it's essential to use a progress bar to inform users of, um, progress :-)

问候，

Anonymous9748

Anonymous9748

这篇关于Excel到PDF的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！