Asp.Net OWCでExcelのインスタンスコードを操作する

 
  
    string connstr = System.Configuration.ConfigurationManager.ConnectionStrings["DqpiHrConnectionString"].ToString(); 
  
        SqlConnection conn = new SqlConnection(connstr); 
  
        SqlDataAdapter sda = new SqlDataAdapter(sql1.Text, conn); 
  
        DataSet ds = new DataSet(); 
  
        conn.Open(); 
  
        sda.Fill(ds); 
  
        conn.Close(); 
  
        OWC10.SpreadsheetClass xlsheet; 
  
        xlsheet= new OWC10.SpreadsheetClass(); 
  
        DataRow dr; 
  
        int i = 0; 
  
        for(int ii=0;ii        { 
  
            dr = ds.Tables[0].Rows[ii]; 
  
            //      
  
            xlsheet.get_Range(xlsheet.Cells[i+1, 1], xlsheet.Cells[i+1, 8]).set_MergeCells(true); 
  
            xlsheet.get_Range(xlsheet.Cells[i + 5, 1], xlsheet.Cells[i + 5, 3]).set_MergeCells(true); 
  
            xlsheet.get_Range(xlsheet.Cells[i + 5, 4], xlsheet.Cells[i + 5, 6]).set_MergeCells(true); 
  
            xlsheet.get_Range(xlsheet.Cells[i + 5, 7], xlsheet.Cells[i + 5, 8]).set_MergeCells(true); 
  
            xlsheet.ActiveSheet.Cells[i + 1, 1] = dr["  "].ToString() + "    "; 
  
            //     
  
            xlsheet.get_Range(xlsheet.Cells[i + 1, 1], xlsheet.Cells[i + 1, 14]).Font.set_Bold(true); 
  
            //            
  
            xlsheet.get_Range(xlsheet.Cells[i + 1, 1], xlsheet.Cells[i + 1, 14]).set_HorizontalAlignment(OWC10.XlHAlign.xlHAlignCenter); 
  
            //       
  
            xlsheet.get_Range(xlsheet.Cells[i + 1, 1], xlsheet.Cells[i + 1, 14]).Font.set_Size(14); 
  
            //     
  
            xlsheet.get_Range(xlsheet.Cells[i + 1, 8], xlsheet.Cells[i + 1, 8]).set_ColumnWidth(20); 
  
            //     
  
            xlsheet.get_Range(xlsheet.Cells[i + 1, 1], xlsheet.Cells[i+5, 8]).Borders.set_LineStyle(OWC10.XlLineStyle.xlContinuous); 
  
            //      (   DS  ) 
  
            xlsheet.ActiveSheet.Cells[i + 2, 1] = "  "; 
  
            xlsheet.ActiveSheet.Cells[i + 2, 2] = dr["  "].ToString(); 
  
            xlsheet.ActiveSheet.Cells[i + 2, 3] = "   "; 
  
            xlsheet.ActiveSheet.Cells[i + 2, 4] = dr["   "].ToString(); 
  
            xlsheet.ActiveSheet.Cells[i + 2, 5] = "    "; 
  
            xlsheet.ActiveSheet.Cells[i + 2, 6] = DateTime.Parse(dr["    "].ToString()).Year.ToString() + "-" + DateTime.Parse(dr["    "].ToString()).Month.ToString(); 
  
            xlsheet.ActiveSheet.Cells[i + 2, 7] = "       "; 
  
            xlsheet.ActiveSheet.Cells[i + 2, 8] = DateTime.Parse(dr["      "].ToString()).Year.ToString() + "-" + DateTime.Parse(dr["      "].ToString()).Month.ToString(); 
  
            xlsheet.ActiveSheet.Cells[i + 3, 1] = "  "; 
  
            xlsheet.ActiveSheet.Cells[i + 3, 2] = dr["  "].ToString(); 
  
            xlsheet.ActiveSheet.Cells[i + 3, 3] = "  "; 
  
            xlsheet.ActiveSheet.Cells[i + 3, 4] = dr["  "].ToString(); 
  
            xlsheet.ActiveSheet.Cells[i + 3, 5] = "    "; 
  
            xlsheet.ActiveSheet.Cells[i + 3, 6] = dr["    "].ToString(); 
  
            xlsheet.ActiveSheet.Cells[i + 3, 7] = "  "; 
  
            xlsheet.ActiveSheet.Cells[i + 3, 8] = dr["  "].ToString(); 
  
            xlsheet.ActiveSheet.Cells[i + 4, 1] = "  "; 
  
            xlsheet.ActiveSheet.Cells[i + 4, 2] = dr["  "].ToString(); 
  
            xlsheet.ActiveSheet.Cells[i + 4, 3] = "  "; 
  
            xlsheet.ActiveSheet.Cells[i + 4, 4] = dr["  "].ToString(); 
  
            xlsheet.ActiveSheet.Cells[i + 4, 5] = "  "; 
  
            xlsheet.ActiveSheet.Cells[i + 4, 6] = dr["  "].ToString(); 
  
            xlsheet.ActiveSheet.Cells[i + 4, 7] = "    "; 
  
            //Excel   0    ，               
  
            xlsheet.ActiveSheet.Cells[i + 4, 8] = dr["     "].ToString() + dr["    "].ToString(); 
  
            xlsheet.ActiveSheet.Cells[i + 5, 1] = "     ：" + dr["     "].ToString(); 
  
            xlsheet.ActiveSheet.Cells[i + 5, 4] = "    ：" + dr["    "].ToString(); 
  
            xlsheet.ActiveSheet.Cells[i + 5, 7] = "   ：" + dr["    "].ToString(); 
  
            i += 6; 
  
        } 
  
        try 
  
        { 
  
            string D = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + 
  
            DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString()+ 
  
            DateTime.Now.Millisecond.ToString(); 
  
            xlsheet.Export(Server.MapPath("./")+"\\"+D+".xls", OWC10.SheetExportActionEnum.ssExportActionNone, OWC10.SheetExportFormat.ssExportXMLSpreadsheet); 
  
            Response.Write("window.open('"+D+".xls')"); 
  
        } 
  
        catch 
  
        { 
  
        } 
  
    }