title: open files from output stream
body: <p>I'm trying to save my chart image so that I can put it into an excel file created using epplus</p>
  
  <pre><code>Response.ContentType = "image/bmp"
      Response.AppendHeader("Content-Disposition", "attachment;filename=chart.bmp")
      Chart1.SaveImage(Response.OutputStream)
  
      Dim imgchart As Bitmap
      imgchart = New Bitmap("chart.bmp")
  
  Using package As New ExcelPackage(newFile)
          ' add a new worksheet to the empty workbook
          Dim worksheet As ExcelWorksheet = package.Workbook.Worksheets.Add("LIMS")
          'Add the headers
          worksheet.Cells(1, 1).Value = "Analyzer Time"
          worksheet.Cells(1, 2).Value = "Analyzer Data"
          worksheet.Cells(1, 3).Value = "Lab Date"
          worksheet.Cells(1, 4).Value = "Lab Data"
          Dim row
          row = 2
          For i = 0 To count1 - 1
              worksheet.Cells(row, 1).Value = col1(i)
              worksheet.Cells(row, 2).Value = col2(i)
              row = row + 1
          Next
          row = 2
          For i = 0 To labcount - 1
              worksheet.Cells(row, 3).Value = col3(i)
              worksheet.Cells(row, 4).Value = col4(i)
              row = row + 1
          Next
  
          worksheet.Drawings.AddPicture("chart", imgchart)
          Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
          Response.AppendHeader("Content-Disposition", "attachment;filename=chart.xlsx")
          package.SaveAs(Response.OutputStream)
  
          Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
          Response.AppendHeader("Content-Disposition", "attachment;filename=chart.xlsx")
          Response.WriteFile("chart.xlsx")
          Response.End()
      End Using
  </code></pre>
  
  <p>What do I need to fix in this code? I'm new to file streams and response.</p>