I have a datatable in memory that I would like to display in a telerik:RadSpreadsheet. I know I can iterate through the datatable and build a sheet to display. 

I'm trying to figure out how to use the DataTableFormatProvider to load the datatable in one shot. I found examples of how to do with the Telerik.Windows.Documents spreadsheet, but how do I do  it with the RadSpreadsheet model?

I just updated to ASP>NET AJAX 2024 Q4 and I get an error in the following code...

string fileName = "SampleFile.xlsx"; 
 
IWorkbookFormatProvider formatProvider = new XlsxFormatProvider(); 
 
using (Stream output = new FileStream(fileName, FileMode.Create)) 
{ 
    formatProvider.Export(workbook, output); 
} 

'formatProvider.Export(workbook, output);' is looking for an additional parameter now 'TimeSpan? timeout'.

I took a guess and entered null and it seems to work.
What are the options for this new parameter?

Hi,

Is it possible to add cell comments?  This is helpful to give users understanding of the cell values.

Thanks,

Tim

I'm using the RadSpreadsheet component and saving it's content following this instructions here:

Telerik RadControls Access the Spreadsheet workbook on the server - Telerik UI for ASP.NET AJAX

So, my code behind is like this:

protected void Page_Load(object sender, EventArgs e)
{
    if (Page.IsCallback && Request.Params["__CALLBACKID"] == RadSpreadsheet1.UniqueID)
    {
        Workbook workbook = Telerik.Web.Spreadsheet.Workbook.FromJson(Request.Params["__CALLBACKPARAM"]);
        SaveWorkBook(workbook);
    }

}

With this code I'm able to save the spreadsheet just fine. But it's not saving the images I add using the Insert Image button (from telerik component). The images are simply not being passed through.

How can I work around that? Thank you!

I love the RadSpreadsheet control.  It works great having the toolbar to open files, save files etc.

But I want to run some code on a button press on the page that does some specific validation, then 

taking each row and import into a database.

So I use this control to open xls files for user to view, make changes etc.

I then run some custom code that checks (Rows / Columns data) for custom rules

Then I want to take the end result and import that into a database.

Should I be using a Grid Control to do this as it seems impossible to get the worksheet from the RadSpreadSheet control when we use the open toolbar.

I need to import a spreadsheet into a dataset. The spreadsheets have rows and columns of data, but some of the columns are totaled at the bottom. I think this is giving me error when trying to use the DataTableFormatProvider.Export.

So I want to open the file and read the cells row by row. Are there any examples on how to open a spreadsheet and walk through it row by row?

Does the functionality exist to format a range of cells as a table like can be done in Excel?

I use the data provider to read the format of an existing Excel file.

But, a range of cells formatted as a table is not copied into the RadSpreadsheet.

Is there a purpose of the Save Icon on the Home tab toolbar?

I would like to capture some kind of event when a user clicks this icon to direct it to my SaveWorkbook method override in my custom provider.

But, I don't see any such method implemented that can override.

If no ability exists to do this, why then is the icon even there?