Spreadsheet break on export

[Leonardo Jacques da Silva]

Hi, I tried to export data, based on query sql server by data table. But I need to put Spreadsheet break, separate by two field, e.g.

In my retur from banck:

PkId NfeId NfeItemId nItem cProd cEAN xProd nCM cEST

78313 21239FF3-5262-4344-AEF6-774092988F42 2A04F1BB-9EA3-4E06-9F82-BB86DAE493AA 1 700938 7891000062784 NAN 1 PRO F.I NESTLE 800G 04022110 1701200

Combining Fields: (nCM+ cEST)

It is possible when values changed it create new Spreadsheet ?

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Leonardo, 

Greetings from Syncfusion. 

We have forwarded the query to concerned team for investigation. We will share further details on December 17^th,2020. 

Regards, 

Keerthi. 

[Arulpriya Ramalingam]

Hi Leonardo,

Thank you for your patience.

A new worksheet can be added when cell value changed using the CurrentCellValueChanged event. Please make use of the below code example for further details.

Example code

//Event subscription

this.spreadsheetControl.ActiveGrid.CurrentCellValueChanged += ActiveGrid_CurrentCellValueChanged;

private void ActiveGrid_CurrentCellValueChanged(object sender, Syncfusion.UI.Xaml.CellGrid.Helpers.CurrentCellValueChangedEventArgs e)

{

    //To add sheet at run time.

    spreadsheetControl.AddSheet("sheetname", 2);

}

Please get back to us if you need any further assistance.

Regards,

Arulpriya