public void SaveToStream(Stream stream) { CompoundDocument doc = CompoundDocument.CreateFromStream(stream); MemoryStream mstream = new MemoryStream(); WorkbookEncoder.Encode(this, mstream); doc.WriteStreamData(new string[] { "Workbook" }, mstream.ToArray()); doc.Save(); }
public void Save(string file) { CompoundDocument doc = CompoundDocument.Create(file); MemoryStream stream = new MemoryStream(); WorkbookEncoder.Encode(this, stream); doc.WriteStreamData(new string[] { "Workbook" }, stream.ToArray()); doc.Save(); doc.Close(); }
/// <summary> /// Save workbook to a file. /// </summary> /// <param name="file"></param> public void Save(string file) { using (CompoundDocument doc = CompoundDocument.Create(file)) { using (MemoryStream memStream = new MemoryStream()) { WorkbookEncoder.Encode(this, memStream); doc.WriteStreamData(new string[] { "Workbook" }, memStream.ToArray()); doc.Save(); } } }
public void Save(Stream s) { BinaryWriter bw = new BinaryWriter(s); //Writing Column Naow int TotalRows = this.Worksheets[0].Cells.LastRowIndex; for (int i = TotalRows + 1; i < TotalRows + 50; i++) { for (int ColumnCount = 0; ColumnCount < 5; ColumnCount++) { this.Worksheets[0].Cells[i, ColumnCount] = new Cell(""); } } CompoundDocument doc = CompoundDocument.Create(s, bw); MemoryStream stream = new MemoryStream(); WorkbookEncoder.Encode(this, stream); doc.WriteStreamData(new string[] { "Workbook" }, stream.ToArray()); doc.Save(); doc.Close(); }