winformNPOI导入导出

        public Form1()
        {
            InitializeComponent();
        }
        private ManagerInfoBll miBll = new ManagerInfoBll();
        private void Form1_Load(object sender, EventArgs e)
        {
            LoadList();
        }
        private void LoadList()
        {
            //列自适应
            dgvList.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
            //禁用列表的自动生成
            dgvList.AutoGenerateColumns = false;
            dgvList.DataSource = miBll.GetList();
        }

        /// <summary>
        /// NPOI导出，个性化设置
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button1_Click(object sender, EventArgs e)
        {
            //进行execl生成创建操作
            //1、创建workBook，不指定参数，表示创建一个新的工作本
            XSSFWorkbook wb = new XSSFWorkbook();