Example of xelem to Export Excel from HTML

Hi ericpete, ok this is what i trying to do is create a workbook in excel from data in a database, the same data is presented in html using the same data, i create reports in html thats work fine, then when i made this code to generate a excel version of the same data as a option in the same html report (export to excel option) i use this code to generate the workbook, this code works in a not web java application, but how send out stream of this excel objet by a web browser?

ofonck,

Hopefully, we can get an Excel expert in here to help us -- I can use Excel, but I'm not at all versed in its capabilities.

If I understand it correctly:

You have a database, and you're trying to use Java to create an Excel spreadsheet. Is that correct?

If it is, then I would approach it from a different direction. Can you export the data from the database as (for example) a CSV file, and then import THAT into the workbook? You should be able to create a macro that does that, thereby skipping the whole Java problem entirely...

ep

actually i need to export to excel from the Java code because is an option in the HTML reports to export to excel the current report with graphics and everything, xelem do all this but in a system application, and trying to get this working in a web application using java servlets.

Hmmm... that's a little out of my league; I know nothing about Java. But let me see if I can track down some help for you.

ep

Try

            response.setContentType( "application/vnd.ms-excel" );
            response.setHeader( "Content-Disposition",
                    "attachment; filename=\""+listName + "." + heading + ".xls\"" );
 
 
            OutputStream out = response.getOutputStream();
 
            
 
            new XSerializer().serialize(wb, out);
 
            out.flush();

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:

Yeah, so what I said but with a flush

Yes, sorry Tim - i somehow didn't see your code eg

:-)  No worries :-)

Long time no see!

Ok, so I've only used Java as part of an in-house app.  I have a couple of questions though, hopefully they will lead somewhere, but if not, at least I tried to help the discussion.

1)
            java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat( "d MMM yyyy" );
            String heading = sdf.format( new java.util.Date( startDate ) ) + " to " +


I doubt it makes a difference, but perhaps coming from the web, it doesn't like spaces in the filename.  I know when working from UNIX this is a no-no as you can't reference the file if the filename has spaces.

2)
            response.setHeader( "Content-Disposition",
                    "attachment; filename=\""+listName + "." + heading + ".xls\"" );
 
I know this is a total newb question, but why do you have listName here as part of the filename?  I thought above you declared the new wb as just

Workbook wb = new XLWorkbook(heading);

Sometimes asking questions leads to answers, so just trying to stir the pot I suppose.

Regards,
WC

ser.Points is a collection of data points contained in that series.  You can reference a specific one by using it's index

ser.Points(lngCol)

as in the code where it appear like that.

Sorry, somehow got in the wrong window