//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);
}
}
//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);
}
}
