-
Notifications
You must be signed in to change notification settings - Fork 305
Using chart templates
Jan Källman edited this page Jan 29, 2020
·
14 revisions
EPPlus 5 also support chart templates (with the crtx extension) via the AddChartFromTemplate method.
Crtx files can be exported from Excel from any chart. Chart templates will work for chart types implemented in EPPlus.
//Add an Area chart from a template file.
var areaChart = (ExcelAreaChart)ws.Drawings.AddChartFromTemplate(FileInputUtil.GetFileInfo("15-ChartsAndThemes", "AreaChartStyle3.crtx"), "areaChart");
var areaSerie = areaChart.Series.Add(ws.Cells[2, 7, 26, 7], ws.Cells[2, 6, 26, 6]);
areaSerie.Header = "Order Value";
areaChart.SetPosition(51, 0, 10, 0);
areaChart.SetSize(1000, 300);
areaChart.Title.Text = "Area Chart";See Charts & Themes sample .NET Framework or Charts & Themes sample .NET Core
EPPlus Software AB - https://epplussoftware.com
- What is new in EPPlus 5+
- Breaking Changes in EPPlus 5
- Breaking Changes in EPPlus 6
- Breaking Changes in EPPlus 7
- Breaking Changes in EPPlus 8
- Addressing a worksheet
- Dimension/Used range
- Copying ranges/sheets
- Insert/Delete
- Filling ranges
- Sorting ranges
- Taking and skipping columns/rows
- Data validation
- Comments
- Freeze and Split Panes
- Header and Footer
- Hyperlinks
- Autofit columns
- Grouping and Ungrouping Rows and Columns
- Formatting and styling
- The ExcelRange.Text property
- Conditional formatting
- Using Themes
- Working with custom named table- or slicer- styles
-
Formula Calculation
- Security considerations
- Circular references
- Referencing tables in formulas
- Supported Functions
- Dynamic array formulas
- Legacy array formulas
- Lambda functions
- Regression analysis functions
- Custom functions for calculations
- Function prefixes
- Precision as Displayed
- Cancelling a calculation
- Trim reference operator
- Working with filters
- Working with slicers
- Working with External Workbooks