-
Notifications
You must be signed in to change notification settings - Fork 272
Using chart templates
Mats Alm edited this page Nov 6, 2023
·
8 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 = ws.Drawings.AddChartFromTemplate(new FileInfo(@"c:\Temp\AreaChartStyle3.crtx"), "areaChart").As.Chart.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";EPPlus Software AB - https://epplussoftware.com
- Getting Started
- The Sample Project
- EPPlus and Docker
- EPPlus and Blazor
- EPPlus and Linux
- Security
- Configuration
- Releases/versioning
- What is new in EPPlus 5+
- Breaking Changes in EPPlus 5
- Breaking Changes in EPPlus 6
- Breaking Changes in EPPlus 7
- 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
- Autofit columns
- Grouping and Ungrouping Rows and Columns
- Formatting and styling
- Conditional formatting
- Using Themes
- Working with custom named table- or slicer- styles