React Working with Sparklines
The Infragistics React Excel Library has support for adding sparklines to an Excel Worksheet. These can be used to show simple visual representations of data trends across a region of cells of data in your worksheet. For example, if you wanted to see your Excel data across a particular cell region visualized as a simple column or line sparkline chart, this feature can help you to achieve that.
React Working with Sparklines Example
Supported Sparklines
Veja a seguir uma lista dos tipos de minigráficos predefinidos com suporte.
- Linha
- Coluna
- Empilhado (Vitória/Perda)
O código a seguir demonstra como adicionar minigráficos programaticamente a uma planilha por meio da coleção sparklineGroups:
var workbook: Workbook;
var sheet1 = workbook.worksheets().add("Sparklines");
var sheet2 = workbook.worksheets().add("Data");
sheet1.sparklineGroups().add(SparklineType.Line, "Sparklines!A1:A1", "Data!A2:A11");
sheet1.sparklineGroups().add(SparklineType.Column, "Sparklines!B1:B1", "Data!A2:A11");
workbook.save(workbook, "Sparklines.xlsx");