Call "Refresh data"

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?

Kind regards
Dirk Coetzee


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.


Thanks Adrian