private void ReadProperties(XlsxSheet sheet) { mNamespace = sheet.SheetName; mId = sheet.SheetName; Properties client = new Properties(sheet, DataSideEnum.C, CLIENT_XLSX_NODE_TAG, this); Properties server = new Properties(sheet, DataSideEnum.S, SERVER_XLSX_NODE_TAG, this); mNamespaces.Add(client); mNamespaces.Add(server); }
private Properties(XlsxSheet sheet, DataSideEnum side, string name, Properties parent) : this() { mNamespace = name; mId = name; mParent = parent; List <int> cols = sheet.GetColumns(side); for (int i = 0; i < sheet.RowCount; ++i) { Properties rowProp = new Properties(sheet, i, cols, sheet.SheetName, this); mNamespaces.Add(rowProp); } }
public static XlsxSheet Create(ExcelWorksheet tDS, Xlsx parent) { XlsxSheet sheet = new XlsxSheet(parent, tDS.Name); List <string> variableNames; List <DataTypeEnum> variableTypes; List <DataSideEnum> variableSides; string managerName = null; string keys = null; MainEntry.Log(string.Format("-------------------SheetName: {0} Begin", tDS.Name)); List <XlsxRow> datas = CleanRowAndCols(tDS, sheet, out managerName, out keys, out variableNames, out variableTypes, out variableSides); if (datas != null) { sheet.Set(managerName, keys, variableNames, variableTypes, variableSides, datas); MainEntry.Log(string.Format("-------------------SheetName: {0} End", tDS.Name)); return(sheet); } MainEntry.Log(string.Format("*******************SheetName: {0} failed", tDS.Name)); return(null); }
private Properties(XlsxSheet sheet, int row, List <int> cols, string name, Properties parent) : this() { mNamespace = name; mId = name; mParent = parent; for (int i = 0; i < cols.Count; ++i) { int colIndex = cols[i]; string varName = null; DataTypeEnum varType = DataTypeEnum.NONE; sheet.GetCol(colIndex, ref varName, ref varType); string value = sheet[row, colIndex]; if (value != null) { string defaultValue = null; switch (varType) { case DataTypeEnum.BYTE: case DataTypeEnum.SHORT: case DataTypeEnum.USHORT: case DataTypeEnum.INT: case DataTypeEnum.UINT: case DataTypeEnum.LONG: case DataTypeEnum.ULONG: case DataTypeEnum.FLOAT: defaultValue = "0"; break; } // 默认值不导出 if (defaultValue != null && defaultValue.Equals(value)) { continue; } mProperties.Add(new Property(varName, value)); } } }
private static List <XlsxRow> CleanRowAndCols(ExcelWorksheet tDS, XlsxSheet sheet, out string managerName, out string keys, out List <string> variableNames, out List <DataTypeEnum> variableTypes, out List <DataSideEnum> variableSides) { variableNames = new List <string>(); variableTypes = new List <DataTypeEnum>(); variableSides = new List <DataSideEnum>(); managerName = null; keys = null; ExcelRange range = tDS.Cells; object[,] values = (object[, ])range.Value; int rows = values.GetLength(0); int cols = values.GetLength(1); HashSet <int> skipCols = new HashSet <int>(); HashSet <int> skipRows = new HashSet <int>(); if (rows > 0 && cols > 0) { // List,Group<ColName>,Map<ColName>,Map<ColName1, ColName2> string value = (string)values[SHEET_DATA_MANAGER, 0]; if (value == null) { MainEntry.Log(string.Format("****************SheetName: {0} Wrong At [0, 0] End", tDS.Name)); return(null); } ParseManagerType(value, ref managerName, ref keys); if (managerName == null) { MainEntry.Log(string.Format("****************SheetName: {0} Wrong ManagerName {1} End", tDS.Name, value)); return(null); } } for (int i = 0; i < cols; ++i) { if (values[VARIABLE_SIDE_ROW, i] == null) { MainEntry.Log(string.Format("skip null col: [{0}, {1}], maybe last col", VARIABLE_SIDE_ROW, i)); skipCols.Add(i); continue; } string v = values[VARIABLE_SIDE_ROW, i].ToString().Trim().ToUpper(); DataSideEnum side = EnumUtils.StringToEnum <DataSideEnum>(v); if (side == DataSideEnum.SKIP) { MainEntry.Log(string.Format("skip flag col: [{0}, {1}]", VARIABLE_SIDE_ROW, i)); skipCols.Add(i); continue; } if (values[VARIABLE_NAME_ROW, i] == null) { // log MainEntry.Log(string.Format("Not Define Variable Name: [{0}, {1}]", VARIABLE_NAME_ROW, i)); return(null); } if (values[VARIABLE_TYPE_ROW, i] == null) { // log MainEntry.Log(string.Format("Not Define Variable Type: [{0}, {1}]", VARIABLE_TYPE_ROW, i)); return(null); } variableSides.Add(side); v = values[VARIABLE_NAME_ROW, i].ToString().Trim(); variableNames.Add(v); v = values[VARIABLE_TYPE_ROW, i].ToString().Trim(); try { DataTypeEnum dataType = EnumUtils.StringToEnum <DataTypeEnum>(v.ToUpper()); variableTypes.Add(dataType); } catch (Exception e) { MainEntry.Log(string.Format("Not Define Variable Side: [{0}, {1}] = {2}, Error: {3}", VARIABLE_TYPE_ROW, i, v, e.Message)); return(null); } } for (int i = VALUE_START_ROW; i < rows; ++i) { if (values[i, 0] != null) { string v = values[i, 0].ToString().Trim(); if (v.StartsWith(SKIP_ROW)) { MainEntry.Log(string.Format("skip flag row: [{0}, 0]", i)); skipRows.Add(i); } } else { MainEntry.Log(string.Format("skip null row: [{0}, 0], maybe last row", i)); skipRows.Add(i); } } List <XlsxRow> originalDatas = new List <XlsxRow>(); int rowIndex = 0; for (int i = VALUE_START_ROW; i < rows; ++i) { if (skipRows.Contains(i)) { continue; } List <string> rowData = new List <string>(); XlsxRow row = new XlsxRow(rowIndex++, rowData, sheet); originalDatas.Add(row); for (int j = 0; j < cols; ++j) { if (skipCols.Contains(j)) { continue; } rowData.Add(values[i, j] != null ? values[i, j].ToString() : null); } } return(originalDatas); }
public XlsxRow(int rowIndex, List <string> v, XlsxSheet parent) { RowIndex = rowIndex; Values = v; Parent = parent; }
private Properties(XlsxSheet sheet, Properties parent) : this() { mParent = parent; ReadProperties(sheet); Rewind(); }