其它参考1

其它参考2

• 用于OOXML格式的ExcelPackage(Office 2007)
  


• NPOI for .XLS格式(Office 2003)。 NPOI 2.0(Alpha)也支持XLSX。[23]
  

其它参考3

• 不需要安装Office


• 由Microsoft制作=体面的MSDN文档


• 只需一个.Net dll即可在项目中使用


• SDK附带了许多工具，例如diff，validator等

• 下载SDK


• 主要MSDN登陆


• 我如何......首页


• blogs.MSDN brian_jones宣布SDK


• blogs.MSDN brian_jones描述SDK处理大文件而不崩溃(与DOM方法不同)

其它参考4

using (OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\temp\\test.xls;Extended Properties='Excel 8.0;HDR=Yes'"))
{
  conn.Open();
  OleDbCommand cmd = new OleDbCommand("CREATE TABLE [Sheet1] ([Column1] string, [Column2] string)", conn);
  cmd.ExecuteNonQuery();
}

• 嘿，脚本专家!如何在不使用Excel的情况下从Excel读取?


• 如何使用ADO.NET使用Visual Basic .NET在Excel工作簿中检索和修改记录


• 使用ADO.NET C#DbProviderFactory读取和编写Excel电子表格

其它参考5

其它参考6

其它参考7

其它参考8

其它参考9

  Microsoft目前不推荐，也不支持，
  任何无人值守的Microsoft Office应用程序的自动化，
  非交互式客户端应用程序或组件(包括ASP，
  ASP.NET，DCOM和NT服务)，因为Office可能会出现不稳定
  Office在此环境中运行时的行为和/或死锁。

其它参考10

  它提供了一种面向对象的方式来操作文件(类似于
  VBA)没有处理XML文档的麻烦。它可以使用
  任何.NET语言，如C#和Visual Basic(VB)。

  
  ClosedXML允许您在不使用Excel的情况下创建Excel 2007/2010文件
  应用。典型示例是在Web上创建Excel报表
  服务器:

var workbook = new XLWorkbook();
var worksheet = workbook.Worksheets.Add("Sample Sheet");
worksheet.Cell("A1").Value = "Hello World!";
workbook.SaveAs("HelloWorld.xlsx");

其它参考11

CreateExcelFile.CreateExcelDocument(myDataSet, "C:\\Sample.xlsx");

其它参考12

其它参考13

• ASP.NET


• ASP.NET MVC


• UWP


• Xamarin


• WPF和Windows窗体


• Windows服务和基于批处理的操作

//Creates a new instance for ExcelEngine.
ExcelEngine excelEngine = new ExcelEngine();
//Loads or open an existing workbook through Open method of IWorkbooks
IWorkbook workbook = excelEngine.Excel.Workbooks.Open(fileName);
//To-Do some manipulation|
//To-Do some manipulation
//Set the version of the workbook.
workbook.Version = ExcelVersion.Excel2013;
//Save the workbook in file system as xlsx format
workbook.SaveAs(outputFileName);

其它参考14

其它参考15

• Gembox


• ComponentOne Excel

其它参考16

其它参考17

其它参考18

其它参考19

其它参考20

其它参考21

其它参考22

其它参考23

public class GridViewExportUtil
{
    public static void Export(string fileName, GridView gv)
    {
        HttpContext.Current.Response.Clear();
        HttpContext.Current.Response.AddHeader(
            "content-disposition", string.Format("attachment; filename={0}", fileName));
        HttpContext.Current.Response.ContentType = "application/ms-excel";

        using (StringWriter sw = new StringWriter())
        {
            using (HtmlTextWriter htw = new HtmlTextWriter(sw))
            {
                //  Create a form to contain the grid
                Table table = new Table();

                //  add the header row to the table
                if (gv.HeaderRow != null)
                {
                    GridViewExportUtil.PrepareControlForExport(gv.HeaderRow);
                    table.Rows.Add(gv.HeaderRow);
                }

                //  add each of the data rows to the table
                foreach (GridViewRow row in gv.Rows)
                {
                    GridViewExportUtil.PrepareControlForExport(row);
                    table.Rows.Add(row);
                }

                //  add the footer row to the table
                if (gv.FooterRow != null)
                {
                    GridViewExportUtil.PrepareControlForExport(gv.FooterRow);
                    table.Rows.Add(gv.FooterRow);
                }

                //  render the table into the htmlwriter
                table.RenderControl(htw);

                //  render the htmlwriter into the response
                HttpContext.Current.Response.Write(sw.ToString());
                HttpContext.Current.Response.End();
            }
        }
    }

    /// <summary>
    /// Replace any of the contained controls with literals
    /// </summary>
    /// <param name="control"></param>
    private static void PrepareControlForExport(Control control)
    {
        for (int i = 0; i < control.Controls.Count; i++)
        {
            Control current = control.Controls[i];
            if (current is LinkButton)
            {
                control.Controls.Remove(current);
                control.Controls.AddAt(i, new LiteralControl((current as LinkButton).Text));
            }
            else if (current is ImageButton)
            {
                control.Controls.Remove(current);
                control.Controls.AddAt(i, new LiteralControl((current as ImageButton).AlternateText));
            }
            else if (current is HyperLink)
            {
                control.Controls.Remove(current);
                control.Controls.AddAt(i, new LiteralControl((current as HyperLink).Text));
            }
            else if (current is DropDownList)
            {
                control.Controls.Remove(current);
                control.Controls.AddAt(i, new LiteralControl((current as DropDownList).SelectedItem.Text));
            }
            else if (current is CheckBox)
            {
                control.Controls.Remove(current);
                control.Controls.AddAt(i, new LiteralControl((current as CheckBox).Checked ? "True" : "False"));
            }

            if (current.HasControls())
            {
                GridViewExportUtil.PrepareControlForExport(current);
            }
        }
    }
}

其它参考24

using (ExcelHelper helper = new ExcelHelper(TEMPLATE_FILE_NAME, GENERATED_FILE_NAME))
{
    helper.Direction = ExcelHelper.DirectionType.TOP_TO_DOWN;
    helper.CurrentSheetName = "Sheet1";
    helper.CurrentPosition = new CellRef("C3");

    //the template xlsx should contains the named range "header"; use the command "insert"/"name".
    helper.InsertRange("header");

    //the template xlsx should contains the named range "sample1";
    //inside this range you should have cells with these values:
    //<name> , <value> and <comment>, which will be replaced by the values from the getSample()
    CellRangeTemplate sample1 = helper.CreateCellRangeTemplate("sample1", new List<string> {"name", "value", "comment"}); 
    helper.InsertRange(sample1, getSample());

    //you could use here other named ranges to insert new cells and call InsertRange as many times you want, 
    //it will be copied one after another;
    //even you can change direction or the current cell/sheet before you insert

    //typically you put all your "template ranges" (the names) on the same sheet and then you just delete it
    helper.DeleteSheet("Sheet3");
}        

private IEnumerable<List<object>> getSample()
{
    var random = new Random();

    for (int loop = 0; loop < 3000; loop++)
    {
        yield return new List<object> {"test", DateTime.Now.AddDays(random.NextDouble()*100 - 50), loop};
    }
}

其它参考25

其它参考26

其它参考27

  http://www.devtriogroup.com/ExcelJetcell/Samples[70]

其它参考28

1. 使用该工具安装Open XML SDK。


2. 使用具有所需外观的最新Excel客户端创建Excel文件。将其命名为DesiredLook.xlsx。


3. 打开工具DesiredLook.xlsx并单击顶部附近的Reflect Code按钮。
   


4. 您的文件的C#代码将在该工具的右侧窗格中生成。将其添加到您的C#解决方案中，并生成具有所需外观的文件。

其它参考29