How to insert C# textbox value to excel specific cell

Paul Mercado

I need to insert textbox values when i click a button from my windows application to specific cells of my existing excel file. I am using C# winforms.

For example:

textbox1 value to be inserted into excel B28 cell,

textbox2 value to be inserted into excel F36 cell,

textbox3 value to be inserted into excel C31 cell,

I am a newbie in C# programming.

Thank you for your help.

3 Replies

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

Uehara Ayaka4y ago
You could also try Free Spire.XLS for .NET to write data into specific cells.
using Spire.Xls;

namespace WriteData
{
    class Program
    {
        static void Main(string[] args)
        {
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"‪C:\Users\Administrator\Desktop\Source.xlsx");
            Worksheet sheet = workbook.Worksheets[0];
sheet.Range["A1"].Value = textbox1.text;
        }
    }
}
Srinivasan Ramamoorthi4y ago
Use interop or aspos for writing data into excel
Sachin Singh4y ago
It is as simple as
worksheet.Cells[rownumber,columnnumber]="value";

Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
Workbook workbook = excel.Workbooks.Open("folderpath/myExcel.xlsx", ReadOnly: false, Editable: true);
Worksheet worksheet = workbook.Worksheets.Item[1] as Worksheet;
if (worksheet == null)
return;
worksheet.Cells[28, 2] = textbox1.Text;  // A=1 and Z=26