public TemplateSettingSheet(ExcelWorksheet sheet)
{
_FreeSettingList = new List <TemplateSettingRange>();
_GridSettingList = new List <TemplateSettingRange>();
_FieldSettingList = new List <TemplateSettingRange>();
if (sheet == null || sheet.Cells.Count() <= 0)
{
return;
}
foreach (var cell in sheet.Cells)
{
var cellValue = cell.Value?.ToString() ?? "";
var arry = cellValue.Split(new char[2] {
'{', '}'
}, StringSplitOptions.RemoveEmptyEntries);
if (arry.Length == 0)
{
continue;
}
foreach (var item in arry)
{
if (item.IndexOf(":") > -1 && item.IndexOf(";") > -1)
{
var settingItemArry = item.Split(new char[1] {
';'
}, StringSplitOptions.RemoveEmptyEntries);
if (settingItemArry.Length == 0)
{
continue;
}
var setting = new TemplateSettingRange();
foreach (var arryItem in settingItemArry)
{
var settingItem = arryItem.Split(':');
if (settingItem.Length < 2)
{
continue;
}
var key = settingItem[0];
var value = settingItem[1];
if (string.IsNullOrEmpty(key))
{
continue;
}
switch (key.ToUpper())
{
case "TYPE": { setting.Type = value.ToUpper(); } break;
case "DATASOURCE": { setting.DataSource = value.ToUpper(); } break;
case "ADDRESSLEFTTOP": { setting.AddressLeftTop = value.ToUpper(); } break;
case "ADDRESSRIGHTBOTTOM": { setting.AddressRightBottom = value.ToUpper(); } break;
case "FIELD": { setting.Field = value.ToUpper(); } break;
}
}
setting.CurrentCell = cell;
setting.SettingString = "{" + item + "}";
if (string.IsNullOrEmpty(setting.Type))
{
continue;
}
else if (setting.Type == "GRID")
{
ExcelCommon.CalcRowCol(setting.AddressLeftTop, out int fromRow, out int fromCol);
ExcelCommon.CalcRowCol(setting.AddressRightBottom, out int toRow, out int toCol);
setting.FromRow = fromRow;
setting.FromCol = fromCol;
setting.ToRow = toRow;
setting.ToCol = toCol;
_GridSettingList.Add(setting);
}
else if (setting.Type == "FREE")
{
ExcelCommon.CalcRowCol(setting.AddressLeftTop, out int fromRow, out int fromCol);
ExcelCommon.CalcRowCol(setting.AddressRightBottom, out int toRow, out int toCol);
setting.FromRow = fromRow;
setting.FromCol = fromCol;
setting.ToRow = toRow;
setting.ToCol = toCol;
_FreeSettingList.Add(setting);
}
else if (setting.Type == "VALUE")
{
_FieldSettingList.Add(setting);
}
}
var cellValueStr = cell.Value?.ToString() ?? "";
cell.Value = cellValueStr.Replace("{" + item + "}", "");
}
}
}
protected override void AnalyseSetting()
{
var cellValue = cell.Value?.ToString() ?? "";
var arry = cellValue.Split(new char[2] {
'{', '}'
}, StringSplitOptions.RemoveEmptyEntries);
if (arry.Length == 0)
{
continue;
}
foreach (var item in arry)
{
if (item.IndexOf(":") > -1 && item.IndexOf(";") > -1)
{
var settingItemArry = item.Split(new char[1] {
';'
}, StringSplitOptions.RemoveEmptyEntries);
if (settingItemArry.Length == 0)
{
continue;
}
foreach (var settingItem in settingItemArry)
{
if (settingItem.ToUpper().IndexOf("TYPE") < 0)
{
continue;
}
var arrItem = settingItem.Split(new char[1] {
':'
}, StringSplitOptions.RemoveEmptyEntries);
if (arrItem.Length < 2)
{
continue;
}
var key = arrItem[0];
var value = arrItem[1];
switch (value.ToUpper())
{
case "FREE":
{
var freeItem = TemplateSettingRangeFree.Create(cell);
_FreeSettingList.Add(freeItem);
}
break;
case "GRID":
{
var gridItem = TemplateSettingRangeGrid.Create(cell);
_GridSettingList.Add(gridItem);
}
break;
case "CHART":
{
var chartItem = TemplateSettingRangeChart.Create(cell);
_ChartSettingList.Add(chartItem);
}
break;
case "VALUE":
{
var fieldItem = TemplateSettingField.Create(cell);
_FieldSettingList.Add(fieldItem);
}
break;
}
}
#region free配置分解
#endregion
TemplateSettingRange setting = null;
var type = "";
var chartSubType = "";
var title = "";
foreach (var arryItem in settingItemArry)
{
var settingItem = arryItem.Split(':');
if (settingItem.Length < 2)
{
continue;
}
var key = settingItem[0];
var value = settingItem[1];
if (string.IsNullOrEmpty(key))
{
continue;
}
switch (key.ToUpper())
{
case "TYPE": { type = value.ToUpper(); } break;
case "SUBTYPE": { chartSubType = value.ToUpper(); } break;
case "DATASOURCE": { setting.DataSource = value.ToUpper(); } break;
case "ADDRESSLEFTTOP": { setting.AddressLeftTop = value.ToUpper(); } break;
case "ADDRESSRIGHTBOTTOM": { setting.AddressRightBottom = value.ToUpper(); } break;
case "FIELD":
{
var fieldSetting = new TemplateSettingField();
fieldSetting.Field = value.ToUpper();
fieldSetting.Content = "{" + item + "}";
fieldSetting.CurrentCell = cell;
_FieldSettingList.Add(fieldSetting);
}
break;
//case "TITLE": { title = value; }break;
//case "WIDTH": {int.TryParse(value,out int width); setting.ChartWidth = width; } break;
//case "HEIGHT": { int.TryParse(value, out int height); setting.ChartHeight = height; } break;
//case "ISCUSTOMSIZE": { setting.IsCustomSize = (value == "1") ?true : false; }break;
}
}
if (string.IsNullOrEmpty(type))
{
continue;
}
else if (type == "GRID")
{
setting = new TemplateSettingRangeGrid();
setting.CurrentCell = cell;
setting.Content = "{" + item + "}";
ExcelCommon.CalcRowCol(setting.AddressLeftTop, out int fromRow, out int fromCol);
ExcelCommon.CalcRowCol(setting.AddressRightBottom, out int toRow, out int toCol);
setting.FromRow = fromRow;
setting.FromCol = fromCol;
setting.ToRow = toRow;
setting.ToCol = toCol;
_GridSettingList.Add(setting);
}
else if (type == "FREE")
{
setting = new TemplateSettingRangeFree();
setting.CurrentCell = cell;
setting.Content = "{" + item + "}";
ExcelCommon.CalcRowCol(setting.AddressLeftTop, out int fromRow, out int fromCol);
ExcelCommon.CalcRowCol(setting.AddressRightBottom, out int toRow, out int toCol);
setting.FromRow = fromRow;
setting.FromCol = fromCol;
setting.ToRow = toRow;
setting.ToCol = toCol;
_FreeSettingList.Add(setting);
}
else if (type == "CHART")
{
setting = new TemplateSettingRangeChart();
setting.CurrentCell = cell;
setting.Content = "{" + item + "}";
ExcelCommon.CalcRowCol(setting.AddressLeftTop, out int fromRow, out int fromCol);
ExcelCommon.CalcRowCol(setting.AddressRightBottom, out int toRow, out int toCol);
setting.FromRow = fromRow;
setting.FromCol = fromCol;
setting.ToRow = toRow;
setting.ToCol = toCol;
_ChartSettingList.Add(setting);
//if (string.IsNullOrEmpty(chartSubType))
//{
// setting.ChartType = EnumChartType.Chart;
//}
//else
//{
// switch (chartSubType)
// {
// case "CHART": { setting.ChartType = EnumChartType.Chart; } break;
// case "BARCHART": { setting.ChartType = EnumChartType.BarChart; } break;
// case "BUBBLECHART": { setting.ChartType = EnumChartType.BubbleChart; } break;
// case "DOUGHNUTCHART": { setting.ChartType = EnumChartType.DoughnutChart; } break;
// case "LINECHART": { setting.ChartType = EnumChartType.LineChart; } break;
// case "OFPIECHART": { setting.ChartType = EnumChartType.OfPieChart; } break;
// case "PIECHART": { setting.ChartType = EnumChartType.PieChart; } break;
// case "RADARCHART": { setting.ChartType = EnumChartType.RadarChart; } break;
// case "SCATTERCHART": { setting.ChartType = EnumChartType.ScatterChart; } break;
// case "SURFACECHART": { setting.ChartType = EnumChartType.SurfaceChart; } break;
// default: { setting.ChartType = EnumChartType.Chart; } break;
// }
//}
}
else if (type == "VALUE")
{
_FieldSettingList.Add(setting);
}
}
var cellValueStr = cell.Value?.ToString() ?? "";
cell.Value = cellValueStr.Replace("{" + item + "}", "");
}
}