惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

N
Netflix TechBlog - Medium
T
The Blog of Author Tim Ferriss
aimingoo的专栏
aimingoo的专栏
A
About on SuperTechFans
Stack Overflow Blog
Stack Overflow Blog
B
Blog RSS Feed
Microsoft Security Blog
Microsoft Security Blog
H
Hackread – Cybersecurity News, Data Breaches, AI and More
人人都是产品经理
人人都是产品经理
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
J
Java Code Geeks
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
B
Blog
MongoDB | Blog
MongoDB | Blog
L
LangChain Blog
WordPress大学
WordPress大学
小众软件
小众软件
IT之家
IT之家
腾讯CDC
月光博客
月光博客
量子位
Blog — PlanetScale
Blog — PlanetScale
P
Proofpoint News Feed
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More

博客园 - 蒜头

Mailbox unavailable. The server response was: 5.7.1 Unable to relay for (email address). 再谈Images到xps,pdf的转换 SQL Server 2005中xml类型和函数的简单应用 Image.FromFile gives "Out of Memory" Exception for icon - 蒜头 简单介绍PDF,XPS,Images,Office 2007之间的转换方法 - 蒜头 - 博客园 SQL 2005 全文检索(续) 简单实现C#生成Excel 2007文件并下载 简单应用ReportViewer控件 配置SQL Server Session方法 采用负载均衡,部署了两个ASP.NET 2.0的站点服务器碰到的问题 初试VSTS 2008(TFS安装) Windows Server 2003分区修改方法[转载] 制作VSTO 2005 SE开发的Office 2007 AddIn的安装包 一个简单的document library event handler VS 2005 SP1 安装错误 [续] 一个简单的Checkbox Custom Field Type ASP.NET 2.0 SQL Cache 配置方法 解读Document Library关于权限的对象模型 SharePoint应用AJAX.NET和AJAX Control Toolkit
部分Office 2007文件格式转换为xps和pdf代码整理
蒜头 · 2008-04-24 · via 博客园 - 蒜头


转换功能是通过调用安装了转换XPS和PDF的AddIn的Office2007对象模型完成的. 代码支持Office 2007支持的一切文件格式:
 

Office 2007组件

扩展名

Word

DOC, DOCX, DOCM, DOTX, DOTM, DOT, TXT, RTP, RTF

Excel

XLS, XLSX, XLSM, XML

PowerPoint

PPT, PPTX, PPTM, POTX, PPSX, PPSM, POTM


添加对三个组件的引用:

这里使用一个枚举类型来来决定生成文件的类型,包括:



其实可以使用个方法来实现这个功能,这里Word和Excel我使用了ExportAsFixedFormat,PowerPoint使用了SaveAs,对于Word和PowerPoint效果是一样的。只是SaveAs支持的格式更多, 但我发现似乎Excel不支持SaveAs.

Word转换代码:

        private bool Convert(string sourcePath, string targetPath, Word.WdExportFormat exportFormat)
        
{
            
bool result;
            
object paramMissing = Type.Missing;
            Word.ApplicationClass wordApplication 
= new Word.ApplicationClass();
            Word.Document wordDocument 
= null;
            
try
            
{
                object paramSourceDocPath = sourcePath;
                
string paramExportFilePath = targetPath;

                Word.WdExportFormat paramExportFormat 
= exportFormat;
                
bool paramOpenAfterExport = false;
                Word.WdExportOptimizeFor paramExportOptimizeFor 
=
                    Word.WdExportOptimizeFor.wdExportOptimizeForPrint;
                Word.WdExportRange paramExportRange 
= Word.WdExportRange.wdExportAllDocument;
                
int paramStartPage = 0;
                
int paramEndPage = 0;
                Word.WdExportItem paramExportItem 
= Word.WdExportItem.wdExportDocumentContent;
                
bool paramIncludeDocProps = true;
                
bool paramKeepIRM = true;
                Word.WdExportCreateBookmarks paramCreateBookmarks 
=
                    Word.WdExportCreateBookmarks.wdExportCreateWordBookmarks;
                
bool paramDocStructureTags = true;
                
bool paramBitmapMissingFonts = true;
                
bool paramUseISO19005_1 = false;

                wordDocument 
= wordApplication.Documents.Open(
                    
ref paramSourceDocPath, ref paramMissing, ref paramMissing,
                    
ref paramMissing, ref paramMissing, ref paramMissing,
                    
ref paramMissing, ref paramMissing, ref paramMissing,
                    
ref paramMissing, ref paramMissing, ref paramMissing,
                    
ref paramMissing, ref paramMissing, ref paramMissing,
                    
ref paramMissing);

                
if (wordDocument != null)
                    wordDocument.ExportAsFixedFormat(paramExportFilePath,
                        paramExportFormat, paramOpenAfterExport,
                        paramExportOptimizeFor, paramExportRange, paramStartPage,
                        paramEndPage, paramExportItem, paramIncludeDocProps,
                        paramKeepIRM, paramCreateBookmarks, paramDocStructureTags,
                        paramBitmapMissingFonts, paramUseISO19005_1,
                        
ref paramMissing);
                result 
= true;
            }

            
finally
            
{
                
if (wordDocument != null)
                
{
                    wordDocument.Close(
ref paramMissing, ref paramMissing, ref paramMissing);
                    wordDocument 
= null;
                }

                
if (wordApplication != null)
                
{
                    wordApplication.Quit(
ref paramMissing, ref paramMissing, ref paramMissing);
                    wordApplication 
= null;
                }

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

            
return result;
        }

private bool Convert(string sourcePath, string targetPath, XlFixedFormatType targetType)
        
{
            
bool result;
            
object missing = Type.Missing;
            ApplicationClass application 
= null;
            Workbook workBook 
= null;
            
try
            
{
                application 
= new ApplicationClass();
                
object target = targetPath;
                
object type = targetType;
                workBook 
= application.Workbooks.Open(sourcePath, missing, missing, missing, missing, missing,
                    missing, missing, missing, missing, missing, missing, missing, missing, missing);
                workBook.ExportAsFixedFormat(targetType, target, XlFixedFormatQuality.xlQualityStandard, truefalse, missing, missing, missing, missing);
                result 
= true;
            }

            
catch
            
{
                result 
= false;
            }

            
finally
            
{
                
if (workBook != null)
                
{
                    workBook.Close(
true, missing, missing);
                    workBook 
= null;
                }

                
if (application != null)
                
{
                    application.Quit();
                    application 
= null;
                }

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

            
return result;
        }

PowerPoint转换代码:

       private bool Convert(string sourcePath, string targetPath, PpSaveAsFileType targetFileType)
        
{
            
bool result;
            
object missing = Type.Missing;
            ApplicationClass application 
= null;
            Presentation persentation 
= null;
            
try
            
{
                application 
= new ApplicationClass();
                persentation 
= application.Presentations.Open(sourcePath, MsoTriState.msoTrue, MsoTriState.msoFalse, MsoTriState.msoFalse);
                persentation.SaveAs(targetPath, targetFileType, Microsoft.Office.Core.MsoTriState.msoTrue);


                result 
= true;
            }

            
catch
            
{
                result 
= false;
            }

            
finally
            
{
                
if (persentation != null)
                
{
                    persentation.Close();
                    persentation 
= null;
                }

                
if (application != null)
                
{
                    application.Quit();
                    application 
= null;
                }

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

            
return result;
        }

感谢同事Hong的协助,把这部分功能实现,现在share给大家,希望为需要的朋友节省时间.
另外浏览xps文件有一个不错的小工具XPS Viewer EP.