StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POVB.net Cross-thread operation not valid
text
Body
copied!<p>I am trying my best to figure out how to go about this error i am reciving:</p> <p><strong><em>Cross-thread operation not valid: Control 'ListView1' accessed from a thread other than the thread it was created on.</em></strong></p> <p>I have a backgroundworker thats extracting cells from an excel worksheet and placing them into the listview.</p> <p>Upon form load i do this:</p> <pre><code>Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Call createListView() End Sub Private Sub createListView() ListView1.View = View.Details ListView1.GridLines = True ListView1.FullRowSelect = True ListView1.HideSelection = False ListView1.MultiSelect = False ListView1.Columns.Add("Column Name", 150) ListView1.Columns.Add("Column Number", 150) End Sub </code></pre> <p>Then i call the backgroundworker after the user selects a file:</p> <pre><code>If openFileDialog1.ShowDialog() = DialogResult.OK Then stFilePathAndName = openFileDialog1.FileName ProgressBar1.Style = ProgressBarStyle.Marquee BGWxml2excel = New System.ComponentModel.BackgroundWorker BGWxml2excel.WorkerReportsProgress = True BGWxml2excel.WorkerSupportsCancellation = True BGWxml2excel.RunWorkerAsync() End If </code></pre> <p>Then i process with getting the excel column count and values so that i can populate the listview with it:</p> <pre><code>Private Sub BGWxml2excel_DoWork(ByVal sender As Object, ByVal e As System.ComponentModel.DoWorkEventArgs) Handles BGWxml2excel.DoWork Call xml2Excel(stFilePathAndName) End Sub Private Sub xml2Excel(ByRef theDirOfFile As String) Dim xlsApp As Excel.Application Dim xlsWB As Excel.Workbook Dim xlsSheet As Excel.Worksheet Dim columnCount As Integer = 0 xlsApp = New Excel.Application xlsApp.Visible = False xlsApp.DisplayAlerts = False xlsWB = xlsApp.Workbooks.OpenXML(Filename:=theDirOfFile, LoadOption:=XlXmlLoadOption.xlXmlLoadImportToList) xlsSheet = xlsWB.Worksheets(1) xlsSheet.Select() columnCount = xlsSheet.UsedRange.Columns.Count Dim lvi As New ListViewItem Dim x As Integer = 1 Do Until x = columnCount + 1 lvi.Text = xlsSheet.Cells(1, x).value lvi.SubItems.Add(x) ListView1.Items.Add(lvi) x = x + 1 Loop 'xlsSheet.SaveAs("c:\_tempExcelFile.xlsx", FileFormat:=51, CreateBackup:=False) xlsWB.Close() xlsApp.Quit() End Sub </code></pre> <p>The error is on this line:</p> <pre><code>ListView1.Items.Add(lvi) </code></pre> <p>What can i do in order to correct this odd proglem?</p> <p>Thanks!</p> <p>David</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

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