如何将文本框值导出到Excel工作表? [英] How to export textbox values to excel sheet?

问题描述

我想添加一个文本框的值并导出到excel工作表..该怎么做?

I want to add values of a textbox and export to excel sheet..how can it be done?

推荐答案

Google给了我这个:

Google gave me this:

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;
}

这篇关于如何将文本框值导出到Excel工作表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！