protected override void Execute(CodeActivityContext context) { //retrieve the parameters from the Context string oldFilePath = OldFilePath.Get(context); string newFileName = NewFileName.Get(context); string directoryToSave = DirectoryToSave.Get(context); //convert and set result string resultingFilePath = Utils.ConvertExcel(oldFilePath, newFileName, directoryToSave, FileTypes.NewExcel, Microsoft.Office.Interop.Excel.XlFileFormat.xlOpenXMLWorkbook); ResultingFilePath.Set(context, resultingFilePath); }
protected override void Execute(CodeActivityContext context) { //retrieve the parameters from the Context string oldFilePath = OldFilePath.Get(context); string newFileName = NewFileName.Get(context); string directoryToSave = DirectoryToSave.Get(context); //convert and set result string resultingFilePath = Utils.ConvertWord(oldFilePath, newFileName, directoryToSave, FileTypes.PDFExtension, Word.WdSaveFormat.wdFormatPDF); ResultingFilePath.Set(context, resultingFilePath); }
protected override void Execute(NativeActivityContext context) { try { String workbookFullName = FilePath.Get(context); String newFileName = NewFileName.Get(context); string newfilePath = NewFilePath.Get(context); string fileFormat = ToDescriptionString(FileFormatType); String[] fileFormatTypeStr = FileFormatType.ToString().TrimStart().Split('_'); String extension = String.Concat(".", fileFormatTypeStr[0]); string newFileNameWithExtension = String.Concat(newFileName, extension); string workbookName = string.Empty; dynamic xlWorkbook = null; bool excelFileVisible = false; if (true == NeedToOpen) { excelFileVisible = true; } // Combine 2 path parts. string workbooknameas = Path.Combine(newfilePath, newFileName); string workbooknameasWithExtension = Path.Combine(newfilePath, newFileNameWithExtension); if (File.Exists(workbookFullName)) { ExcelHelper.Shared.Close_OpenedFile(workbookFullName); workbookName = Path.GetFileName(workbookFullName); ExcelHelper.Shared.GetApp(excelFileVisible).DisplayAlerts = false; xlWorkbook = ExcelHelper.Shared.GetApp(excelFileVisible).Workbooks.Open(workbookFullName); if (File.Exists(workbooknameasWithExtension)) { if (true == IsOverride) { // xlWorkbook.SaveAs(workbooknameas, FileFormatType, Missing.Value, Missing.Value, false, false, XlSaveAsAccessMode.xlNoChange, XlSaveConflictResolution.xlUserResolution, true, Missing.Value, Missing.Value, Missing.Value); XlFileFormat fm = (XlFileFormat)Enum.Parse(typeof(XlFileFormat), fileFormat); xlWorkbook.SaveAs(workbooknameas, fm, Missing.Value, Missing.Value, false, false, XlSaveAsAccessMode.xlNoChange, XlSaveConflictResolution.xlUserResolution, true, Missing.Value, Missing.Value, Missing.Value); } else { Log.Logger.LogData("The file \"" + newFileName + "\" is already exists in activity Excel_Workbook_SaveAs", LogLevel.Error); if (!ContinueOnError) { context.Abort(); } } } else { // xlWorkbook.SaveAs(workbooknameas, XlFileFormat.xlWorkbookDefault, Missing.Value, Missing.Value, false, false, XlSaveAsAccessMode.xlNoChange, XlSaveConflictResolution.xlUserResolution, true, Missing.Value, Missing.Value, Missing.Value); //xlWorkbook.SaveAs(workbooknameas, FileFormatType, Missing.Value,Missing.Value, false, false, XlSaveAsAccessMode.xlNoChange,XlSaveConflictResolution.xlUserResolution, true, Missing.Value, Missing.Value, Missing.Value); XlFileFormat fm = (XlFileFormat)Enum.Parse(typeof(XlFileFormat), fileFormat); xlWorkbook.SaveAs(workbooknameas, fm, Missing.Value, Missing.Value, false, false, XlSaveAsAccessMode.xlNoChange, XlSaveConflictResolution.xlUserResolution, true, Missing.Value, Missing.Value, Missing.Value); } if (true == NeedToClose) { xlWorkbook.Close(); } if (false == NeedToClose && false == NeedToOpen) { xlWorkbook.Close(); } if (false == NeedToClose && true == NeedToOpen) { xlWorkbook.Close(); ExcelHelper.Shared.GetApp(excelFileVisible).Workbooks.Open(workbookFullName); } if (ExcelHelper.Shared.GetApp(excelFileVisible).Workbooks.Count == 0) { ExcelHelper.Shared.Dispose(); } } else { Log.Logger.LogData("Excel file does not exist:\"" + workbookFullName + "\" in activity Excel_Workbook_SaveAs", LogLevel.Error); if (!ContinueOnError) { context.Abort(); } } } catch (Exception ex) { Log.Logger.LogData(ex.Message + " in activity Excel_Workbook_SaveAs", LogLevel.Error); if (!ContinueOnError) { context.Abort(); } } }