Background worker with input

alec

I have a function

public void DataTableToExcel (DataTable DT)
{
Excel.Application ExcelApp = new Excel.Application();
ExcelApp.Workbooks.Add();
ExcelApp.Workbooks[1].Worksheets.Add();
Excel.Worksheet wSheet = ExcelApp.Workbooks[1].Worksheets[1];

for (int i = 1; i < DT.Columns.Count + 1; i++)
{
wSheet.UsedRange[1, i] = DT.Columns[i - 1].ColumnName.ToString();
}

wSheet.get_Range(ExcelColumnLetter(0) + "1", ExcelColumnLetter(DT.Columns.Count) + "1").Font.Bold = true;

for (int i = 0; i < DT.Rows.Count; i++)
{
for (int j = 0; j < DT.Columns.Count; j++)
{
wSheet.UsedRange[i + 2, j + 1] = DT.Rows[i][j].ToString();
}
}
ExcelApp.Visible = true;
}

and I want it as a backgroundworker as I want it in a different thread and to report its progress.

How do I make a backgroundworker with an input?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs14y ago
Accepted answer
You can pass whatever parameter you need to in the RunWorkerAsync Method and the BackgroundWorker.DoWork Event receives it in the Argument member of the DoWorkEventArgs Class. The object can be a class you define so you can pass as many other objects as you neeed to. You just need to cast the Argument member to whatever object it is. Be sure to use synchronization as needed.
alec14y ago
that sounds much better than my work around

code for work around:

//declare DT at top level
DataTable DT = new DataTable();

//set backgroundworker to use DT
private void BwFillExcell_DoWork(object sender, DoWorkEventArgs e)
{
Excel.Application ExcelApp = new Excel.Application();
ExcelApp.Workbooks.Add();
ExcelApp.Workbooks[1].Worksheets.Add();
Excel.Worksheet wSheet = ExcelApp.Workbooks[1].Worksheets[1];

for (int i = 1; i < DT.Columns.Count + 1; i++)
{
wSheet.UsedRange[1, i] = DT.Columns[i - 1].ColumnName.ToString();
}

wSheet.get_Range(ExcelColumnLetter(0) + "1", ExcelColumnLetter(DT.Columns.Count) + "1").Font.Bold = true;

for (int i = 0; i < DT.Rows.Count; i++)
{
for (int j = 0; j < DT.Columns.Count; j++)
{
wSheet.UsedRange[i + 2, j + 1] = DT.Rows[i][j].ToString();
}
BwFillExcell.ReportProgress((int)(100*(float)i/(float)(DT.Rows.Count - 1)));
}
ExcelApp.Visible = true;
}

//create function that sets DT and calls background worker
public void DataTableToExcell(DataTable Dtable)
{
DT.Clear();
DT = Dtable;
BwFillExcell.RunWorkerAsync();
}