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