c# 将xml格式的Excel文件转换为标准的Excel

最新推荐文章于 2021-12-01 15:56:30 发布

diutihui6853

最新推荐文章于 2021-12-01 15:56:30 发布

阅读量412

点赞数

文章标签： c#

原文链接：http://www.cnblogs.com/bjxly/archive/2012/03/22/2412684.html

版权

public static void ConvertExcel(string savePath)
    {
//将xml文件转换为标准的Excel格式 
        Object Nothing = Missing.Value;//由于yongCOM组件很多值需要用Missing.Value代替   
        Excel.Application ExclApp = new Excel.ApplicationClass();// 初始化
        Excel.Workbook ExclDoc = ExclApp.Workbooks.Open(savePath, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing);//打开Excl工作薄   
        try
        {
            Object format = Excel.XlFileFormat.xlWorkbookNormal;//获取Excl 2007文件格式   
            ExclApp.DisplayAlerts = false;
            ExclDoc.SaveAs(savePath, format, Nothing, Nothing, Nothing, Nothing, Excel.XlSaveAsAccessMode.xlExclusive, Nothing, Nothing, Nothing, Nothing, Nothing);//保存为Excl 2007格式   
        }
catch (Exception ex) { }
        ExclDoc.Close(Nothing, Nothing, Nothing);
        ExclApp.Quit();