public void SetCurrentSheet(SheetInfo header) { using (Tracer t = new Tracer(myType, "SetCurrentSheet")) { using (new USCulture()) { if (myCurrentSheet != null) { t.Info("Wait until previous sheet data has been written"); myWriter.Close(); t.Info("Wait finished"); myWriter = new AsyncWriter <List <string> >(this.WriteLine); } lock (this) { if (myCurrentSheet != null) { EnableAutoFilter(); } myCurrentSheetInfo = header; myCurrentSheet = AddSheet(header.SheetName); myRowIndex = 1; for (int i = 0; i < header.Columns.Count; i++) { var colum = header.Columns[i]; Range r = GetCell(myCurrentSheet, i, header.HeaderRow); r.Value2 = colum.Name; r.ColumnWidth = colum.Width; } SetHeaderFont(header); } } } }
public static void onSave(WorldSaveEventArgs e) { System.Console.WriteLine("Saving Jailings"); if (!Directory.Exists(jailDirectory)) Directory.CreateDirectory(jailDirectory); GenericWriter idxWriter; GenericWriter binWriter; long tPos; /*if (World.SaveType == 0) { idxWriter = new BinaryFileWriter(idxPath, false); binWriter = new BinaryFileWriter(binPath, true); } else {*/ idxWriter = new AsyncWriter(idxPath, false); binWriter = new AsyncWriter(binPath, true); //} idxWriter.Write((int)m_jailings.Count); try { foreach (JailSystem tJail in m_jailings.Values) { tPos = binWriter.Position; idxWriter.Write((int)0); idxWriter.Write((int)tJail.ID); idxWriter.Write((long)tPos); try { tJail.Serialize((GenericWriter)binWriter); } catch (Exception err) { System.Console.WriteLine("{0}, {1} serialize", err.Message, err.TargetSite); } idxWriter.Write((int)(binWriter.Position - tPos)); } saveingameeditsettings((GenericWriter)binWriter); } catch (Exception er) { System.Console.WriteLine("{0}, {1}", er.Message, er.TargetSite); } finally { } idxWriter.Close(); binWriter.Close(); System.Console.WriteLine("Jailings Saved"); }