Add Slicer in Table

In Spread.Services, you can use slicer in a table by accessing the properties and methods of the ISlicer interface, ISlicerCache interface, and ISlicerCaches interface.

To add slicer in your table, you need to first invoke the Add method of the ISlicerCaches interface to create a new slicer cache for your table.

Refer to the following example code to add slicer in table.

C#	Copy Code
// Defining source data object[,] sourceData = new object[,] { { "Order ID", "Product", "Category", "Amount", "Date", "Country" }, { 1, "Carrots", "Vegetables", 4270, new DateTime(2012, 1, 6), "United States" }, { 2, "Broccoli", "Vegetables", 8239, new DateTime(2012, 1, 7), "United Kingdom" }, { 3, "Banana", "Fruit", 617, new DateTime(2012, 1, 8), "United States" }, { 4, "Banana", "Fruit", 8384, new DateTime(2012, 1, 10), "Canada" }, { 5, "Beans", "Vegetables", 2626, new DateTime(2012, 1, 10), "Germany" }, { 6, "Orange", "Fruit", 3610, new DateTime(2012, 1, 11), "United States" }, { 7, "Broccoli", "Vegetables", 9062, new DateTime(2012, 1, 11), "Australia" }, { 8, "Banana", "Fruit", 6906, new DateTime(2012, 1, 16), "New Zealand" }, { 9, "Apple", "Fruit", 2417, new DateTime(2012, 1, 16), "France" }, { 10, "Apple", "Fruit", 7431, new DateTime(2012, 1, 16), "Canada" }, { 11, "Banana", "Fruit", 8250, new DateTime(2012, 1, 16), "Germany" }, { 12, "Broccoli", "Vegetables", 7012, new DateTime(2012, 1, 18), "United States" }, { 13, "Carrots", "Vegetables", 1903, new DateTime(2012, 1, 20), "Germany" }, { 14, "Broccoli", "Vegetables", 2824, new DateTime(2012, 1, 22), "Canada" }, { 15, "Apple", "Fruit", 6946, new DateTime(2012, 1, 24), "France" }, }; // Initialize the workbook and fetch the default worksheet Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; // Adding data to the table worksheet.Range["A1:F16"].Value = sourceData; ITable table = worksheet.Tables.Add(worksheet.Range["A1:F16"], true); ISlicerCache cache = workbook.SlicerCaches.Add(table, "Category", "categoryCache"); // Add slicer for table ISlicer slicer1 = cache.Slicers.Add(workbook.Worksheets["Sheet1"], "cate1", "Category", 200, 200, 100, 200); ISlicer slicer2 = cache.Slicers.Add(workbook.Worksheets["Sheet1"], "cate2", "Category", 100, 100, 100, 200);

Copy Code

// Defining source data
object[,] sourceData = new object[,] {
    { "Order ID", "Product",  "Category",   "Amount", "Date",                    "Country" },
    { 1,          "Carrots",  "Vegetables",  4270,    new DateTime(2012, 1, 6),  "United States" },
    { 2,          "Broccoli", "Vegetables",  8239,    new DateTime(2012, 1, 7),  "United Kingdom" },
    { 3,          "Banana",   "Fruit",       617,     new DateTime(2012, 1, 8),  "United States" },
    { 4,          "Banana",   "Fruit",       8384,    new DateTime(2012, 1, 10), "Canada" },
    { 5,          "Beans",    "Vegetables",  2626,    new DateTime(2012, 1, 10), "Germany" },
    { 6,          "Orange",   "Fruit",       3610,    new DateTime(2012, 1, 11), "United States" },
    { 7,          "Broccoli", "Vegetables",  9062,    new DateTime(2012, 1, 11), "Australia" },
    { 8,          "Banana",   "Fruit",       6906,    new DateTime(2012, 1, 16), "New Zealand" },
    { 9,          "Apple",    "Fruit",       2417,    new DateTime(2012, 1, 16), "France" },
    { 10,         "Apple",    "Fruit",       7431,    new DateTime(2012, 1, 16), "Canada" },
    { 11,         "Banana",   "Fruit",       8250,    new DateTime(2012, 1, 16), "Germany" },
    { 12,         "Broccoli", "Vegetables",  7012,    new DateTime(2012, 1, 18), "United States" },
    { 13,         "Carrots",  "Vegetables",  1903,    new DateTime(2012, 1, 20), "Germany" },
    { 14,         "Broccoli", "Vegetables",  2824,    new DateTime(2012, 1, 22), "Canada" },
    { 15,         "Apple",    "Fruit",       6946,    new DateTime(2012, 1, 24), "France" },
};
// Initialize the workbook and fetch the default worksheet
Workbook workbook = new Workbook();
IWorksheet worksheet = workbook.Worksheets[0];
// Adding data to the table
worksheet.Range["A1:F16"].Value = sourceData;
ITable table = worksheet.Tables.Add(worksheet.Range["A1:F16"], true);
ISlicerCache cache = workbook.SlicerCaches.Add(table, "Category", "categoryCache");
// Add slicer for table
ISlicer slicer1 = cache.Slicers.Add(workbook.Worksheets["Sheet1"], "cate1", "Category", 200, 200, 100, 200);
ISlicer slicer2 = cache.Slicers.Add(workbook.Worksheets["Sheet1"], "cate2", "Category", 100, 100, 100, 200);