Getting values entered in cells from the server side

[NMA]

Hello,

I placed a RadSpreadsheet object in anaspx page as follows:

<telerik:RadSpreadsheet runat="server" ID="rssMain" Skin="Bootstrap" ColumnsCount="10">
    <Toolbar>
        <telerik:SpreadsheetToolbarTab Text="Test"></telerik:SpreadsheetToolbarTab>
    </Toolbar>
</telerik:RadSpreadsheet>

All I want to do is to collect what the user typed in several cells when the submit button on the same page is clicked. I should be able to access those values by traversing through rows and cells of the spreadsheet but the values cannot be accessed as expected.

Please note that I am not using any data source or whatsoever (no data binding). Just a blank spreadsheet to get user typed values on postback.

[Nencho]

Hi,

The reason for the inability to acquire the data at the page code behind is the fact that the RadSpreadsheet does not have ViewState. Due to this, data manipulations at the code behind are applicable only in a ReadOnly scenario.

In order to be able to access the newly filled data, you need to implement the CustomProvider and handle the overwritten SaveWorkbook method. Please refer to the following documentation article, describing in details the implementation of the CustomProvider:

http://docs.telerik.com/devtools/aspnet-ajax/controls/spreadsheet/data-binding/providers/custom-database-provider

Once the Save button from the toolbar is clicked, the SaveWorkbook method in the CustomProvider will be triggered and the newly data will be accessible.

Regards,
Nencho
Telerik

[NMA]

Is there a way to trigger click for the save button in the toolbar? Because I want to hide all buttons in the toolbar and as far as I understand, the save button should be clicked to preserve values before the postback.

[Nencho]

Hello Nurretin,

Yes, you need to invoke the Save, in order to trigger the method in the mentioned CustomProvider. You can use the Client Api of the control in the following manner:

Copy Code

var spread = $find("RadSpreadsheet1");
spread.save()

The above will trigger a call to the SaveWorkbook method in your Custom Provider.

In addition, I would like to ask you to continue the correspondence in the Support ticket that you have submitted, in order to avoid any further duplication.

Thank you in advance.

Regards,
Nencho
Telerik

[Padmaraj]

Hi,

var spreadsheet = $find("RadSpreadsheet1");
spreadsheet.save();

I'm save event of spreadsheet from client side using following code above, but my custom provider SaveWorkBook is not getting called instead getting error as :

The type initializer for 'Telerik.Web.Spreadsheet.Workbook' threw an exception.

Is there any configuration settings to be done in web.config file.