//load Schema To Reader. void LoadSchema() { m_Schema = new Schema(); m_Schema.ClassName = m_FileName; HSSFSheet sheet = (HSSFSheet)m_Hssfworkbook.GetSheetAt(0); HSSFRow row0 = (HSSFRow)sheet.GetRow(0); // HSSFRow row1 = (HSSFRow)sheet.GetRow(1); HSSFRow row2 = (HSSFRow)sheet.GetRow(2); for (int i = 0; i < row0.LastCellNum; ++i) { FieldDefine tempDefine = new FieldDefine(); tempDefine.FieldName = row0.GetCell(i).ToString(); tempDefine.Index = i; string tempTypeStr = row2.GetCell(i).ToString(); if (tempTypeStr == "INT" || tempTypeStr == "int" || tempTypeStr == "Int") { tempDefine.FieldType = FIELD_TYPE.T_INT; } else if (tempTypeStr == "FLOAT" || tempTypeStr == "float" || tempTypeStr == "Float") { tempDefine.FieldType = FIELD_TYPE.T_FLOAT; } else if (tempTypeStr == "STRING" || tempTypeStr == "string" || tempTypeStr == "String") { tempDefine.FieldType = FIELD_TYPE.T_STRING; } else { tempDefine.FieldType = FIELD_TYPE.T_INVALID; } m_Schema.AddDefine(tempDefine); } }