asp读取xls导入数据库

using System;
using System.Data;
using System.Data.SqlClient;
using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;

public void ImportXLSToDatabase(string filePath)
{
    using (FileStream fileStream = new FileStream(filePath, FileMode.Open, FileAccess.Read))
    {
        HSSFWorkbook workbook = new HSSFWorkbook(fileStream);
        ISheet sheet = workbook.GetSheetAt(0);

        using (SqlConnection connection = new SqlConnection("YourConnectionString"))
        {
            connection.Open();

            foreach (IRow row in sheet)
            {
                ICell cell = row.GetCell(0);
                string data = cell.StringCellValue;

                string sql = "INSERT INTO YourTable (ColumnName) VALUES (@Data)";
                using (SqlCommand command = new SqlCommand(sql, connection))
                {
                    command.Parameters.AddWithValue("@Data", data);
                    command.ExecuteNonQuery();
                }
            }
        }
    }
}