private void BT_exportar_Click(object sender, EventArgs e)
        {
            DateTime F_ini, F_fin;
            string   inicio = "", fin = "";

            F_ini = DT_inicio.Value;
            F_fin = DT_fin.Value;

            inicio = F_ini.ToLongDateString();
            fin    = F_fin.ToLongDateString();


            Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
            excel.Application.Workbooks.Add(true);



            int indiceColumna = 0;

            foreach (DataGridViewColumn col in DG_comisiones.Columns)
            {
                indiceColumna++;
                excel.Cells[5, indiceColumna] = col.Name;
            }

            int indiceFila = 4;

            foreach (DataGridViewRow row in DG_comisiones.Rows)
            {
                indiceFila++;
                indiceColumna = 0;



                foreach (DataGridViewColumn col in DG_comisiones.Columns)
                {
                    indiceColumna++;

                    excel.Cells[indiceFila + 1, indiceColumna] = row.Cells[col.Name].Value;
                }
            }

            excel.Cells.Range["A4:J4"].Merge();
            excel.Cells.Range["A4"].Value = "COMISIONES DE LA SEMANA DEL    " + inicio.ToUpper() + "   AL    " + fin.ToUpper();

            excel.Cells.Range["K17"].Value           = "TOTAL INCENTIVO =";
            excel.Cells.Range["L17"].Value           = getIncentivo();
            excel.Cells.Range["K18"].Value           = "TOTAL COMISION =";
            excel.Cells.Range["L18"].Value           = getTotal();
            excel.Cells.Range["B6:I16"].NumberFormat = "$#,##0.00";
            excel.Cells.Range["I6:I16"].NumberFormat = "$#,##0.00";
            excel.Cells.Range["J6:J16"].NumberFormat = "$#,##0.00";
            excel.Cells.Range["K6:K16"].NumberFormat = "$#,##0.00";
            excel.Cells.Range["L6:L16"].NumberFormat = "$#,##0.00";

            excel.Visible = true;
        }
Esempio n. 2
0
        public void ExportarExcel()
        {
            DateTime F_ini, F_fin;
            string   inicio = "", fin = "";

            F_ini = DT_inicio.Value;
            F_fin = DT_fin.Value;

            inicio = F_ini.ToLongDateString();
            fin    = F_fin.ToLongDateString();


            Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
            excel.Application.Workbooks.Add(true);



            int indiceColumna = 0;

            foreach (DataGridViewColumn col in DG_comisiones.Columns)
            {
                indiceColumna++;
                excel.Cells[5, indiceColumna] = col.Name;
            }

            int indiceFila = 4;

            foreach (DataGridViewRow row in DG_comisiones.Rows)
            {
                indiceFila++;
                indiceColumna = 0;



                foreach (DataGridViewColumn col in DG_comisiones.Columns)
                {
                    indiceColumna++;

                    excel.Cells[indiceFila + 1, indiceColumna] = row.Cells[col.Name].Value;
                }
            }

            excel.Cells.Range["A4:J4"].Merge();
            excel.Cells.Range["A4"].Value            = "COMISIONES DEL    " + inicio.ToUpper() + "   AL    " + fin.ToUpper();
            excel.Cells.Range["A5:Q25"].Font.Size    = 9;
            excel.Cells.Range["D6:Q25"].NumberFormat = "$#,##0.00";
            excel.Cells.Range["A30:B30"].Merge();
            excel.Cells.Range["A30"].NumberFormat = "$#,##0.00";
            excel.Cells.Range["A30"].Value        = "Total a pagar " + TB_total.Text;



            excel.Visible = true;
        }