Excel以PDF格式的C＃库 [英] Excel to PDF C# library

问题描述

我要寻找一个msexcel的表（.xsl和.xlsx）格式为PDF转换器/库或API。我想为我的C＃.NET应用程序。

I am looking for a MsExcel (.xsl and .xlsx) to PDF converter/library or API. I want it for my C# .Net application.

我喜欢商业库，但不能承受了。

I like commercial libraries, but can't afford much.

推荐答案

这些文章将帮助您

的 PDF转换服务

iTextSharp的

Excel以PDF .NET

修改：我发现这个类的函数

EDIT: I found this class function.

public DataSet GetExcel(string fileName)
    {
        Application oXL;
        Workbook oWB;
        Worksheet oSheet;
        Range oRng;
        try 
        {
            //  creat a Application object
            oXL = new ApplicationClass();
            //   get   WorkBook  object
            oWB = oXL.Workbooks.Open(fileName, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
                    Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
                    Missing.Value, Missing.Value);

            //   get   WorkSheet object 
            oSheet = (Microsoft.Office.Interop.Excel.Worksheet)oWB.Sheets[1];
            System.Data.DataTable dt = new System.Data.DataTable("dtExcel");
            DataSet ds = new DataSet();
            ds.Tables.Add(dt);
            DataRow dr;

            StringBuilder sb = new StringBuilder();
            int jValue = oSheet.UsedRange.Cells.Columns.Count;
            int iValue = oSheet.UsedRange.Cells.Rows.Count;
            //  get data columns
            for (int j = 1; j <= jValue; j++)
            {
                dt.Columns.Add("column" + j, System.Type.GetType("System.String"));
            }

            //string colString = sb.ToString().Trim();
            //string[] colArray = colString.Split(':');

            //  get data in cell
            for (int i = 1; i <= iValue; i++)
            {
                dr = ds.Tables["dtExcel"].NewRow();
                for (int j = 1; j <= jValue; j++)
                {
                    oRng = (Microsoft.Office.Interop.Excel.Range)oSheet.Cells[i, j];
                    string strValue = oRng.Text.ToString();
                    dr["column" + j] = strValue;
                }
                ds.Tables["dtExcel"].Rows.Add(dr);
            }
            return ds;
        }
        catch (Exception ex)
        {
            Label1.Text = "Error: ";
            Label1.Text += ex.Message.ToString();
            return null;
        }
        finally
        {
            Dispose();
        } 

编辑2：另外我发现这篇文章帮助您

EDIT 2: Also i found this article help for you!

HTTP：// WWW。 c-sharpcorner.com/Uplo​​adFile/psingh/PDFFileGenerator12062005235236PM/PDFFileGenerator.aspx

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