Oracle数据库数据导入Excel：实现数据导出与工作表设置

        private void OraToExl(string exlsqlstring, string cmbdate1, string cmbdate2)
        {
            OracleConnection oraConn = new OracleConnection(ConnString);
            try
            {
                OracleCommand oraCmd = new OracleCommand(exlsqlstring, oraConn);
                oraConn.Open();
                OracleDataReader oraDtRd;
                oraDtRd = oraCmd.ExecuteReader();

                if (oraDtRd.HasRows)
                {
                    Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
                    xlApp.Application.Visible = false;
                    Microsoft.Office.Interop.Excel.Workbook xlwb = xlApp.Workbooks._Open
                        (System.Windows.Forms.Application.StartupPath + @"\data.xls",
                        Missing.Value, Missing.Value, Missing.Value, Missing.Value,
                        Missing.Value, Missing.Value, Missing.Value, Missing.Value,
                        Missing.Value, Missing.Value, Missing.Value, Missing.Value);
                    Microsoft.Office.Interop.Excel.Worksheet xlws = (Microsoft.Office.Interop.Excel.Worksheet)
                        xlwb.Worksheets[1];
                    xlws.Select(Type.Missing);
                    Microsoft.Office.Interop.Excel.Range xlrg = null;
                    xlrg = xlws.get_Range(xlws.Cells[2, 1], xlws.Cells[xlws.Rows.Count, xlws.Columns.Count]);
                    xlrg.Select();
                    xlrg.EntireRow.Delete(Microsoft.Office.Interop.Excel.XlDeleteShiftDirection.xlShiftUp);
                    int row = 2;
                    while (oraDtRd.Read())
                    {
                        for (int col = 0; col <= 2; col++)