excel导出问题 ·····下面这个方法哪不对？

Question

 /// <summary>
        /// 把内存中的信息插入到Execl的Sheet表中
        /// </summary>
        /// <param name="Name"></param>
        /// <param name="conn"></param>
        /// <param name="TableColumnNames"></param>
        /// <param name="SheetTableColumnNames"></param>
        /// <returns></returns>
        public void InsertToTable(string Name, string conn, DataTable TableColumnNames, List<string> SheetTableColumnNames)
        {
            string temp = " insert into [" + Name + "](";
            string temps = "";
            string tempe = "";
            OleDbParameter[] param = new OleDbParameter[SheetTableColumnNames.Count];
            foreach (DataRow dr in TableColumnNames.Rows)
            {
                for (int t = 0; t < SheetTableColumnNames.Count; t++)
                {
                    if (t == 0)
                    {
                        temps = "[" + SheetTableColumnNames[t] + "]";
                        tempe = "@" + TableColumnNames.Columns[t].ColumnName;
                    }
                    else
                    {
                        temps = temps + ",[" + SheetTableColumnNames[t] + "]";
                        tempe = tempe + ",@" + TableColumnNames.Columns[t].ColumnName;
                    }
                }
            }

            temp = temp + temps + ") values (" + tempe + ")";

            for (int b = 0; b < SheetTableColumnNames.Count; b++)
            {
                param[b] = new OleDbParameter("@" + TableColumnNames.Columns[b].ColumnName, OleDbType.VarChar, 255);
                param[b].SourceColumn = TableColumnNames.Columns[b].ColumnName;
            }


            try
            {
                using (OleDbConnection oledbconnection = new OleDbConnection(conn))
                {
                    oledbconnection.Open();
                    OleDbCommand oledbcommand = new OleDbCommand();
                    oledbcommand.Connection = oledbconnection;
                    oledbcommand.CommandType = CommandType.Text;
                    oledbcommand.CommandText = temp;

                    foreach (OleDbParameter p in param)
                        oledbcommand.Parameters.Add(p);

                    OleDbDataAdapter adp = new OleDbDataAdapter();
                    OleDbCommandBuilder cb = new OleDbCommandBuilder(adp);
                    DataSet ds = new DataSet();
                    adp.SelectCommand = oledbcommand;
                    adp.InsertCommand = oledbcommand;
                    int i = adp.Update(TableColumnNames);
                    oledbconnection.Close();
                }
            }
            catch (Exception)
            {

                throw;
            }


        }

Answer 1

oledb只能读excel不能写，用npoi这个库去写excel