Posted 23 April 2019, 9:18 am ESTI'm importing some relatively large .xls files into Spread 8.0 (OLEDB) using the ImportExcelBook method. It works reliably but it takes enough time that I'd like my application to show a progress bar to show users that activity is taking place. Does the ImportExcelBook method post any events I could listen for? I tried to track onSheetChanged but got nothing. If not ImportExcelBook, what about OpenExcel2007File, does it post events on what it's doing? Thanks.
How to track progress during ImportExcelBook processing?
Posted by: duncan.mcarthur on 23 April 2019, 9:18 am EST
Marked as Answer
Replied 29 April 2019, 11:06 pm ESTHello,
You can catch the Spread_Validate event, which fires when loading the Excel book to Spread COM.