コード例 #1
0
        private void mostrarFila(object sender, EventArgs e)
        {
            exportaContaSis.RowProcessedEventArgs argumentos = (exportaContaSis.RowProcessedEventArgs)e;
            if (pgbProceso.Maximum == 0)
            {
                pgbProceso.Maximum = argumentos.total;
            }

            pgbProceso.Value = argumentos.numero; //.ToString();



            Application.DoEvents();
        }
コード例 #2
0
        private bool generaExcel2(string ruta)
        {
            try
            {
                if (File.Exists(ruta + "regventas.xls") == true)
                {
                    File.Delete(ruta + "regventas.xls");
                }

                Excel.Application myApp;

                Excel.Workbook myWorkBk;

                object missingValue = System.Reflection.Missing.Value;

                myApp = new Microsoft.Office.Interop.Excel.Application();

                myApp.Visible = false;

                myWorkBk = myApp.Workbooks.Add(missingValue);

                Excel.Worksheet myWorkSht;

                myWorkSht = (Excel.Worksheet)myWorkBk.Worksheets.get_Item(1);

                myWorkSht.Name = "RegVentas";

                int nroFilas    = 0;
                int nroColumnas = 0;

                nroFilas    = datos.Rows.Count;
                nroColumnas = datos.Columns.Count;

                Excel.Range rango;



                for (int i = 1; i <= nroFilas; i++)
                {
                    RowProcessedEventArgs argumentos = new RowProcessedEventArgs();
                    argumentos.numero = i;
                    argumentos.total  = nroFilas;
                    filaprocesada(this, argumentos);
                    for (int j = 1; j < nroColumnas; j++)
                    {
                        //poner el valor en la celda
                        //formato de texto
                        switch (j)
                        {
                        case 1:
                        case 2:
                        case 18:
                        case 24:
                        case 36:
                            rango = myWorkSht.Range[myWorkSht.Cells[i, j], myWorkSht.Cells[i, j]];
                            rango.NumberFormat = "dd/mm/yyyy";
                            break;

                        case 3:
                        case 4:
                        case 5:
                        case 6:
                        case 7:
                        case 8:
                        case 19:
                        case 20:
                        case 21:
                        case 22:
                        case 25:
                        case 26:
                        case 27:
                        case 28:
                        case 29:
                        case 30:
                        case 34:
                        case 35:
                        case 37:
                        case 39:
                            rango = myWorkSht.Range[myWorkSht.Cells[i, j], myWorkSht.Cells[i, j]];
                            rango.NumberFormat = "@";
                            break;

                        case 9:
                        case 10:
                        case 11:
                        case 12:
                        case 13:
                        case 14:
                        case 15:
                        case 16:
                        case 23:
                        case 32:
                        case 33:
                        case 38:
                            rango = myWorkSht.Range[myWorkSht.Cells[i, j], myWorkSht.Cells[i, j]];
                            rango.NumberFormat = "0.00";
                            break;

                        case 17:
                            rango = myWorkSht.Range[myWorkSht.Cells[i, j], myWorkSht.Cells[i, j]];
                            rango.NumberFormat = "0.0000";
                            break;
                        }

                        if (cancelaProceso == true)
                        {
                            return(false);
                        }

                        myWorkSht.Cells[i, j] = datos.Rows[i - 1][j - 1];
                    }
                }

                myWorkSht.SaveAs(ruta + "regventas.xls");

                myApp.Visible = true;

                return(true);
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                throw ex;
            }
        }