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]);
}
