// Load an IEnumerable of class instances into the worksheet (see the LoadFromCollection method for details). var fullRange = worksheet.Cells["A1"].LoadFromCollection(myCollection, true, OfficeOpenXml.Table.TableStyles.Medium1);; var range = fullRange.SkipRows(1); // remove the headers row //Add a line chart var chart = ws.Drawings.AddLineChart("LineChartWithDroplines", eLineChartType.Line); var serie = chart.Series.Add(range.TakeSingleColumn(1), range.TakeSingleColumn(0));

sheet.Cells["A6"].Formula = $"FILTER(currencyTable[], currencyTable[To Currency]=B3)"; // Dynamic array formulas must always be calculated before saving the workbook. sheet.Calculate(); // or if you only want to calculate this formula: //sheet.Cells["A6"].Calculate(); // The FormulaAddress property contains the range used by the dynamic // array formula after calculation. The variable fr will be used to refer // to address of the dynamic array formulas result range. var fr = sheet.Cells["A6"].FormulaRange; // set date format for the data in column 3 of the dynamic array. // we are using the new TakeSingleColumn function which provides easier // access to entire columns. fr.TakeSingleColumn(2).Style.Numberformat.Format = "yyyy-MM-dd"; // Now let's add a chart for the filtered array var chart = sheet.Drawings.AddLineChart("Dynamic Chart", eLineChartType.Line); chart.Title.LinkedCell = sheet2.Cells["B3"]; var series = chart.Series.Add( fr.TakeSingleColumn(3), fr.TakeSingleColumn(2) );

var tableRange = sheet1.Cells["A1"].LoadFromDataReader(reader, true, "currencyTable", OfficeOpenXml.Table.TableStyles.Medium1); // set date format for the data in column 3. tableRange .SkipRows(1) .TakeSingleColumn(2) .Style.Numberformat.Format = "yyyy-MM-dd";