Hi, I am using FlexCel to open a XLSX spreadsheet with a connection to a SQL data source. I want to call the "Refresh All" option to update all the data in the workbook coming from a data source.. Can and how do I achive this using Flexcel?
Sadly this is not possible with FlexCel, refreshing from data sources is not supported. While it could be possible to add it, it would add a lot of complexity and to be sincere this doesn't seem to be a very used feature. I think this is the first time I get a request for it since I started developing FlexCel. So at least for the middle time plans, this isn't going to be implemented, it will have to be done with OLE Automation.