ASP.NET Core MVC Controls | ComponentOne
Working with Controls / FlexSheet / Work with FlexSheet / Client-side Loading and Saving of Excel
In This Topic
    Client-side Loading and Saving of Excel
    In This Topic

    FlexSheet supports loading data in it from an Excel file or workbook provided by client. Moreover, it allows saving the data in FlexSheet to Excel file or workbook on client-side.

    The following code examples demonstrate how to enable client loading of excel in FlexSheet. In the below example, client loading of excel occurs on button click. Load method is called when a user clicks on the button to load excel data in FlexSheet.

    Note that FlexSheet requires jszip.min.js file for loading and saving of excel on the client side. Therefore, you need to add this file to your application and provide reference to it in the respective view or in <head> section of _Layout.cshtml file.

    ClientLoadController.cs 

    C#
    Copy Code
    public class ClientLoadController : Controller
    {
        // GET: /<controller>/        
        public ActionResult Index()
        {
            return View();
        }
    }
    


    ClientLoad.cshtml

    HTML
    Copy Code
    <script>
        function load() {
            var flex = wijmo.Control.getControl("#clientLoadSheet");
            var fileInput = wijmo.getElement('#importFile');
            if (flex && fileInput.files[0]) {
                flex.load(fileInput.files[0]);
            }
        }
    </script>
    
    <div>
        <input type="file" class="form-control" id="importFile" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" />
        <button class="btn btn-default" onclick="load()">Load</button>
        <br /><br />
        <c1-flex-sheet class="flexSheet" id="clientLoadSheet" selected-sheet-index="0" width="500px" height="700px">
            <c1-unbound-sheet column-count="8" row-count="20" name="Unbound"></c1-unbound-sheet>
        </c1-flex-sheet>
    </div>
    

    Back to Top

    Saving FlexSheet Data to Excel File on Client-side

    Saving the FlexSheet data to an Excel file or workbook is also supported on the client side. This can be accomplished through save method. The following code examples demonstrate how to enable saving FlexSheet data to Excel file on the client side. In the below example save method is invoked on button click. 

    In Code

    ClientSaveController.cs 

    C#
    Copy Code
    public class ClientSaveController : Controller
    {        
        // GET: /<controller>/
        public static List<Sale> SALES = Sale.GetData(50).ToList();
        public ActionResult Index()
        {
            return View(SALES);
        }
    

    ClientSaving.cshtml

    HTML
    Copy Code
    @using C1MvcFSheetNew.Models;
    @model IEnumerable<sale>
    
        <script>
            function save() {
                var flex = wijmo.Control.getControl("#clientSaveSheet");
                var fileNameInput = wijmo.getElement("#fileName");
                var fileName = 'FlexSheet.xlsx';
                flex.save(fileName);
            }
    
    
        </script>
    
        <div>
            <button class="btn btn-default" onclick="save()">Save</button>
            <br /><br />
            <c1-flex-sheet class="flexSheet" id="clientSaveSheet" selected-sheet-index="0" width="500px" height="700px">
                <c1-bound-sheet>
                    <c1-items-source source-collection="Model"></c1-items-source>
                </c1-bound-sheet>
                <c1-unbound-sheet column-count="8" row-count="20" name="Unbound"></c1-unbound-sheet>
            </c1-flex-sheet>
        </div>
    

    Back to Top

    See Also