private static ExcelData GetData(string path) { FileStream stream = File.Open(path, FileMode.Open, FileAccess.Read); IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream); DataSet dataSet = excelReader.AsDataSet(); ExcelData result = new ExcelData(dataSet); return(result); }
public static void ToProtoClass(string path) { ExcelData data = GetData(path); string directory = Path.GetDirectoryName(path); for (int i = 0; i < data.sheetDatas.Count; i++) { SheetData sheet = data.sheetDatas[i]; ClassData classData = sheet.ToProtoClass(); string filePath = directory + "/" + classData.className + ".cs"; StringToFile(filePath, classData.classContent); } }
private static SheetData GetSheet(string path, string sheetName) { ExcelData data = GetData(path); for (int i = 0; i < data.sheetDatas.Count; i++) { SheetData sheet = data.sheetDatas[i]; if (sheet.sheetName.Equals(sheetName)) { return(sheet); } } return(null); }
private static SheetData GetSheet(string path, int sheetIndex) { ExcelData data = GetData(path); if (data == null || data.sheetDatas == null || data.sheetDatas.Count < 1) { return(null); } if (sheetIndex >= data.sheetDatas.Count) { return(null); } return(data.sheetDatas[sheetIndex]); }
public static ClassData[] GetFieldClass(string path) { ExcelData data = GetData(path); string directory = Path.GetDirectoryName(path); int count = data.sheetDatas.Count; if (count == 0) { return(null); } ClassData[] result = new ClassData[count]; for (int i = 0; i < count; i++) { SheetData sheet = data.sheetDatas[i]; result[i] = sheet.ToFieldClass(); } return(result); }