TextBox to Excel

[Xystus777]

Hello everyone,

I know how to take a DataGridView and put it into Excel, but how can I take the text that's in a textbox and put it into a specific cell in Excel?

Here's my code for DataGridViewToXLS:

//this whole section will transfer everything to Excel, from here to the end. 
            Excel.Application excelApp = new Excel.Application(); 
            Excel._Workbook excelWB; 
            Excel._Worksheet excelWS; 
            Excel.Range excelRng; 
             
             
            //Opens a new instance 
            excelWB = (Excel._Workbook)(excelApp.Workbooks.Add(Missing.Value)); 
            excelWS = (Excel._Worksheet)excelWB.ActiveSheet; 
 
            int colIndex = 0; 
            foreach (DataGridViewColumn column in dataGridView1.Columns) 
            { 
                if (column.Visible) 
                { 
                    //Export 
                    excelWS.Cells[1, colIndex + 1] = column.HeaderText; 
                    for (int row = 1; row < dataGridView1.Rows.Count; row++) 
                    { 
                        excelWS.Cells[row + 1, colIndex + 1] = dataGridView1[colIndex, row - 1].Value; 
                    } 
                    colIndex++; 
                     
                } 
            }

However, I would like to have TextBoxTextToXLS. Thanks.

[Xav]

Automate Excel. Import the library, then instantiate Excel.Application to an object variable.

[Xystus777]

I hate to say this to you...but none of that makes sense to me. I'm a beginner, remember?

[Xav]

OK.

Add a reference to Microsoft Office. Then import the namespace. Then, create a new variable and call it "app" like so:

Excel.Application app = new Excel.Application();

You can now manipulate the app object.

[Xystus777]

Excel.Application xlApp = new Excel.Application();
        Excel.Workbook xlWB;
        Excel.Worksheet xlWS;
        Excel.Range xlRng;

        string workbookPath = "C:\\Documents and Settings\\adavis\\My Documents\\Area51\\T-Numbers Data";

private void addTNumberBtn_Click(object sender, EventArgs e)
        {
            xlApp.Workbooks.Open(workbookPath, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);

            int colIndex = 0;
            string addTNumbers = addTNumberTextBox.Text;
            xlWS.Cells[1, 1] = addTNumbers;
            

            //Save the file to where you specified
            xlWB.Save();
            xlApp.Visible = true;
        }

That's what I have right now. I know how to create an excel app, but I'm having trouble with the textbox it appears. It was kind of working, but now how I want it. Now i'm getting an error about instances.

[Xav]

What is the error message?

[Xystus777]

It builds and compiles just fine, but when I run it, and click my button, it says:

Object reference not set to an instance of an object.

[Xav]

Which line of the code does it stop on?

[Xystus777]

string addTNumbers = addTNumberTextBox.Text;

[Xav]

Are you absolutely sure the text box is called addTNumberTextBox?