excel线程与后台启用 [英] excel threading with background enable

问题描述

i创建了一个与数据库连接的excel插件。

填充数据库中的数据。

当它从数据库中提取数据时，我们无法在excel表中执行任何操作。

但我想做一些操作。



请帮助我。

解决方案

您可以使用BackgroundWorker类。

  Imports  System.ComponentModel 
 
  Friend   WithEvents  BW 作为 BackgroundWorker 
 
  Sub  Start（）
 
  Dim  task  As  对象 =   Hello，World！ 
 
 BW = 新 BackgroundWorker 
 
 BW.RunWorkerAsync（任务）
 
 结束  Sub  
 
 私有  Sub  BW_DoWork（sender 作为 对象，e 作为 DoWorkEventArgs）句柄 BW.DoWork 
 
 e.Result = e.Argument 
 
 结束 < span class =code-keyword> Sub  
 
 私有  Sub  BW_RunWorkerCompleted（sender  As   Object ，e  As  RunWorkerCompletedEventArgs）句柄 BW.RunWorkerCompleted 
 
 MsgBox（e.Result）
 
 结束 子 

Hi,

i have created a excel addin which is connecting with database.
Fills data from database.
When it is bringing data from database that time we can not do any operation in excel sheet.
but i want to do some operation.

Please help me.

解决方案

You may use the BackgroundWorker class.

Imports System.ComponentModel

Friend WithEvents BW As BackgroundWorker

Sub Start()

    Dim task As Object = "Hello, World!"

    BW = New BackgroundWorker

    BW.RunWorkerAsync(task)

End Sub

Private Sub BW_DoWork(sender As Object, e As DoWorkEventArgs) Handles BW.DoWork

    e.Result = e.Argument

End Sub

Private Sub BW_RunWorkerCompleted(sender As Object, e As RunWorkerCompletedEventArgs) Handles BW.RunWorkerCompleted

    MsgBox(e.Result)

End Sub

这篇关于excel线程与后台启用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！