public void WriteToTxtFile(ValuesDynamicDictionary cache, FileHeaderInfo fileHeader, List <Dictionary <string, Value> > formulas) { string completePath = FilePath + Program.OutputTxtFileName; string[] rowHeadline = new string[fileHeader.ColumnsUsed.Count + formulas[0].Keys.Count + 1]; //1. a) merge the headline from raw cache and formulas cache into a single array int invariant = 0; while (invariant < fileHeader.ColumnsUsed.Count + formulas[0].Keys.Count) { rowHeadline[invariant] = "AsOfDate"; invariant++; for (int i = 0; i < fileHeader.ColumnsUsed.Count; i++) { rowHeadline[invariant] = EQRMSRawColumns.ProcessedColumnIntAsKey[fileHeader.ColumnsUsed[i]]; ++invariant; } for (int i = 0; i < formulas[0].Count; i++) { var lol = formulas.First().Keys; rowHeadline[invariant] = lol.ElementAt(i); ++invariant; } } File.AppendAllText(completePath, string.Join("\t", rowHeadline) + "\n"); int rowsIndex = 0; while (rowsIndex < cache.Count()) { int columnIndex = 0; string[] row = new string[cache.ValuesUnbound.Count + formulas[0].Count + 1]; row[columnIndex] = fileHeader.AsOfDate.ToString(); columnIndex++; for (int i = 0; i < fileHeader.ColumnsUsed.Count; i++) { row[columnIndex] = cache.GetValue(fileHeader.ColumnsUsed[i], rowsIndex).ToString(); ++columnIndex; } for (int i = 0; i < formulas[rowsIndex].Count; i++) { row[columnIndex] = formulas[rowsIndex].Values.ElementAt(i).ToString(); ++columnIndex; } ++rowsIndex; File.AppendAllText(completePath, string.Join("\t", row) + "\n"); //File.AppendText(FilePath).WriteLine(string.Join("\t", row)); } }
public List <Dictionary <string, Value> > FormulasCalculateSingleFile(ValuesDynamicDictionary cache) { List <Dictionary <string, Value> > ret = new List <Dictionary <string, Value> >(); //Parallel.ForEach(cache.ValuesUnbound, e => //{ // ret.Add(FormulasCalculateOneRow(i, cache)); //}); for (int i = 0; i < cache.Count(); i++) { ret.Add(FormulasCalculateOneRow(i, cache)); } return(ret); }
public void WriteToExcel(ValuesDynamicDictionary cache, FileHeaderInfo fileHeader, List <Dictionary <string, Value> > formulas) { //1. Column headline Console.WriteLine(cache.Count()); string[] rowHeadline = new string[fileHeader.ColumnsUsed.Count + formulas[0].Keys.Count]; int maxLen = fileHeader.ColumnsUsed.Count + formulas[0].Keys.Count; int tabOneRowCounter = NumberOfRows(FirstTab); //1. a) merge the headline from raw cache and formulas cache into a single array int invariant = 0; while (invariant < maxLen) { for (int i = 0; i < fileHeader.ColumnsUsed.Count; i++) { rowHeadline[invariant] = EQRMSRawColumns.ProcessedColumnIntAsKey[fileHeader.ColumnsUsed[i]]; ++invariant; } for (int i = 0; i < formulas[0].Count; i++) { var lol = formulas.First().Keys; rowHeadline[invariant] = lol.ElementAt(i); ++invariant; } } //1. b) write the headline Excel.Range h1 = FirstTab.Cells[tabOneRowCounter, 1]; Excel.Range h2 = FirstTab.Cells[tabOneRowCounter, rowHeadline.Length]; Excel.Range headerRange = FirstTab.get_Range(h1, h2); headerRange.Value2 = rowHeadline; tabOneRowCounter++; //2. a) merge two caches row at a time int rowsIndex = 0; while (rowsIndex < cache.Count()) { int columnIndex = 0; string[] row = new string[cache.ValuesUnbound.Count + formulas[0].Count]; //Raw extracted data for (int i = 0; i < fileHeader.ColumnsUsed.Count; i++) { row[columnIndex] = cache.GetValue(fileHeader.ColumnsUsed[i], rowsIndex).ToString(); ++columnIndex; } //Our re-calculated formulas using Antlr for (int i = 0; i < formulas[rowsIndex].Count; i++) { row[columnIndex] = formulas[rowsIndex].Values.ElementAt(i).ToString(); ++columnIndex; } ++rowsIndex; //2b) Write the row Excel.Range c1 = FirstTab.Cells[tabOneRowCounter, 1]; Excel.Range c2 = FirstTab.Cells[tabOneRowCounter, row.Length]; Excel.Range firstTabRangeFormula = FirstTab.get_Range(c1, c2); firstTabRangeFormula.Value2 = row; ++tabOneRowCounter; } }