Thank you for the your update
Regarding DocIO Samples:
We have used the GetOrder() and GetOrderDetails() in order to retrieve the value from the Data Table by order id from SyncOrder and SyncOrdersDetails Table in our MVC sample application. Kindly refer the code snippet for these methods from the source section of SalesInvoiceSample in the below link :
Regarding XlsIO Samples:
We have attached the extension classes which we have used in our XlsIO sample application. Kindly include these classes into your sample application and let us know if it helps you
Extension Classes Link:
please let us know if you have any other questions.
Thank you for your valuable feedback. Please let us know if you need further assistance. We will be happy to assist you as always.