public static void WritePeople() { var workbook = new XLWorkbook(); var worksheet = workbook.Worksheets.Add("Хора"); for (int i = 0; i < Opinion.allOpinions.Count; i++) { Opinion o = Opinion.allOpinions[i]; int rowIdx = i + 2; worksheet.Cell(f("A", rowIdx)).Value = o.age; worksheet.Cell(f("B", rowIdx)).Value = o.freq.freq; worksheet.Cell(f("C", rowIdx)).Value = lookup[(int)o.freq.type]; } workbook.SaveAs("ало-ало.xlsx"); }
public static void WriteOpinion(Opinion op, StreamWriter writer) { WritePerson(op, writer); op.opinions.ForEach(b => WriteBeachOpinion(b, writer)); }
/* Формат: * [възраст] [честота] [честота - код: 0 - седмица, 1 - месец, 2 - година] */ private static void WritePerson(Opinion po, StreamWriter writer) { String data = String.Format("{0} {1} {2}\n", po.age, po.freq.freq, po.freq.type); writer.Write(data); }
private static void ReadPerson(String line) { String[] data = line.Split(' '); Opinion o = new Opinion(); o.age = int.Parse(data[0]); o.freq = new Frequency(); o.freq.freq = int.Parse(data[1]); if (data[2][0] == 'W') o.freq.type = FType.Weekly; else if (data[2][0] == 'M') o.freq.type = FType.Monthly; else if (data[2][0] == 'Y') o.freq.type = FType.Yearly; Opinion.allOpinions.Add(o); }
private void ReadPerson() { try { activeOp.age = int.Parse(tbAge.Text); activeOp.freq = new Frequency(); activeOp.freq.freq = int.Parse(tbFreq.Text); if (rbWeekly.Checked) activeOp.freq.type = FType.Weekly; else if (rbMonthly.Checked) activeOp.freq.type = FType.Monthly; else if (rbYearly.Checked) activeOp.freq.type = FType.Yearly; Opinion.allOpinions.Add(activeOp); activeOp = new Opinion(); ClearPerson(); } catch (Exception e) { MessageBox.Show(e.Message, e.GetType().ToString()); } }