Databases
StackOverflow2013
Postsdbo
POerror occurred while work with excel files with multi thread
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POerror occurred while work with excel files with multi thread
    primarykey
    data
    text
    <p>In Asp.net When working with multi threading via Excel Interop using the below code:</p> <pre><code>Public Class ImportService Public Function ImportsFiles(ByVal files as list(Of String)) Dim rowEffect As Integer = 0 For j as Integer=0 to files.Count-1 dim fileAddress=files(j) Dim app As New Application Dim Wbook As Workbook Try Wbook = app.Workbooks.Open(fileAddress, [ReadOnly]:=True) For i As Integer = 1 To Wbook.Sheets.Count If Not Wbook.Sheets(i).Name.ToString.ToLower.Contains("partial read of load profile") Then Dim con As New System.Data.OleDb.OleDbConnection("provider=Microsoft.ACE.OLEDB.12.0; Data Source=" &amp; fileAddress &amp; "; Extended Properties=""Excel 12.0 Xml;HDR=No;IMEX=1"";") Dim cmd As New OleDbCommand Dim s As String = "SELECT * FROM [" &amp; Wbook.Sheets(i).Name &amp; "$]" cmd.CommandText = s cmd.Connection = con Dim da As New OleDbDataAdapter da.SelectCommand = cmd Dim dt As New System.Data.DataTable da.Fill(dt) Dim err As New Dictionary(Of String, String) Dim fileDate As String = Wbook.Sheets(i).Name.ToString.Trim.Replace(" ", "/") rowEffect += InsertLps(Path.GetFileName(fileAddress), fileDate, dt.Rows, err) dt.Dispose() da.Dispose() con.Dispose() cmd.Dispose() End If ReleaseCOMObject(Wbook.Sheets(i)) Next Wbook.Close(SaveChanges:=False) Catch ex As Exception summary.Add(fileAddress, ex.Message) Finally GC.Collect() GC.WaitForPendingFinalizers() GC.Collect() GC.WaitForPendingFinalizers() If app.Workbooks IsNot Nothing Then For Each wb In app.Workbooks For Each ws In wb.Worksheets ReleaseCOMObject(ws) Next wb.Close(False) ReleaseCOMObject(wb) Next End If app.Workbooks.Close() app.Quit() ReleaseCOMObject(app) GC.WaitForFullGCComplete() Next End Function End Class </code></pre> <p>An error occurs:</p> <blockquote> <p>Transition into COM context 0x946d20 for this RuntimeCallableWrapper failed with the following error: The object invoked has disconnected from its clients. (Exception from HRESULT: 0x80010108 (RPC_E_DISCONNECTED)). This is typically because the COM context 0x946d20 where this RuntimeCallableWrapper was created has been disconnected or it is busy doing something else. Releasing the interfaces from the current COM context (COM context 0x946c68). This may cause corruption or data loss. To avoid this problem, please ensure that all COM contexts/apartments/threads stay alive and are available for context transition, until the application is completely done with the RuntimeCallableWrappers that represents COM components that live inside them.</p> </blockquote> <p>i'm trying to work with Quartz.net and more triggers do job in background. when 2 trrigger start job by this code:</p> <pre><code>Public Class ImportJob Implements IJob Public Sub Execute(context As IJobExecutionContext) Implements IJob.Execute Dim importHelpers As New ImportFilesHelpers Dim exts As New List(Of String) exts.Add(".xls") Dim files = importHelpers.GetFiles(ImportFilesHelpers.BaseAssress, exts) Dim import = New ImportService() import.ImportsFiles(files) End Sub End Class </code></pre> <p>Following Error Acoures in This Line</p> <pre><code>Dim fileDate As String = Wbook.Sheets(i).Name.ToString.Trim.Replace(" ", "/") </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCœur
    1. USMohsen Musavi
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. POerror occurred while work with excel files with multi thread
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. POerror occurred while work with excel files with multi thread
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POerror occurred while work with excel files with multi thread
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COYou probably don't need to use multi-threading to work with an Excel spreadsheet. Can you explain exactly what you are trying to do, maybe we can show you a better way
      singulars
      1. POerror occurred while work with excel files with multi thread
      1. USJMK
    2. COAre you trying to put the contents of a Worksheet into a VB.Net DataTable?
      singulars
      1. POerror occurred while work with excel files with multi thread
      1. USJMK
    3. COPlease be more specific about what you are doing.
      singulars
      1. POerror occurred while work with excel files with multi thread
      1. USalk
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload