Hello Lotus experts,
We have problem with exporting documents to Excel (browser). When we generate a report with more than 1000 documents we are getting below error message i.e. ‘insufficient memory - local heap is full’. If we select less than 1000 documents then it works fine.
Please suggest any other ways to export all the documents to Excel (browser client) like XML or Java etc…
Looking forward to hear you soon
Thanks
-SS
Subject: insufficient memory - local heap is full
I’m not sure what is causing your error. You will need to give more details if you want help with that.
With respect to pushing data to excel over the web, I have had a lot of success using the Excel Web Connectivity Toolkit. There used to be some documentation available from MS but I couldn’t find a link to send you. Excel understands some extensions to html that allow you to specify rows and columns including formatting and even allows you to push excel formulas into cells.
There is some info here->Building an Excel Spreadsheet using ASP
I will see if I can find a better sample to post.
All you need to do is write an agent that wraps your data in the correct html tags. You can specify a Content-Type that will automatically load excel in the browser.
Good luck.