Essential XlsIO是一款.NET类库,可以帮助开发人员进行 Microsoft Excel 文件的读写,客户电脑上并不需要安装 Microsoft Excel,兼容Microsoft Excel Versions 97 to 2013,可以对Excel文件进行格式化和设置公式,导入和导出数据,支持为Excel文件创建图表,支持数据验证和条件格式化,数据的分类排序,Excel文件的加密解密等。
Essential XlsIO包含在
Essential Studio File Formats套包产品里,可以用于Windows forms, WPF, ASP.NET Webforms, ASP.NET MVC, Silverlight, WinRT, Windows Phone, Universal and Xamarin 等平台和应用上。这篇文章主要介绍怎么利用该控件对Excel单元格文本进行格式化,具体可以参考下面的代码:
ExcelEngine excelEngine = new ExcelEngine();
IApplication application = excelEngine.Excel;
application.DefaultVersion = ExcelVersion.Excel2013;
IWorkbook workbook = application.Workbooks.Create(1);
IWorksheet worksheet = workbook.Worksheets[0];
//Insert Rich Text.
IRange range = worksheet.Range["A1"];
range.Text = "RichText";
IRichTextString rtf = range.RichText;
//Formatting first 4 characters.
IFont redFont = workbook.CreateFont();
redFont.Bold = true;
redFont.Italic = true;
redFont.RGBColor = Color.Red;
rtf.SetFont(0, 3, redFont);
//Formatting last 4 characters.
IFont blueFont = workbook.CreateFont();
blueFont.Bold = true;
blueFont.Italic = true;
blueFont.RGBColor = Color.Blue;
rtf.SetFont(4, 7, blueFont);
workbook.SaveAs("FormattingText.xlsx");
workbook.Close();
excelEngine.Dispose();