public bool UseCsvFileAnalyzer()
{
// 1. Creation Management
Cfa = new CsvFileAnalyzer();
Cfa.FilePath = FilePath;
Cfa.Delimiters = new char[] { '\t' };
CsvFileStructure Cfs = new CsvFileStructure();
Cfs.HeaderLineStartAt = 1;
Cfs.DataLinesStartAt = 2;
Cfs.FooterLinesCount = 0;
Dal = new Dal_EuroStatFrench();
DatalineEntityAndFormat Def = new DatalineEntityAndFormat();
// 2. Dependency Management
Cfa.Cfs = Cfs;
Dal.Def = Def;
Cfa.Dal = Dal;
// 3. Read Csv File
bool result = Cfa.ReadCsvFile();
// 4. Store as Excel
Efa_Dic_StringList_DoubleList_Fpi Ea = new Efa_Dic_StringList_DoubleList_Fpi();
Ea.FilePath = AppDomain.CurrentDomain.BaseDirectory
+ "Result\\Result_Summary\\" + "Result_Auto_Data_Original" + ".xlsx";
Ea.SheetName = "Original";
Ea.dicListDate = Dal.dicListDate;
Ea.dicListFpi = Dal.dicListFpi;
Ea.CreateExcel();
return(result);
}
public void UC02_XSSF_xlsx()
{
Efa_Dic_StringList_DoubleList_Fpi Ea = new Efa_Dic_StringList_DoubleList_Fpi();
Ea.FilePath = AppDomain.CurrentDomain.BaseDirectory
+ "Result\\Result_Summary\\" + "Result_Auto_Data" + ".xlsx";
Ea.SheetName = "Product";
Ea.dicListFpi.TryAdd("Food", new List <double>()
{
1.1, 2.2, 3.3
});
Ea.dicListFpi.TryAdd("Bread and cereals", new List <double>()
{
4.4, 5.5, 6.6
});
Ea.dicListFpi.TryAdd("Bread", new List <double>()
{
7.7, 8.8, 9.9
});
Ea.dicListDate.TryAdd("Food", new List <string>()
{
"2005M01", "2005M02", "2005M03"
});
Ea.dicListDate.TryAdd("Bread and cereals", new List <string>()
{
"2005M01", "2005M02", "2005M03"
});
Ea.dicListDate.TryAdd("Bread", new List <string>()
{
"2005M01", "2005M02", "2005M03"
});
Ea.CreateExcel();
}
