public void ProcessSpreadsheetLoad(Byte[] b, string[] s) { MemoryStream stream = new MemoryStream(b); StreamReader reader = new StreamReader(stream); Dictionary <string, string> spreadsheetData = new Dictionary <string, string>(); string[] str; // Begin reading the data stream using (reader) { try { // Get the json data for the whole spreadsheet file string jsonString = reader.ReadLine(); //int begin = jsonString.IndexOf('0'); int end = jsonString.IndexOf('}'); string actual = jsonString.Substring(2, end); string[] bits = actual.Split(','); string[] cells; string cellName; string contents; foreach (string cell in bits) { cells = cell.Split(':'); cellName = cells[0].Replace('\"', ' ').Trim(); contents = cells[1].Replace('\"', ' ').Trim(); ss.SetContentsOfCell(cellName, contents); } } catch (Exception) {} } // Iterate through the deserialized JsonString data and // set the data appropriately within the representation of the // spreadsheet within the form. foreach (string cell in spreadsheetData.Keys) { if (cell.Equals("version")) { ss.SetVersion(spreadsheetData[cell]); } else { ss.SetContentsOfCell(cell, spreadsheetData[cell]); } } }