RSS

A Message Board, Guestbook, or Poll hosted for your website.
Iron Speed Technical Forums

Register Login New Posts Chat
 
Iron Speed > Forums > Using Iron Speed Designer V6.X > aspose.cells
 
Username:  
Password:  
 
   
 


Thread Tools Search This Thread 
Reply
 
Author Comment
 
AltVader
Registered: 05/21/09
Posts: 48

    07/07/09 at 10:35 PMReply with quote#1

I'm using IS for a project, and have the need for significant manipulation of excel files. I've found a great product for this, aspose.cells. I am attempting to open a spreadsheet, then stream it directly to the client browser as a pdf (without saving it to a file). This is actually done in 2 lines of code with aspose:

'Output to PDF
workbook.Save("Report.pdf", SaveType.OpenInBrowser, FileFormatType.Pdf, Response)
Response.End()

The problem is this code works perfectly in a non-IS project, but I get a "can't parse response" error within Iron Speed. Incidentally, the "response" parameter has to be changed to me.page.response.

I don't expect anyone to dig into aspose cells for me, but I'm hoping you'll see a solution regardless.

Thanks,
da
dingjing
Avatar / Picture

MVP Developer
Registered: 02/28/06
Posts: 1,464

    07/08/09 at 06:48 AMReply with quote#2

Turn off SmoothPanelUpdate.
akeshgupta
Avatar / Picture

Iron Speed MVP
Consulting Organization

Registered: 04/25/04
Posts: 4,244

    07/08/09 at 07:02 AMReply with quote#3

To add to Jing's idea, you can always enable full post back on the button by adding an attribute of PostBack with value of True which might work.




__________________
Akesh Gupta
Iron Speed Designer MVP
Enterprise Solutions Architect
ExecuTrain of Long Island (http://www.etli.com)
Light Speed Solutions (http://www.lightspeedsolutions.com)

If I rest, I will rust ! Let's share the knowledge !
AltVader
Registered: 05/21/09
Posts: 48

    07/08/09 at 07:15 AMReply with quote#4

Thanks very much. Setting SmoothPanelUpdate to false did the trick.

I'll ask you another question though:  I have a themed button in a table row running custom code to generate this excel spreadsheet (by getting SQL Server field values), then output it as a pdf to the client browser. It's now working great, but I'd greatly prefer if the output went to a new browser window (or tab). The IS articles I've read seem to suggest this can't be done. Any suggestions?

da
AltVader
Registered: 05/21/09
Posts: 48

    08/27/09 at 12:06 AMReply with quote#5

Akesh,

It's been since July when you posted the suggestion:

"To add to Jing's idea, you can always enable full post back on the button by adding an attribute of PostBack with value of True which might work."
I just want you to know that turned out to be a great solution which I would have NEVER found by myself. The errors returned executing in VS2008 indicated something was wrong in my response, like a bad response.write, but I have yet to find the postback=True attribute documented in Iron Speed.
 
So, here's to you Sport! Six weeks later and I remain truly grateful.
 
da
 


Previous Thread | Next Thread
Reply

  Bookmarks  
Digg Diggdel.icio.us del.icio.usStumbleUpon StumbleUponGoogle Google

Download Iron Speed Designer

Privacy Statement