I essentially would like users to paste in their data to a RadSpreadsheet and then click a button. Once Clicked I can process the data and save the data to a database.  However, I would also like to manipulate the spreadsheet and rename the columns from ABC to a heading I choose.

Can you point me on how to change the column headings?

Can you point me into how to process the pasted data into a datatable or object when a button is clicked on the page?

Thanks!

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.