How to track progress during ImportExcelBook processing?

How to track progress during ImportExcelBook processing?

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

• 

  duncan.mcarthur

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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.

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 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