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