Excel批量插入的SQL Server

var datatble = new DataTable();
            var connectionsting = "Server=DESKTOP-GBT0AFP;Initial Catalog=Lexan;Integrated Security=SSPI;";
            var sqldataadapter = new SqlDataAdapter("select * from Student", connectionsting);
            var sqlbulkcopy = new SqlBulkCopy(connectionsting) { DestinationTableName = "Student" };
            sqldataadapter.FillSchema(datatble, SchemaType.Source);
            var xssfworkbook = new XSSFWorkbook(File.OpenRead(@"C:\Users\News\Desktop\Student.xlsx"));
            var sheetrow= xssfworkbook.GetSheetAt(0);
            for (int i = 1; i < sheetrow.LastRowNum; i++)
            {
                var tablenewrow = datatble.NewRow();
                var temprow = sheetrow.GetRow(i);
                tablenewrow[0] = temprow.Cells[0].StringCellValue;
                tablenewrow[1] = temprow.Cells[1].NumericCellValue;
                tablenewrow[2] = temprow.Cells[2].StringCellValue;
                tablenewrow[3] = temprow.Cells[3].StringCellValue;
                tablenewrow[4] = temprow.Cells[4].StringCellValue;
                tablenewrow[5] = temprow.Cells[5].DateCellValue;
                datatble.Rows.Add(tablenewrow);
            }
            sqlbulkcopy.WriteToServer(datatble);
            MessageBox.Show("写入完成！");