public ExcelXmlModel GetUploadExcelXMLConfig(string xmlFilePath, string menuid)
{
ExcelXmlModel output = new ExcelXmlModel();
string excel_menu = "..excel_" + menuid;
JObject jObject = BI_Project.Helpers.Utility.JTokenHelper.GetXML2Jobject(xmlFilePath);
output.TemplateContents = BI_Project.Helpers.Utility.JTokenHelper.GetActiveJObject(jObject, excel_menu);
//Get Common Info
output.ExcelXmlCommon = new ExcelXmlCommon();
output.ExcelXmlCommon.ExcelFileName = BI_Project.Helpers.Utility.JTokenHelper.GetElementLanguage(jObject,
excel_menu + ".common.filename");
output.ExcelXmlCommon.SheetName = BI_Project.Helpers.Utility.JTokenHelper.GetElementLanguage(jObject,
excel_menu + ".common.sheet");
output.ExcelXmlCommon.StartRow = int.Parse(BI_Project.Helpers.Utility.JTokenHelper.GetElementLanguage(jObject,
excel_menu + ".common.datarowstart"));
output.ExcelXmlCommon.ReportName = BI_Project.Helpers.Utility.JTokenHelper.GetElementLanguage(jObject,
excel_menu + ".common.reportname");
output.ExcelXmlCommon.exportDirectory = BI_Project.Helpers.Utility.JTokenHelper.GetElementLanguage(jObject,
excel_menu + ".common.exportDirectory");
//GET PARAMETERS
IEnumerable <JToken> paras = BI_Project.Helpers.Utility.JTokenHelper.GetList(jObject, excel_menu + "..paras.para");
int index = 0;
foreach (JToken para in paras)
{
//XMLParaModel
ExcelXMLPara paraXMLModel = new ExcelXMLPara();
paraXMLModel.Name = para.SelectToken("..name").Value <string>();
paraXMLModel.Row = para.SelectToken("..row").Value <Int32>();
paraXMLModel.Column = para.SelectToken("..column").Value <Int32>();
paraXMLModel.Colspan = para.SelectToken("..colspan").Value <Int32>();
paraXMLModel.Title = para.SelectToken("..title").Value <string>();
output.LstParas.Add(paraXMLModel);
}
//GET COLUMNS CONFIG
IEnumerable <JToken> columns = BI_Project.Helpers.Utility.JTokenHelper.GetList(jObject, excel_menu + "..columns.column");
foreach (JToken column in columns)
{
ExcelXMLColumn columnXML = new ExcelXMLColumn();
columnXML.Name = column.SelectToken("..name").Value <string>();
columnXML.Title = column.SelectToken("..title").Value <string>();
columnXML.DataType = column.SelectToken("..datatype").Value <string>();
columnXML.IsGetData = column.SelectToken("..isgetdata").Value <bool>();
columnXML.ColumnWidth = column.SelectToken("..width").Value <int>();
output.LstColumn.Add(columnXML);
}
return(output);
}
public void writePara(ExcelWorksheet worksheet, ExcelXMLPara para, bool isBold)
{
writeHeaderColumn(worksheet, para.Row, para.Column, para.Colspan, para.Title, isBold, 0);
}