Transaction ReFramwork for multiple excel files to process

How can i make 1 transaction = 1 workbook to process in a list of multiple workbooks in a file? If i use the Directory.GetFiles, I’m assuming it will not treat one workbook as one transaction.

@Laura2

Change the transactiondata variable from datatable to string array and assign directory.Getfiles result to it

change transactionitem to string

And in gettransactiondata.xaml use if condition with in_transactionnumber<=io_transactiondata.count

On lect side use out_TransactionItem= io_transactiondata(in_transactionnumber-1) and on else side use out_transactionitem = nothing

Hope this helps

Cheers

1 Like

That worked. Many thanks.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.