error The message received from the server could not be parsed

Robbyman

New Member
So What I'm doing is creating an excel file using epplus and saving it to response.outputstreamFor some reason the code breaks giving me an error. I have no idea what I'm doing wrong.\[code\]Using package As New ExcelPackage(newFile) ' add a new worksheet to the empty workbook Dim worksheet As ExcelWorksheet = package.Workbook.Worksheets.Add("Analysis") Dim worksheet2 As ExcelWorksheet = package.Workbook.Worksheets.Add("Data") 'Add the headers worksheet.Cells(1, 2).Value = "http://stackoverflow.com/questions/13865542/Key Performance Indicators" worksheet.Cells(1, 6).Value = http://stackoverflow.com/questions/13865542/MWHtotal &"MW Hours" worksheet.Cells(2, 3).Value = "http://stackoverflow.com/questions/13865542/Before Deslag" worksheet.Cells(2, 4).Value = "http://stackoverflow.com/questions/13865542/After Deslag" worksheet.Cells(2, 5).Value = "http://stackoverflow.com/questions/13865542/Percent Change" worksheet.Cells(2, 2).Value = http://stackoverflow.com/questions/13865542/aunit worksheet.Cells(2, 6).Value = auser &" analysis" worksheet.Cells(3, 2).Value = "http://stackoverflow.com/questions/13865542/Primary SuperHeat Draft Loss" worksheet.Cells(4, 2).Value = "http://stackoverflow.com/questions/13865542/Primary SuperHeat Draft Loss Rate" worksheet.Cells(5, 2).Value = "http://stackoverflow.com/questions/13865542/Zolo FEGT" worksheet.Cells(6, 2).Value = "http://stackoverflow.com/questions/13865542/Max Ramp Rate" worksheet.Cells(7, 2).Value = "http://stackoverflow.com/questions/13865542/Max Load" worksheet.Cells(8, 2).Value = "http://stackoverflow.com/questions/13865542/Throttle Set Pressure" worksheet.Cells(9, 2).Value = "http://stackoverflow.com/questions/13865542/Water Wall Cleanliness" worksheet.Cells(10, 2).Value = "http://stackoverflow.com/questions/13865542/Platen SH Cleanliness" worksheet.Cells(11, 2).Value = "http://stackoverflow.com/questions/13865542/SSH Cleanliness" worksheet.Cells(12, 2).Value = "http://stackoverflow.com/questions/13865542/SSH Delta Temp" worksheet.Cells(13, 2).Value = "http://stackoverflow.com/questions/13865542/Primary SH Cleanliness" worksheet.Cells(14, 2).Value = "http://stackoverflow.com/questions/13865542/SHT Attemp" worksheet.Cells(15, 2).Value = "http://stackoverflow.com/questions/13865542/DP Across SSH" worksheet.Cells(16, 2).Value = "http://stackoverflow.com/questions/13865542/RH Cleanliness" worksheet.Cells(17, 2).Value = "http://stackoverflow.com/questions/13865542/RH Delta Temp" worksheet.Cells(18, 2).Value = "http://stackoverflow.com/questions/13865542/RH Attemp" worksheet.Cells(19, 2).Value = "http://stackoverflow.com/questions/13865542/DP Across RH" worksheet.Cells(20, 2).Value = "http://stackoverflow.com/questions/13865542/Boiler Efficiency" worksheet.Cells(21, 2).Value = "http://stackoverflow.com/questions/13865542/Reheat Gas Temp(Above Horiz Reheater Grid)" worksheet.Cells(22, 2).Value = "http://stackoverflow.com/questions/13865542/Econ Gas Outlet Temp" worksheet.Cells(23, 2).Value = "http://stackoverflow.com/questions/13865542/Furnace Exit Gas Temp" worksheet.Cells(24, 2).Value = "http://stackoverflow.com/questions/13865542/East FEGT" worksheet.Cells(25, 2).Value = "http://stackoverflow.com/questions/13865542/West FEGT" worksheet.Cells(26, 2).Value = "http://stackoverflow.com/questions/13865542/Secondary SuperHeat Draft Loss" worksheet.Cells(27, 2).Value = "http://stackoverflow.com/questions/13865542/Vertical ReHeat Cleanliness Factor" worksheet.Cells(28, 2).Value = "http://stackoverflow.com/questions/13865542/Air Heat Gas Outlet Temp" worksheet.Cells(29, 2).Value = "http://stackoverflow.com/questions/13865542/Total Air Flow" worksheet.Cells(30, 2).Value = "http://stackoverflow.com/questions/13865542/MW" worksheet.Cells(3, 6).Value = "http://stackoverflow.com/questions/13865542/H2O" worksheet.Cells(4, 6).Value = "http://stackoverflow.com/questions/13865542/H2O/Min" worksheet.Cells(5, 6).Value = "http://stackoverflow.com/questions/13865542/Deg F" worksheet.Cells(6, 6).Value = "http://stackoverflow.com/questions/13865542/MW/Min" worksheet.Cells(7, 6).Value = "http://stackoverflow.com/questions/13865542/MW" worksheet.Cells(8, 6).Value = "http://stackoverflow.com/questions/13865542/Psig" worksheet.Cells(9, 6).Value = "http://stackoverflow.com/questions/13865542/Percent" worksheet.Cells(10, 6).Value = "http://stackoverflow.com/questions/13865542/Percent" worksheet.Cells(11, 6).Value = "http://stackoverflow.com/questions/13865542/Percent" worksheet.Cells(12, 6).Value = "http://stackoverflow.com/questions/13865542/Deg F" worksheet.Cells(13, 6).Value = "http://stackoverflow.com/questions/13865542/Percent" worksheet.Cells(14, 6).Value = "http://stackoverflow.com/questions/13865542/lb/hr" worksheet.Cells(15, 6).Value = "http://stackoverflow.com/questions/13865542/H2O" worksheet.Cells(16, 6).Value = "http://stackoverflow.com/questions/13865542/Percent" worksheet.Cells(17, 6).Value = "http://stackoverflow.com/questions/13865542/Deg F" worksheet.Cells(18, 6).Value = "http://stackoverflow.com/questions/13865542/lb/hr" worksheet.Cells(19, 6).Value = "http://stackoverflow.com/questions/13865542/H2O" worksheet.Cells(20, 6).Value = "http://stackoverflow.com/questions/13865542/Percent" worksheet.Cells(21, 6).Value = "http://stackoverflow.com/questions/13865542/Deg F" worksheet.Cells(22, 6).Value = "http://stackoverflow.com/questions/13865542/Deg F" worksheet.Cells(23, 6).Value = "http://stackoverflow.com/questions/13865542/Deg F" worksheet.Cells(24, 6).Value = "http://stackoverflow.com/questions/13865542/Deg F" worksheet.Cells(25, 6).Value = "http://stackoverflow.com/questions/13865542/Deg F" worksheet.Cells(26, 6).Value = "http://stackoverflow.com/questions/13865542/H2O" worksheet.Cells(27, 6).Value = "http://stackoverflow.com/questions/13865542/Percent" worksheet.Cells(28, 6).Value = "http://stackoverflow.com/questions/13865542/Deg F" worksheet.Cells(29, 6).Value = "http://stackoverflow.com/questions/13865542/KPPH" worksheet.Cells(30, 6).Value = "http://stackoverflow.com/questions/13865542/MW" arraycol = 0 arrayrow = 0 For i = 0 To pdata.Count worksheet2.Cells(arrayrow + 1, arraycol + 1).Value = http://stackoverflow.com/questions/13865542/PIArray(arrayrow, arraycol) Next worksheet.Cells(3, 3).Value = wa worksheet.Cells(4, 3).Value = za worksheet.Cells(5, 3).Value = ua worksheet.Cells(6, 3).Value = amaxrate worksheet.Cells(7, 3).Value = amax worksheet.Cells(8, 3).Value = ta worksheet.Cells(9, 3).Value = aa worksheet.Cells(10, 3).Value = ba worksheet.Cells(11, 3).Value = ca worksheet.Cells(12, 3).Value = da worksheet.Cells(13, 3).Value = ea worksheet.Cells(14, 3).Value = fa worksheet.Cells(15, 3).Value = ga worksheet.Cells(16, 3).Value = ha worksheet.Cells(17, 3).Value = ia worksheet.Cells(18, 3).Value = ja worksheet.Cells(19, 3).Value = ka worksheet.Cells(20, 3).Value = la worksheet.Cells(21, 3).Value = ma worksheet.Cells(22, 3).Value = na worksheet.Cells(23, 3).Value = oa worksheet.Cells(24, 3).Value = qa worksheet.Cells(25, 3).Value = ra worksheet.Cells(26, 3).Value = xa worksheet.Cells(27, 3).Value = ya worksheet.Cells(28, 3).Value = pa worksheet.Cells(29, 3).Value = sa worksheet.Cells(30, 3).Value = va worksheet.Cells(3, 4).Value = wb worksheet.Cells(4, 4).Value = zb worksheet.Cells(5, 4).Value = ub worksheet.Cells(9, 4).Value = ab worksheet.Cells(10, 4).Value = bb worksheet.Cells(11, 4).Value = cb worksheet.Cells(12, 4).Value = db worksheet.Cells(13, 4).Value = eb worksheet.Cells(14, 4).Value = fb worksheet.Cells(15, 4).Value = gb worksheet.Cells(16, 4).Value = hb worksheet.Cells(17, 4).Value = ib worksheet.Cells(18, 4).Value = jb worksheet.Cells(19, 4).Value = kb worksheet.Cells(20, 4).Value = lb worksheet.Cells(21, 4).Value = mb worksheet.Cells(22, 4).Value = nb worksheet.Cells(23, 4).Value = ob worksheet.Cells(24, 4).Value = qb worksheet.Cells(25, 4).Value = rb worksheet.Cells(26, 4).Value = xb worksheet.Cells(27, 4).Value = yb worksheet.Cells(28, 4).Value = pb worksheet.Cells(29, 4).Value = sb worksheet.Cells(30, 4).Value = vb worksheet.Cells(3, 5).Value = wpercent worksheet.Cells(4, 5).Value = zpercent worksheet.Cells(5, 5).Value = upercent worksheet.Cells(9, 5).Value = apercent worksheet.Cells(10, 5).Value = bpercent worksheet.Cells(11, 5).Value = cpercent worksheet.Cells(12, 5).Value = dpercent worksheet.Cells(13, 5).Value = epercent worksheet.Cells(14, 5).Value = fpercent worksheet.Cells(15, 5).Value = gpercent worksheet.Cells(16, 5).Value = hpercent worksheet.Cells(17, 5).Value = ipercent worksheet.Cells(18, 5).Value = jpercent worksheet.Cells(19, 5).Value = kpercent worksheet.Cells(20, 5).Value = lpercent worksheet.Cells(21, 5).Value = mpercent worksheet.Cells(22, 5).Value = npercent worksheet.Cells(23, 5).Value = opercent worksheet.Cells(24, 5).Value = qpercent worksheet.Cells(25, 5).Value = rpercent worksheet.Cells(26, 5).Value = xpercent worksheet.Cells(27, 5).Value = ypercent worksheet.Cells(28, 5).Value = ppercent worksheet.Cells(29, 5).Value = spercent worksheet.Cells(30, 5).Value = vpercent worksheet.Cells(3, 7).Value = wcolor worksheet.Cells(4, 7).Value = zcolor worksheet.Cells(5, 7).Value = ucolor worksheet.Cells(9, 7).Value = acolor worksheet.Cells(10, 7).Value = bcolor worksheet.Cells(11, 7).Value = ccolor worksheet.Cells(12, 7).Value = dcolor worksheet.Cells(13, 7).Value = ecolor worksheet.Cells(14, 7).Value = fcolor worksheet.Cells(15, 7).Value = gcolor worksheet.Cells(16, 7).Value = hcolor worksheet.Cells(17, 7).Value = icolor worksheet.Cells(18, 7).Value = jcolor worksheet.Cells(19, 7).Value = kcolor worksheet.Cells(20, 7).Value = lcolor worksheet.Cells(21, 7).Value = mcolor worksheet.Cells(22, 7).Value = ncolor worksheet.Cells(23, 7).Value = ocolor worksheet.Cells(24, 7).Value = qcolor worksheet.Cells(25, 7).Value = rcolor worksheet.Cells(26, 7).Value = xcolor worksheet.Cells(27, 7).Value = ycolor worksheet.Cells(28, 7).Value = pcolor worksheet.Cells(29, 7).Value = scolor worksheet.Cells(30, 7).Value = vcolor Response.Clear() Response.ContentType ="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" Response.AppendHeader("Content-Disposition", "attachment;filename=analyze.xlsx") package.SaveAs(Response.OutputStream) Response.End() End Using\[/code\]I get this error0x800a139e - Microsoft JScript runtime error: Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed.
 
Back
Top