What I am trying to do with the following code snippet is convert an xml string into a string with an xls format. The output gets downloaded as a .xls file. when the resultant .xls file is opened it says the file format and extension don't match. How do I get the string into an xls format?
// convert bytes to a string so we can insert worksheet data.
var spreadSheetTemplate = System.Text.Encoding.UTF8.GetString(rawSpreadsheet);
// create a worksheet on which to manage fields.
var spreadSheet = spreadSheetTemplate.Replace("<Worksheets/>", results.ToString());
// convert string to memory stream
MemoryStream msSpreadSheet = new MemoryStream(Encoding.UTF8.GetBytes(spreadSheet));
// open msSpreadSheet into the excel engine and at the same time convert it to .xls format (I think)
var excelEngine = new ExcelEngine().Excel.Workbooks.OpenFromXml(msSpreadSheet, ExcelXmlOpenType.MSExcel);
// store the content of the engine which should (I think) now be in .xls format back into a string
spreadSheet = excelEngine.ToString();
//var spreadSheet = new ExcelEngine().Excel.Workbooks.OpenFromXml(new MemoryStream(Encoding.UTF8.GetBytes(spreadSheetTemplate.Replace("<Worksheets/>", results.ToString()))), ExcelXmlOpenType.MSExcel).ToString();
return Encoding.UTF8.GetBytes(spreadSheet);
