public static string CreateJsonText(ExcelGenerator configuration)
{
StringBuilder json = new StringBuilder();
var keyList = ExcelGenerator.Title_Row;
var valueList = ExcelGenerator.Rows;
json.AppendLine("{");
json.AppendLine($" \"{_fileName}\" : [");
for (int i = 0; i < ExcelGenerator.Rows.Count; i++)
{
json.AppendLine(" {");
for (int j = 0; j < ExcelGenerator.Title_Row[0].Count; j++)
{
json.AppendLine($" \"{keyList[0][j].ToString()}\" : \"{valueList[i][j].ToString()}\",");
}
json.Remove(json.Length - 3, 1);
json.AppendLine(" },");
}
json.Remove(json.Length - 3, 1);
json.AppendLine(" ]");
json.AppendLine("}");
return(json.ToString());
}
private void CreateXmlFile(ExcelGenerator configuration)
{
var xmlContent = CreateXmlText(configuration);
File.WriteAllText(
path: _outputPath,
contents: xmlContent
);
}
private void CreateCsvFile(ExcelGenerator configuration)
{
var csvContent = CreateCsvText(configuration);
File.WriteAllText(
path: _outputPath,
contents: csvContent
);
}
private void CreateJsonFile(ExcelGenerator configuration)
{
var jsonContent = CreateJsonText(configuration);
File.WriteAllText(
path: _outputPath,
contents: jsonContent
);
}
public void GenerateConfigurations(string validImportFile, List <string> outputFilePathList)
{
var excelGenerator = new ExcelGenerator();
switch (Path.GetExtension(validImportFile))
{
case ".xlsx":
OnStatusMessage($"Starting Excel Generator...");
ExcelGenerator.Load(validImportFile, outputFilePathList);
OnStatusMessage($"Finished to read the import file.");
foreach (var outputPath in outputFilePathList)
{
if (outputPath.Contains("json"))
{
OnStatusMessage($"Creating Json file...");
var jsonWriter = new JsonWriter(validImportFile, outputFilePathList, excelGenerator);
OnStatusMessage($"Created Json file : {outputPath}");
}
else if (outputPath.Contains("xml"))
{
OnStatusMessage($"Creating Xml file...");
var xmlWriter = new XmlWriter(validImportFile, outputFilePathList, excelGenerator);
OnStatusMessage($"Created Xml file : {outputPath}");
}
else if (outputPath.Contains("csv"))
{
OnStatusMessage($"Creating Csv file...");
var csvWriter = new CsvWriter(validImportFile, outputFilePathList, excelGenerator);
OnStatusMessage($"Created Csv file : {outputPath}");
}
}
break;
case ".json":
break;
case ".xml":
break;
case ".csv":
break;
case ".sql":
break;
default:
break;
}
}
public CsvWriter(string validImportFile, List <string> outputFilePathList, ExcelGenerator configuration)
{
try
{
foreach (var path in outputFilePathList)
{
if (Path.GetExtension(path).Contains(FileFormat.csv.ToString()))
{
_outputPath = path;
CreateCsvFile(configuration);
}
}
}
catch (Exception e)
{
Exceptions.Add(e);
}
}
public XmlWriter(string validImportFile, List <string> outputFilePathList, ExcelGenerator configuration)
{
try
{
_fileName = Path.GetFileNameWithoutExtension(validImportFile);
foreach (var path in outputFilePathList)
{
if (Path.GetExtension(path).Contains(FileFormat.xml.ToString()))
{
_outputPath = path;
CreateXmlFile(configuration);
}
}
}
catch (Exception e)
{
Exceptions.Add(e);
}
}
public static string CreateXmlText(ExcelGenerator configuration)
{
StringBuilder xml = new StringBuilder();
var keyList = ExcelGenerator.Title_Row;
var valueList = ExcelGenerator.Rows;
xml.AppendLine($"<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
xml.AppendLine($"<{_fileName}>");
for (int i = 0; i < ExcelGenerator.Rows.Count; i++)
{
xml.AppendLine($"<{ExcelGenerator.WorkSheetName.Replace(" ", "-")}-{i+1}>");
for (int j = 0; j < ExcelGenerator.Title_Row[0].Count; j++)
{
xml.AppendLine($" <{keyList[0][j].ToString().Replace(" ", "")}>{valueList[i][j].ToString()}</{keyList[0][j].ToString().Replace(" ", "")}>");
}
xml.AppendLine($"</{ExcelGenerator.WorkSheetName.Replace(" ", "-")}-{i+1}>");
}
xml.AppendLine($"</{_fileName}>");
return(xml.ToString());
}
public static string CreateCsvText(ExcelGenerator configuration)
{
StringBuilder csv = new StringBuilder();
var keyList = ExcelGenerator.Title_Row;
var valueList = ExcelGenerator.Rows;
for (int i = 0; i < ExcelGenerator.Title_Row[0].Count; i++)
{
csv.Append($"{keyList[0][i].ToString()}, ");
}
csv.Remove(csv.Length - 2, 1);
csv.AppendLine();
for (int i = 0; i < ExcelGenerator.Rows.Count; i++)
{
for (int j = 0; j < ExcelGenerator.Title_Row[0].Count; j++)
{
csv.Append($"{valueList[i][j].ToString()}, ");
}
csv.Remove(csv.Length - 2, 1);
csv.AppendLine();
}
return(csv.ToString());
}
