protected override async Task <Action <AsyncCodeActivityContext> > ExecuteAsync(AsyncCodeActivityContext context, CancellationToken cancellationToken) { // Inputs var excelFilePath = ExcelFilePath.Get(context); var sapProcessName = SAPProcessName.Get(context); var xmlFolderPath = XMLFolderPath.Get(context); var xmlFilePath = string.Empty; XmlDocument doc = null; ExcelToXMLConverter excelToXMLConverter = new ExcelToXMLConverter(); if (!string.IsNullOrEmpty(xmlFolderPath)) { xmlFilePath = excelToXMLConverter.ConvertExcelToXMLFile(excelFilePath, sapProcessName, xmlFolderPath); } else { doc = excelToXMLConverter.ConvertExcelToXMLDocument(excelFilePath, sapProcessName); } // Outputs return((ctx) => { XMLDocument.Set(ctx, doc); XMLPath.Set(ctx, xmlFilePath); }); }
static void Main(string[] args) { ExcelToXMLConverter excelToXMLConverter = new ExcelToXMLConverter(); var xmlDocument = excelToXMLConverter.ConvertExcelToXMLDocument("BAPI_SALESORDER_CREATEFROMDAT2.xlsx", "BAPI_SALESORDER_CREATEFROMDAT2"); SAPXmlConverter sAPXmlConverter = new SAPXmlConverter(); var output = sAPXmlConverter.ProcessXMLForSAPBapi("", xmlDocument); }
private void OnConvertButtonClicked(object sender, EventArgs e) { _converter = new ExcelToXMLConverter(_sSelectedExcelFile, _sSelectedOutputPath); _converter.PercentageProcessed += OnProgressBarUpdated; _converter.FileProcessing += OnFileStartedProcessing; _progressBar.Visible = true; _progressBar.Value = 0; _converter.Convert(); if (MessageBox.Show("Excel file successfully exported to XML files", "Success", MessageBoxButtons.OK) == DialogResult.OK) { Close(); } }