예제 #1
0
        public void ImproExcel()
        {
            SaveFileDialog sdfExport = new SaveFileDialog();

            sdfExport.Filter = "Excel 97-2003文件|*.xls|Excel 2007文件|*.xlsx";
            //   sdfExport.ShowDialog();

            if (sdfExport.ShowDialog() != DialogResult.OK)
            {
                return;
            }

            String      filename  = sdfExport.FileName;
            NPOIProgram NPOIexcel = new NPOIProgram();
            DataTable   tabl      = new DataTable();

            tabl = GetDgvToTable(dgvStyleCode);


            // DataTable dt = (StyleCodeInfodataGridView.DataSource as DataTable);
            NPOIexcel.ExcelWrite(filename, tabl);//excelhelper写出
            if (MessageBox.Show("导出成功,文件保存在" + filename.ToString()
                                + ",是否打开此文件?", "提示", MessageBoxButtons.YesNo) ==
                DialogResult.Yes)
            {
                if (File.Exists(filename))   //文件是否存在
                {
                    Process.Start(filename); //执行打开导出的文件
                }
                else
                {
                    MessageBox.Show("文件不存在!", "提示");
                }
            }
        }
예제 #2
0
        /// <summary>
        /// 导出整表
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnExportToExcel_Click(object sender, EventArgs e)
        {
            SaveFileDialog sdfExport = new SaveFileDialog();

            sdfExport.Filter = "Excel 97-2003文件|*.xls|Excel 2007文件|*.xlsx";
            //   sdfExport.ShowDialog();

            if (sdfExport.ShowDialog() != DialogResult.OK)
            {
                return;
            }

            String      filename  = sdfExport.FileName;
            NPOIProgram NPOIexcel = new NPOIProgram();

            //  DataTable tab1 = new DataTable();
            #region 生成表
            DataTable dt = new DataTable();

            dt.Columns.Add("指令数");  //仓库指令数
            dt.Columns.Add("指令数量"); //满箱指令数

            dt.Columns.Add("箱数");   //未满指令数
            dt.Columns.Add("箱数量");  //指令箱数

            dt.Columns.Add("双数");   //仓库箱数
            dt.Columns.Add("双数量");  //欠库箱数

            dt.Columns.Add("单箱数");  //指令总双数
            dt.Columns.Add("单箱数量"); //仓库总双数

            dt.Columns.Add("单双数");  //总欠库双数
            dt.Columns.Add("单双数量"); //单指令箱数
            //给值
            //行1
            DataRow dtrow1 = dt.NewRow();
            dtrow1["指令数"]  = "仓库指令数";
            dtrow1["指令数量"] = labsumcoutom.Text;

            dtrow1["箱数"]  = "指令箱数";
            dtrow1["箱数量"] = labsumcodebox.Text;

            dtrow1["双数"]  = "指令总双数";
            dtrow1["双数量"] = labcodecount.Text;

            dtrow1["单箱数"]  = "单指令箱数";
            dtrow1["单箱数量"] = labcustomcountbox.Text;

            dtrow1["单双数"]  = "单指令双数";
            dtrow1["单双数量"] = labcustomcount.Text;
            dt.Rows.Add(dtrow1);

            //行2
            DataRow dtrow2 = dt.NewRow();
            dtrow2["指令数"]  = "满箱指令数";
            dtrow2["指令数量"] = labsumokbox.Text;

            dtrow2["箱数"]  = "仓库箱数";
            dtrow2["箱数量"] = labsumbox.Text;

            dtrow2["双数"]  = "仓库总双数";
            dtrow2["双数量"] = labpdcount.Text;

            dtrow2["单箱数"]  = "单指令库存箱";
            dtrow2["单箱数量"] = labpdboxcount.Text;

            dtrow2["单双数"]  = "单指令库存双";
            dtrow2["单双数量"] = labsumcount.Text;
            dt.Rows.Add(dtrow2);
            //行3
            DataRow dtrow3 = dt.NewRow();
            dtrow3["指令数"]  = "未满指令数";
            dtrow3["指令数量"] = labsumnobox.Text;

            dtrow3["箱数"]  = "欠库箱数";
            dtrow3["箱数量"] = labsumcodenobox.Text;

            dtrow3["双数"]  = "总欠库双数";
            dtrow3["双数量"] = labnopdcount.Text;

            dtrow3["单箱数"]  = "单指令欠库箱";
            dtrow3["单箱数量"] = labpdnoboxcount.Text;

            dtrow3["单双数"]  = "单指令欠库双";
            dtrow3["单双数量"] = labnosumcount.Text;
            dt.Rows.Add(dtrow3);

            #endregion
            NPOIexcel.ExcelWrite(filename, dt);//excelhelper写出
            if (MessageBox.Show("导出成功,文件保存在" + filename.ToString()
                                + ",是否打开此文件?", "提示", MessageBoxButtons.YesNo) ==
                DialogResult.Yes)
            {
                if (File.Exists(filename))   //文件是否存在
                {
                    Process.Start(filename); //执行打开导出的文件
                }
                else
                {
                    MessageBox.Show("文件不存在!", "提示");
                }
            }
        }