public ActionResult Excel(string json) { List <ExcelTemplate> data = JsonConvert.DeserializeObject <List <ExcelTemplate> >(json); DataSet dataSet = Util.ToDataSet(data); ExcelCreator excelCreator = new ExcelCreator(); return(File(excelCreator.Create(dataSet), "application/vnd.ms-excel", "kartexport.xls")); }
public void Test_Create_Should_Create_ExcelFile() { List <TestExcelObject> testExcelObjects = new List <TestExcelObject> { new TestExcelObject("name1", 1), new TestExcelObject("name2", 2) }; List <string> columnNames = new List <string> { "name", "value" }; string sheetName = "sheetName"; IExcelFile excelFile = _excelCreator.Create(testExcelObjects, sheetName, columnNames); Assert.IsNotNull(excelFile); }
public string Excel([System.Web.Http.FromBody] UploadData uploadData) { List <ExcelTemplate> data = JsonConvert.DeserializeObject <List <ExcelTemplate> >(uploadData.data); DataSet dataSet = Util.ToDataSet(data); ExcelCreator excelCreator = new ExcelCreator(); byte[] bytes = excelCreator.Create(dataSet); string[] fileInfo = byteArrayToFileInfo(bytes, "xls"); return(Request.Url.GetLeftPart(UriPartial.Authority) + "/Temp/" + fileInfo[1]); }
private string GenExcel(string name, List <ExcelTemplate> xls) { try { System.Data.DataSet dataSet = Util.ToDataSet(xls); ExcelCreator excelCreator = new ExcelCreator(); byte[] bytes = excelCreator.Create(dataSet); string[] fileInfo = byteArrayToFileInfo(name, bytes, "xls"); return(Request.Url.GetLeftPart(UriPartial.Authority) + "/Temp/" + fileInfo[1]); } catch (Exception e) { _log.FatalFormat("Can't generate excel file: {0}", e); throw e; } }
public string Excel(string json) { _log.DebugFormat("Received json: {0}", json); // try to decode input string to see if it is base64 encoded try { byte[] decoded = Convert.FromBase64String(json); json = System.Text.Encoding.UTF8.GetString(decoded); _log.DebugFormat("json after decode: {0}", json); } catch (Exception e) { _log.DebugFormat("Could not decode base64. Will treat as non-base64 encoded: {0}", e.Message); } List <ExcelTemplate> data = JsonConvert.DeserializeObject <List <ExcelTemplate> >(json); DataSet dataSet = Util.ToDataSet(data); ExcelCreator excelCreator = new ExcelCreator(); byte[] bytes = excelCreator.Create(dataSet); string[] fileInfo = byteArrayToFileInfo(bytes, "xls"); return(Request.Url.GetLeftPart(UriPartial.Authority) + "/Temp/" + fileInfo[1]); }