I'm using the ejSpreadsheet widget to allow users to review excel files.
The Excel files are uploaded by the user to the server and then processed with Syncfusion.EJ.Export to give the data, in JSON format, to the ejSpreadsheet client widget.
The issue is that I've discovered is that the JSON data sent to the client, representing the excel file, is more than 100x times bigger than the Excel files!!
A 200KB Excel file is converted into a 21MB JSON file
A 340KB Excel file is converted into a 40MB JSON file!
The content of both examples is simply tabular data, no chart, no formula, no macro, nothing... they could be simply converted to CSV format.
The code I'm using to convert Excel to JSON to send to the client widget is the following:
using System;
using System.Web;
using System.IO;
using Syncfusion.XlsIO;
using Syncfusion.EJ.Export;
using Syncfusion.JavaScript.Models;
public class GetExcelSpreadsheet : IHttpHandler {
public void ProcessRequest(HttpContext context)
{
var filePath =HttpContext.Current.Server.MapPath("\\Uploads") + "\\Temp\\" + context.Request.Form["filename"].ToString();
ImportRequest importRequest = new ImportRequest();
Stream fileStream = File.Open(filePath, FileMode.Open, System.IO.FileAccess.Read);
importRequest.FileStream = fileStream;
importRequest.File = null;
string str = Spreadsheet.Open(importRequest);
fileStream.Close();
fileStream.Dispose();
context.Response.Write(str);
}
public bool IsReusable {
get {
return false;
}
}
}
I hope I'm doing something wrong otherwise the component is not usable on the web!
Best,
Marco
