C# word、excel转PDF，读取json数据

╰+哭是因爲堅強的太久メ 2023-10-06 22:01 23阅读 0赞

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rGf5bee55uK5b2k_size_20_color_FFFFFF_t_70_g_se_x_16]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rGf5bee55uK5b2k_size_20_color_FFFFFF_t_70_g_se_x_16 1]  
[使用json][json]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rGf5bee55uK5b2k_size_20_color_FFFFFF_t_70_g_se_x_16 2]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rGf5bee55uK5b2k_size_20_color_FFFFFF_t_70_g_se_x_16 3]

using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Runtime.InteropServices;
    using System.Text;
    using MSWord = Microsoft.Office.Interop.Word;
    using Microsoft.Office.Interop.Excel;
    using System.IO;
    using System.Reflection;
    using Newtonsoft.Json;
    using Newtonsoft.Json.Linq;
    //using Microsoft.Office.Tools.Word;
    
    namespace Console_WordSkill_All
    {
        
        class Program
        {
        
            static void Main(string[] args)
            {
        
                
                string str = Readjson("filePath");
                Console.WriteLine("结果为{0}", str);
    
                string postfix = CheckTrueFileName(str);
                Console.WriteLine(postfix);
    
                switch (postfix)
                {
        
                    case ".doc":
                        WordToPDF(str, postfix);
                        break;
                    case ".docx":
                        WordToPDF(str, postfix);
                        break;
                    case ".xls":
                        ConverterToPdf(str, postfix);
                        break;
                    case ".xlsx":
                        ConverterToPdf(str, postfix);
                        break;
                }
                //WordToPDF(str);
            }
            public static bool WordToPDF(string sourcePath, string postfix)
            {
        
                bool result = false;
                MSWord.Application application = new MSWord.Application();
                MSWord.Document document = null;
                try
                {
        
                    application.Visible = false;
                    document = application.Documents.Open(sourcePath);
                    string PDFPath = sourcePath.Replace(postfix, ".pdf");//pdf存放位置
                    Console.WriteLine(PDFPath);
                    if (!File.Exists(@PDFPath))//存在PDF，不需要继续转换
                    {
        
                        document.ExportAsFixedFormat(PDFPath, MSWord.WdExportFormat.wdExportFormatPDF);
                    }
                    result = true;
                }
                catch (Exception e)
                {
        
                    Console.WriteLine(e.Message);
                    result = false;
                }
                finally
                {
        
                    document.Close();
                }
                return result;
            }
    
            private static bool ConverterToPdf(string sourcePath, string postfix)
            {
        
                bool result = false;
                object missing = Type.Missing;
                Microsoft.Office.Interop.Excel.Application application = new Microsoft.Office.Interop.Excel.Application();
               // Microsoft.Office.Interop.Excel.ApplicationClass application = null;
                Microsoft.Office.Interop.Excel.Workbook workBook = null;
                try
                {
        
                    //application = new Microsoft.Office.Interop.Excel.ApplicationClass();
                    object target =  sourcePath.Replace(postfix, ".pdf");//pdf存放位置
    
                    Microsoft.Office.Interop.Excel.XlFixedFormatType type = Microsoft.Office.Interop.Excel.XlFixedFormatType.xlTypePDF;
                    workBook = application.Workbooks.Open(sourcePath, missing, missing, missing, missing, missing,
                            missing, missing, missing, missing, missing, missing, missing, missing, missing);
                    将Excel中某个工作簿另存为PDF文件
                    //Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workBook.Worksheets["工作簿名称或索引"];
                    //worksheet.ExportAsFixedFormat(type, target, Microsoft.Office.Interop.Excel.XlFixedFormatQuality.xlQualityStandard, true, false, missing, missing, missing, missing);
    
                    //将整个Excel另存为PDF文件
                    workBook.ExportAsFixedFormat(type, target, Microsoft.Office.Interop.Excel.XlFixedFormatQuality.xlQualityStandard, true, false, missing, missing, missing, missing);
                    result = true;
                }
                catch (Exception ex)
                {
        
                    Console.WriteLine(ex.Message);
                    result = false;
                }
                finally
                {
        
    
                    if (workBook != null)
                    {
        
                        workBook.Close(false, missing, missing);
                        workBook = null;
                    }
    
                    if (application != null)
                    {
        
                        application.Quit();
                        application = null;
                    }
                    GC.Collect();
    
                    GC.WaitForPendingFinalizers();
                }
    
                return result;
            }
    
            //读取json文件
            public static string Readjson(string key)
            {
        
                string jsonfile = "C:/create.json";//JSON文件路径
                
                using (System.IO.StreamReader file = new StreamReader(jsonfile, Encoding.Default))
                {
        
                    using (JsonTextReader reader = new JsonTextReader(file))
                    {
        
                        JObject o = (JObject)JToken.ReadFrom(reader);
                        var value = o[key].ToString();
                        return value;
                    }
                }
            }
    
            //判断文件类型
            public static string CheckTrueFileName(string path)
            {
        
                System.IO.FileStream fs = new System.IO.FileStream(path, System.IO.FileMode.Open, System.IO.FileAccess.Read);
                System.IO.BinaryReader r = new System.IO.BinaryReader(fs);
                string bx = " ";
                byte buffer;
                try
                {
        
                    buffer = r.ReadByte();
                    bx = buffer.ToString();
                    buffer = r.ReadByte();
                    bx += buffer.ToString();
                }
                catch (Exception exc)
                {
        
                    Console.WriteLine(exc.Message);
                }
                r.Close();
                fs.Close();
                
                //真实的文件类型，数字
                //Console.WriteLine(bx);
                //文件名，包括后缀
                //Console.WriteLine(System.IO.Path.GetFileName(path));
                //文件名,不包括后缀
                //Console.WriteLine(System.IO.Path.GetFileNameWithoutExtension(path));
                //文件格式.doc
                //Console.WriteLine(System.IO.Path.GetExtension(path));
    
                return System.IO.Path.GetExtension(path);
            }
    
        }
    }

[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rGf5bee55uK5b2k_size_20_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/7d9f5ff1e2e540c5a078cd152221c493.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rGf5bee55uK5b2k,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rGf5bee55uK5b2k_size_20_color_FFFFFF_t_70_g_se_x_16 1]: https://img-blog.csdnimg.cn/555eb508d4594d80accaab480d62908e.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rGf5bee55uK5b2k,size_20,color_FFFFFF,t_70,g_se,x_16
[json]: https://jingyan.baidu.com/article/e75aca85130858142edac635.html
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rGf5bee55uK5b2k_size_20_color_FFFFFF_t_70_g_se_x_16 2]: https://img-blog.csdnimg.cn/f253ed5cfc9d4e10b7979d443c57f679.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rGf5bee55uK5b2k,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rGf5bee55uK5b2k_size_20_color_FFFFFF_t_70_g_se_x_16 3]: https://img-blog.csdnimg.cn/34015ffb46a747d1b25a34b385f96fb1.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rGf5bee55uK5b2k,size_20,color_FFFFFF,t_70,g_se,x_16