本人刚开始工作时,完全是一只小白,从未接触过C#,领导分配一个任务,利用Treeview和Listview对Excel进行编辑和显示。今天偶然想起来这个小程序,分享给大家。
软件效果图:
具体代码利用Oledb将Excel数据保存然后进行编辑:
string xlsname = "";
DataSet ds = new DataSet();
DataTable alldata = null;
OleDbConnection conn = null;
private void readxls(string args_xlsname)
{
string connstr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + xlsname + ";Extended Properties=\"Excel 12.0;HDR=YES;IMEX=0\";";
conn = new OleDbConnection(connstr);
{
using (OleDbDataAdapter da = new OleDbDataAdapter("Select * from [Sheet1$]", conn))//
{
da.Fill(ds, "excel");
}
}
alldata = ds.Tables[0];
//MessageBox.Show(alldata.Rows.Count.ToString());
}
/**********************************实现treeview和数据的连接********************************************************/
private void Form1_Load_1(object sender, EventArgs e)
{
OpenFileDialog ofd = new OpenFileDialog();
ofd.Filter = "EXCEL文件(*.xlsx)|*.xlsx";
if (ofd.ShowDialog() == DialogResult.OK)
{
xlsname = ofd.FileName;
}
string connstr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + xlsname;
readxls(xlsname);
DataView fist = new DataView(alldata);