Pending Review
Last Updated: 07 Aug 2017 09:59 by ADMIN
Tom
Created on: 10 Mar 2016 15:43
Category: Spreadsheet
Type: Feature Request
3
Spreadsheet: Save/Data Options
1. Save Excel workbook to folder on server (the Excel file can be re-purposed in many ways)
2. Better ways to send sheet data back to controller ... more JSON serialization options, csv, etc.
3 comments
ADMIN
Petyo
Posted on: 09 May 2016 17:20
Thanks for the suggestions, Tom.

Note that server export is supported by the spreadsheet as illustrated in this demo: 
http://demos.telerik.com/kendo-ui/spreadsheet/server-side-import-export

You can learn more about the spread processing capabilities using the RadSpreadProcessing library from this doc:
http://docs.telerik.com/kendo-ui/aspnet-mvc/helpers/spreadsheet/spreadsheet-processing
ADMIN
Telerik Admin
Posted on: 11 Mar 2016 09:08
If you experience issues with processing Excel export server-side with the RadSpreadProcessing engine, please contact our support team at telerik.com to get appropriate assistance. Thank you for your understanding, Tom.
Tom
Posted on: 10 Mar 2016 16:12
Thanks for the reply and apologies - I was not clear on this.

1. I've looked over @http://demos.telerik.com/kendo-ui/spreadsheet/server-side-import-export and it works if you're an end user. I want to be able to programmatically save Excel to a folder on server (e.g. ~/App_Data) in my controller. One of my goals here would be to send that saved Excel file from the server to different folks or processes. 

2. I've also looked @ http://docs.telerik.com/kendo-ui/aspnet-mvc/helpers/spreadsheet/spreadsheet-processing and it does not work for me (console logs, breakpoints, shows nothing). Here is my code:

$("#save").click(function () {
        var spreadsheet = $("#ks_spreadsheet").data("kendoSpreadsheet");
        
        $.ajax({
            url: "@Url.Action("PostDealClientData", "DealClientKS")",
            data: JSON.stringify(spreadsheet.toJSON()),
            contentType: "application/json",
            type: "POST"
        });
    });

[HttpPost]
        public ActionResult PostDealClientData(Telerik.Web.Spreadsheet.Workbook workbook)
        {
            var savePath = Server.MapPath("~/ExcelSave/DealClient.xlsx");
            workbook.Save("~/ExcelSave/Workbook.xlsx");

            return new EmptyResult();
        }