AUTHOR: Peter Milchev
DATE POSTED: June 11, 2019
Use SpreadsheetDocumentProvider inside custom provider to Save/Load Excel files and have control over the data.
To load the data from a file, we can leverage the Server.MapPath to get the real path to the file. Then we pass it as a parameter to the constructor of our Custom Provider.
Default.aspx
<
telerik:RadSpreadsheet
runat
=
"server"
ID
"RadSpreadsheet1"
></
>
Default.aspx.cs - Code behind
protected
void
Page_Init(
object
sender, EventArgs e)
{
var path = Server.MapPath(
"~/App_Data/spreadsheet.xlsx"
);
// default Load/Save from Excel file
//SpreadsheetDocumentProvider provider = new SpreadsheetDocumentProvider(path);
// Custom provider that allows additional manipulation of data before/after Save/Load from Excel file
// Passing the path to the custom provider, so that we can leverage the Server.MapPath method
SpreadsheetCustomExcelProvider provider =
new
SpreadsheetCustomExcelProvider(path);
RadSpreadsheet1.Provider = provider;
}
SpreadsheetCustomExcelProvider.cs - Custom Provider
public
class
SpreadsheetCustomExcelProvider : SpreadsheetProviderBase
string
Path {
get
;
set
; }
SpreadsheetCustomExcelProvider(
path)
:
base
()
Path = path;
override
SaveWorkbook(Workbook workbook)
SpreadsheetDocumentProvider provider =
SpreadsheetDocumentProvider(Path);
// modify data before save
provider.SaveWorkbook(workbook);
List<Worksheet> GetSheets()
var sheets = provider.GetSheets();
// modify data before display
return
sheets;
Resources Buy Try