# Remote Loading and Saving of Excel Develop powerful and lightweight web applications using ASP.NET MVC controls. Learn more about the ComponentOne MVC controls in ASP.NET MVC documentation. ## Content FlexSheet allows you to remotely load and save excel file using C1JSONRequest. This specifies remote URLs to load data from excel file or workbook in FlexSheet control, and save FlexSheet data to server as Excel file or workbook through action. The below example loads an excel file, placed on server, in FlexSheet using **Load** method of FlexSheetHelper class. >type=note > Note that FlexSheet requires **jszip.min.js** file for remote loading and saving of excel. Therefore, you need to add this file to your application and provide reference to it in the respective view or in \ section of \_Layout.cshtml file. The following code examples demonstrate how to remotely load data from excel file or workbook in FlexSheet control: #### In Code Include the MVC references as shown below. ```csharp using C1.Web.Mvc.Sheet; using System; using System.Collections; using System.Globalization; using System.Linq; using System.Web; using System.Web.Mvc; using System.Collections.Generic; using C1.Web.Mvc.Serializition; ``` **RemoteLoadController.cs** ```csharp public class RemoteController : Controller { // GET: // public ActionResult Index() { return View(); } public ActionResult RemoteLoadXlsx() { return this.C1Json(FlexSheetHelper.Load("~/Content/ExcelFiles/WorkBook.xlsx"), null, null, JsonRequestBehavior.AllowGet); } } ``` Here, the Excel workbook that is loaded remotely is placed in Content folder of the application. **RemoteLoading.cshtml** ```razor @using C1.Web.Mvc.Sheet;

@(Html.C1().FlexSheet().CssClass("flexSheet").Height(700).Width(700) .RemoteLoad(Url.Action("RemoteLoadXlsx")) )

``` ### Remote Save #### In Code **RemoteSaveController.cs** ```csharp public class RemoteSaveController : Controller { // GET: // public static List SALES = Sale.GetData(50).ToList(); public ActionResult Index() { return View(SALES); } private const string FILE_PATH = "\\wwwroot\\uploadFile\\save.xlsx"; public JsonResult RemoteSaveFile([FlexSheetRequest]FlexSheetSaveRequest request) { var success = true; var error = ""; var app = GetService(); var savePath = app.ApplicationBasePath + FILE_PATH; try { Stream st = request.GetFileStream(); using (FileStream fs = new FileStream(savePath, FileMode.Create)) { if (st != null) { st.CopyTo(fs); } } } catch (Exception e) { success = false; error = e.ToString(); } return this.C1Json(FlexSheetHelper.Save(success, error)); } public FileResult DownloadFile() { var app = GetService(); var savePath = app.ApplicationBasePath + FILE_PATH; var name = Path.GetFileName(FILE_PATH); return File(new FileStream(savePath, FileMode.Open, FileAccess.Read), "application/msexcel", name); } public static T GetService() where T : class { var serviceProvider = CallContextServiceLocator.Locator.ServiceProvider; return serviceProvider.GetService(typeof(T)) as T; } } ``` **RemoteSaving.cshtml** ```razor @using C1MvcFSheetNew.Models; @model IEnumerable

@(Html.C1().FlexSheet().CssClass("flexSheet").Width("500px").Height("700px").RemoteSave(Url.Action("RemoteSaveFile")) .OnClientRemoteSaved("onFileSaved") .AddBoundSheet(sheet => sheet.Bind(cv => cv.Bind(Model))) )

``` ## See Also [Quick Start](/componentone/docs/mvc/online-mvc/workwithcontrols/FlexSheet/FlexSheetQuickStart) **Reference** [FlexSheet Class](/componentone/api/mvc/online-mvc/dotnet-framework-api/C1.Web.Mvc.FlexSheet/C1.Web.Mvc.Sheet.FlexSheet.html) [BoundSheet Class](/componentone/api/mvc/online-mvc/dotnet-framework-api/C1.Web.Mvc.FlexSheet/C1.Web.Mvc.Sheet.BoundSheet-1.html)