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