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;
}
}
