public SpreadsheetInfoContainer(FileInfo configurationFile)
{
StreamReader reader = new StreamReader(configurationFile.ToString());
ushort lineNum = 0;
while (!reader.EndOfStream)
{
string line = reader.ReadLine();
if (line.StartsWith("#"))
{
continue;
}
else
{
line = line.Trim();
lineNum++;
if (lineNum == 1)
{
dataHeadingLine = ushort.Parse(line);
}
else if (lineNum == 2)
{
dataStartLine = ushort.Parse(line);
}
else if (lineNum > 2 && lineNum < 29)
{
string letter = line.Split(',')[1].Trim();
ExcelCellAddress addr = new ExcelCellAddress(letter + dataStartLine);
ushort column = (ushort)addr.Column;
columnNumbers.Add((ColumnType)lineNum - 3, column);
}
else if (lineNum >= 29)
{
if (line.Trim() == "")
{
continue;
}
string accName = line.Split(',')[0].Trim();
string accIdentifier = line.Split(',')[1].Trim();
accounts.Add(accName, accIdentifier);
}
}
}
instance = this;
}
public MTFileHandler(FileInfo fileInfo, string worksheetName)
{
//ExcelPackage ep = new ExcelPackage(new FileInfo(Directory.GetCurrentDirectory() + Path.DirectorySeparatorChar + "lol.xlsx"));
//ep.Workbook.Worksheets.Add("lol");
//ep.Workbook.Worksheets["lol"].Cells[1, 1].AddComment("Hello", "Me");
//ep.Save();
package = new ExcelPackage(fileInfo);
ExcelWorkbook workbook = package.Workbook;
if (workbook.Worksheets[worksheetName] == null)
{
TemplateHandler th = new TemplateHandler();
moneySpreadsheet = th.CreateAWorksheetFromTemplate(workbook, worksheetName);
//FileInfo templatesFile = new FileInfo(Directory.GetCurrentDirectory() + Path.DirectorySeparatorChar +
// "Templates" + Path.DirectorySeparatorChar + "MTTemplate.xlsx");
//ExcelPackage copyPackage = new ExcelPackage(templatesFile);
//moneySpreadsheet = workbook.Worksheets.Add("2018xb", copyPackage.Workbook.Worksheets[1]);
if (!Directory.Exists(package.File.Directory.FullName))
{
Directory.CreateDirectory(package.File.Directory.FullName);
}
if (!File.Exists(package.File.FullName))
{
package.SaveAs(package.File);
}
}
else
{
moneySpreadsheet = workbook.Worksheets[worksheetName];
}
interactor = new MTSpreadsheetInteractor(moneySpreadsheet, this);
infoContainer = new SpreadsheetInfoContainer(new FileInfo(Directory.GetCurrentDirectory() + Path.DirectorySeparatorChar + "MTConfig.txt"));
}