private bool CreateResultSheet()
{
CurrentSelectedSheet.ResetMapping();
// Check to see if all required mapping are mapped
bool isValid = ValidateMapping();
if (isValid)
{
ApplyMappingInfoAndValidate(CurrentSelectedSheet);
DisplayImportedExcelSheet(CurrentSelectedSheet);
}
return(isValid);
}
private void InitMappingGrid()
{
CurrentSelectedSheet.ResetHeader();
// Get Header Row Index
int?headerRowNo = null;
if (gvRaw.SelectedIndexes.Count > 0)
{
headerRowNo = Convert.ToInt32(gvRaw.SelectedIndexes[0]);
}
// Display 5 rows of sample data
int rowIndex = 5;
if (headerRowNo.HasValue)
{
rowIndex += headerRowNo.Value + 1;
}
gvSample.DataSource = CurrentSelectedSheet.GetSampleData(rowIndex);
gvSample.DataBind();
if (headerRowNo.HasValue)
{
int[] selectedIndexes = new int[1];
selectedIndexes[0] = headerRowNo.Value;
gvSample.SelectedIndexes.Add(selectedIndexes);
// Set Excel sheet header based on user input
CurrentSelectedSheet.SetHeaderByRow(headerRowNo.Value);
}
// Auto mapping by comparing
AutoMatchFields();
rptItems.DataSource = MappingList;
rptItems.DataBind();
}
private void DisplayRawSheetData()
{
CurrentSelectedSheet.ResetHeader();
gvRaw.DataSource = CurrentSelectedSheet.GetSampleData();
gvRaw.DataBind();
}
