C#操作Excel表格
在Windows窗体中，设置了一个文本框Textbox1以及两个按钮button1和button2。点击button1选择Excel文件，点击button2执行相关处理。代码片段如下：C# private void button1_click(object sendeer,EventArgs e) { OpenFileDialog openFiledialog1=new OpenFileDialog(); openFileDialg1.filter="Excel文件|*.xls"; openFileDialg1.ShowDialog(); textBox1.Text=openFileDialog1.FileName; } private void button2_click(object sender, EventArg e) { DataSet dt=ReadExcel(textBox1.Text); //然后进行您需要的数据处理}
文件大小：588B
评论区