This blog series discusses each of those tasks. Part 1 explained how to export a file to Excel and download it, while Part 2 discussed uploading a file and storing it in a table. This blog explains how to update an existing Excel file.
A quick hack today. Got this question from someone who needed to be able to update a report and show users that something had changed. This is easy when you have access to a database and can add data to it but in this case that was not possible.
So I came up with a hacky (and great :P) way to do this. and wanted to share it in case it came handy in your box of tricks :).
◾The requirement was such that , the user will select a line in the subform.
◾The subform has fields like the Customer ID, Customer Name, and a field Recieved Crates.
◾On click of the action button in the Main form, a page opens which contains the details of the selected line in the subform like Customer ID and Customer Name also a field Crate recieved(Integer Datatype).
I left the decision with you that the topic that we are discussing today is a feature or a bug which I found out recently in NAV 2017.
To Me, It’s a feature but with my discussion with some professional, I think it depends on customer business how they want to consider this.