public static JObject LoadJsonToJObject(string filename)
{
JObject jsonObj = null;
if (!String.IsNullOrWhiteSpace(filename) && File.Exists(filename))
{
try
{
using (StreamReader fileStream = File.OpenText(filename))
using (JsonTextReader reader = new JsonTextReader(fileStream))
{
jsonObj = (JObject)JToken.ReadFrom(reader);
}
}
catch (Exception ex)
{
throw JsonExcelException.LoadFileException(ex);
}
}
else
{
throw JsonExcelException.LoadFileNoFileFoundException();
}
if (jsonObj == null)
{
throw JsonExcelException.ParseFileException();
}
return(jsonObj);
}
public static Branch ParseSheetToBranch(Excel.Worksheet ws)
{
Branch root = new Branch("");
for (int i = 1; i <= 5000; i++)
{
Microsoft.Office.Interop.Excel.Range line = ws.Cells.Range[ws.Cells[i, 1], ws.Cells[i, 50]];
string[] strArrayFromExcelRow = line.Cells.Cast <Excel.Range>().Select(x => (string)x.Text).Where(x => !(String.IsNullOrWhiteSpace(x))).ToArray <string>();
if (!strArrayFromExcelRow.Any())
{
break;
}
try
{
Branch br = root.AddNewBranch(strArrayFromExcelRow);
}
catch (Exception ex)
{
throw JsonExcelException.ParseBranchException($"Error: Line {i} could not parsed", ex);
}
}
return(root);
}