• Excel转换成图片


    excel转换成图片

    首先将Excel文档转换成PDF文件,添加引用using Excel = Microsoft.Office.Interop.Excel;

    然后对PDF文件进行转换成图片,(PDF转换成图片参照博客中PDF操作),转换出的Excel图片和Excel文档格式有些出入。

    下面代码是Excel转换成PDF文件:

                string FilePath="";//exce文档路径
           string OutPath = "";//输出路径
           Excel.XlFixedFormatType targetType = Excel.XlFixedFormatType.xlTypePDF;
                object missing = Type.Missing;
                Excel.Application application = null;
                Excel.Workbook workExcel = null;
                try
                {
                    application = new Excel.Application();
                    object target = OutPath;
                    object type = targetType;
                    workExcel= application.Workbooks.Open(FilePath, missing, missing, missing, missing, missing,
                            missing, missing, missing, missing, missing, missing, missing, missing, missing);
    
                    workExcel.ExportAsFixedFormat(targetType, target, Excel.XlFixedFormatQuality.xlQualityStandard, true, false, missing, missing, missing, missing);
                    result = true;
                }
                catch
                {
                    result = false;
                }
                finally
                {
                    if (workExcel != null)
                    {
                        workExcel.Close(true, missing, missing);
                        workExcel = null;
                    }
                    if (application != null)
                    {
                        application.Quit();
                        application = null;
                    }
                    GC.Collect();
                    GC.WaitForPendingFinalizers();
                    GC.Collect();
                    GC.WaitForPendingFinalizers();
                }
  • 相关阅读:
    xpath的几个常用规则
    xpath定位不到原因浅析
    这一代人得学习
    scrapy之Request对象
    cookie字段属性解析
    selenium中get_cookies()和add_cookie()的用法
    python中生成器generator
    swagger demo code
    ctrip-apollo
    eclipse 快捷键使用日志
  • 原文地址:https://www.cnblogs.com/machenghu/p/6419281.html
Copyright © 2020-2023  润新知