How to track progress during ImportExcelBook processing?

Posted by: duncan.mcarthur on 23 April 2019, 9:18 am EST

  • Posted 23 April 2019, 9:18 am EST

    I'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.
  • Marked as Answer

    Replied 29 April 2019, 11:06 pm EST

    Hello,

    You can catch the Spread_Validate event, which fires when loading the Excel book to Spread COM.

    Thanks,
    Deepak Sharma
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels