Esempio n. 1
0
 /// <summary>
 /// Stop Exporting
 /// </summary>
 /// <param name="exportDataTableArgs">ExportDataTableEventArgs</param>
 private void Sheet_ExportDataTableEventStop(ExportDataTableEventArgs exportDataTableArgs)
 {
     if (exportDataTableArgs.ExcelValue != null && exportDataTableArgs.ExcelValue.ToString() == "BLONP")
     {
         exportDataTableArgs.ExportDataTableAction = ExportDataTableActions.StopExporting;
     }
 }
Esempio n. 2
0
 /// <summary>
 /// Replace value
 /// </summary>
 /// <param name="exportDataTableArgs">ExportDataTableEventArgs</param>
 private void Sheet_ExportDataTableEventReplace(ExportDataTableEventArgs exportDataTableArgs)
 {
     if (exportDataTableArgs.ExcelValue != null && exportDataTableArgs.ExcelValue.ToString() == "México D.F.")
     {
         exportDataTableArgs.DataTableValue = "Mexico";
     }
 }
Esempio n. 3
0
 /// <summary>
 /// Skip Row
 /// </summary>
 /// <param name="exportDataTableArgs">ExportDataTableEventArgs</param>
 private void Sheet_ExportDataTableEventSkip(ExportDataTableEventArgs exportDataTableArgs)
 {
     if (exportDataTableArgs.ExcelColumnIndex == 4 && exportDataTableArgs.ExcelValue.ToString() == "Owner")
     {
         exportDataTableArgs.ExportDataTableAction = ExportDataTableActions.SkipRow;
     }
 }
 private static void ExportDataTable_EventAction(ExportDataTableEventArgs e)
 {
     if (e.ExcelValue != null && e.ExcelValue.ToString() == "Owner")
     {
         //Skips the row to export into the data table if the Excel cell value is “Owner”
         e.ExportDataTableAction = ExportDataTableActions.SkipRow;
     }
     else if (e.DataTableColumnIndex == 0 && e.ExcelRowIndex == 5 && e.ExcelColumnIndex == 1)
     {
         //Stops the export based on the condition
         e.ExportDataTableAction = ExportDataTableActions.StopExporting;
     }
     else if (e.ExcelValue != null && e.ExcelValue.ToString() == "Mexico D.F.")
     {
         //Replaces the cell value in the data table without affecting the Excel document.
         e.DataTableValue = "Mexico";
     }
 }
Esempio n. 5
0
 /// <summary>
 /// Export dataTable required actions.
 /// </summary>
 /// <param name="e"></param>
 private void ExportDataTableEventActions(ExportDataTableEventArgs e)
 {
     if (this.rdbSkipRow.Checked)
     {
         if (e.ExcelValue != null && e.ExcelValue.ToString() == "Owner")
         {
             e.ExportDataTableAction = ExportDataTableActions.SkipRow;
         }
     }
     if (this.rdbStop.Checked)
     {
         if (e.ExcelValue != null && e.ExcelValue.ToString() == "CACTU")
         {
             e.ExportDataTableAction = ExportDataTableActions.StopExporting;
         }
     }
     if (this.rdbReplaceValue.Checked)
     {
         if (e.ExcelValue != null && e.ExcelValue.ToString() == "Mexico D.F.")
         {
             e.DataTableValue = "Mexico";
         }
     }
 }
Esempio n. 6
0
 /// <summary>
 /// Export dataTable required actions.
 /// </summary>
 /// <param name="e"></param>
 private void ExportDataTableEventActions(ExportDataTableEventArgs e)
 {
     if (importOptions == "Skip")
     {
         if (e.ExcelValue != null && e.ExcelValue.ToString() == "Owner")
         {
             e.ExportDataTableAction = ExportDataTableActions.SkipRow;
         }
     }
     if (importOptions == "Stop")
     {
         if (e.ExcelValue != null && e.ExcelValue.ToString() == "CACTU")
         {
             e.ExportDataTableAction = ExportDataTableActions.StopExporting;
         }
     }
     if (importOptions == "Replace")
     {
         if (e.ExcelValue != null && e.ExcelValue.ToString() == "México D.F.")
         {
             e.DataTableValue = "Mexico";
         }
     }
 }