public void ExportData() { if (MakeTempTableAccess()) { Connections cons = new Connections(); ExportToExcel ops = new ExportToExcel { DatabaseName = msAccessFileName, Headers = false, ExcelFileName = msExcelFile, TableName = TempTableName, WorkSheetName = "Report1" }; HasErrors = !ops.Execute(); if (HasErrors) { ExeptionMessage = ops.ExceptionMessage; } RecordsInserted = ops.RecordsInserted; } }
/// <summary> /// Execute Action /// </summary> /// <param name="oActionCallingContext"></param> /// <returns></returns> public bool Execute(ActionCallingContext oActionCallingContext) { SelectionSet Set = new SelectionSet(); Project CurrentProject = Set.GetCurrentProject(true); string ProjectName = CurrentProject.ProjectName; Debug.WriteLine(ProjectName); string xlsFileName = Path.GetDirectoryName(CurrentProject.ProjectFullName); xlsFileName = Path.Combine(xlsFileName, $"{ DateTime.Now.Year }.{ DateTime.Now.Month }.{ DateTime.Now.Day }_" + Settings.Default.outputFileName); // Show ProgressBar Progress progress = new Progress("SimpleProgress"); progress.SetAllowCancel(true); progress.SetAskOnCancel(true); progress.SetTitle("Wire mark export"); progress.ShowImmediately(); progress.BeginPart(25.0, "Export label : "); try { // Executing Action "label" ExportXML.Execute(xmlExportFileName); if (progress.Canceled()) { progress.EndPart(true); return(true); } } catch (Exception ex) { ErrorHandler("ExportXML", ex); return(false); } progress.EndPart(); progress.BeginPart(25.0, "Parse XML : "); try { // Getting object from XML ParseXMLWireFile(); if (progress.Canceled()) { progress.EndPart(true); return(true); } } catch (Exception ex) { ErrorHandler("ParseXMLWireFile", ex); return(false); } progress.EndPart(); progress.BeginPart(10.0, "Write data to Excel : " + xlsFileName); try { // Export to excel // Creating *.xls file ExportToExcel.Execute(listOfLines, xlsFileName, progress); if (progress.Canceled()) { progress.EndPart(true); return(true); } } catch (Exception ex) { ErrorHandler("ExportToExcel.Execute", ex); return(false); } finally { progress.EndPart(true); } return(true); }