.NET 强大的Excel控件，支持WinForm、WPF、Android【强烈推荐】

总的来说是一个可以快速构建、具有高性能、良好交互、美观的UI表格控件。控件核心功能1、工作簿：支持多工作表、工作表选项卡控件；2、工作表：支持合并、取消合并、单元格编辑、数据格式、自定义单元格、填充数据序列、单元格文本旋转、富文本、剪贴板、下拉列表单元格、边框、样式、分组过滤等；3、打印：打印、分页打印；4、图片：插入图片；5、图表：折线、柱状、条形、面积图、饼图等；6、文件格式：支持导出Excel、CSV、Html、RGF格式。使用方法下面以WinForm举例1、安装控件PM> Install-Package unvell.ReoGrid.dll

2、拖拉控件3、向填充单元格文本var worksheet = reoGridControl1.CurrentWorksheet;

worksheet.Cells["A1"].Data = "Hello World!";

worksheet.Cells["A1"].Style.TextColor = Color.Red;

效果4、汇总折线图var worksheet = reoGridControl1.CurrentWorksheet;

worksheet["A2"] = new object[,] {

{ null, 2008, 2009, 2010, 2011, 2012 },

{ "City 1", 3, 2, 4, 2, 6 },

{ "City 2", 7, 5, 3, 6, 4 },

{ "City 3", 13, 10, 9, 10, 9 },

{ "Total", "=SUM(B3:B5)", "=SUM(C3:C5)", "=SUM(D3:D5)",

"=SUM(E3:E5)", "=SUM(F3:F5)" },

};

var dataRange = worksheet.Ranges["B3:F5"];

var serialNamesRange = worksheet.Ranges["A3:A6"];

var categoryNamesRange = worksheet.Ranges["B2:F2"];

worksheet.AddHighlightRange(categoryNamesRange);

worksheet.AddHighlightRange(serialNamesRange);

worksheet.AddHighlightRange(dataRange);

var c1 = new LineChart

{

Location = new unvell.ReoGrid.Graphics.Point(500, 50),

Size = new Size(400, 260),

Title = "折线图示例",

DataSource = new WorksheetChartDataSource(worksheet, serialNamesRange, dataRange)

{

CategoryNameRange = categoryNamesRange,

}

};

worksheet.FloatingObjects.Add(c1);

效果更多效果图项目地址https://github.com/unvell/ReoGrid