SpreadProcessing: Introduce support for data connected query
Introduce support for data connected query
2 comments
ADMIN
Nikolay Demirev
Posted on:28 May 2021 07:19
Hi Sean,
Thank you for sharing your feedback. It is most valuable. We are prioritizing our feature requests based on many factors. One of them is the votes, so please, make sure to cast your vote for the implementation of this task and subscribe to receive notifications about status changes on it.
Regards,
Nikolay Demirev Progress Telerik
Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly, just got a fresh new look + new and improved content, including a brand new Blazor course! Check it out at https://learn.telerik.com/.
Sean
Posted on:21 May 2021 13:29
RadGrid is nice to bind data queries to, which allow users to export data. However, some enterprise environments employ users that have existing data connected spreadsheets that need to be periodically (manually) refreshed. Aside from separate efforts to change the business process, having a library to assist in automating data refreshes from existing processes may have a place. Such a feature would need to have relevant security considerations handled by the developer, potentially including things like updating/auditing a connection string to the data set, or not running the query directly from the excel sheet in case it is changed , but updating the query definition. Updates to the data query however, could allow template automation and parameterization - potentially allowing separation from Business Analysts to design the excel query, and Developers , to review and update the excel automation. A common use case would be to update a data connected sheet that utilizes a GetDate() function for prior day, run , and export.