public static string ConvertToJson(string excelPath, TernaryOption includeOrExlude, string[] fieldArry)
{
try
{
var dt = ConvertToDataTable(excelPath);
var isEntityFormat = false;
if (dt.TableName.ToLower().Contains("entity"))
{
isEntityFormat = true;
}
var dt1 = DataTableHelper.Shrink(dt, includeOrExlude, fieldArry);
return(DataTableHelper.ConvertToJson(dt1, isEntityFormat));
}
catch (Exception ex)
{
throw new ArgumentException("\n>> " + TypeName + ".ConvertToJson Error: " + ex.Message);
}
}
public static string ConvertToJson(string cvsPath)
{
try
{
var isEntityFormat = false;
if (FileHelper.IsFileExisting(cvsPath + ".IsEntity"))
{
isEntityFormat = true;
}
var dt = ConvertToDataTable(cvsPath);
var str = DataTableHelper.ConvertToJson(dt, isEntityFormat);
return(str);
}
catch (Exception ex)
{
throw new ArgumentException("\n>> " + TypeName + ".ConvertToJson Error: " + ex.Message);
}
}
public static string ConvertToJson(string excelPath)
{
try
{
var workbook = WeihanLi.Npoi.ExcelHelper.LoadExcel(excelPath);
var sheetName = workbook.GetSheetName(0);
var isEntityFormat = false;
if (sheetName.ToLower().Contains("entity"))
{
isEntityFormat = true;
}
var dt = ConvertToDataTable(excelPath);
var str = DataTableHelper.ConvertToJson(dt, isEntityFormat);
return(str);
}
catch (Exception ex)
{
throw new ArgumentException("\n>> " + TypeName + ".ConvertToJson Error: " + ex.Message);
}
}
