Re: Structures_DataGrid_Renderer_XLS - ** ERROR in SST **

Daniel McGreal wrote: > Mark Wiesemann wrote: >> Another user of this renderer reported this "** ERROR in SST **" problem >> in a German PEAR forum last year. The final solution was that the user >> outputted some other things (AFAIR some HTML code) in the same script. >> After he removed this output, his generated Excel file worked without >> problems. > > I had found this post, unfortunately the situation is not the same. I > have made a test script with just enough code to perform my goal while > outputting no other data anywhere and have observed the same error. > > I am beginning to suspect that it's a problem with character encodings. Encoding might be a problem, yes. Spreadsheet_Excel_Writer (SEW) offers some options for setting the encoding (=> documented in the manual). Another possibility might be that you have to much data. SEW has some problems with too many rows and/or too many columns. But in this case I remember that Excel only complains about a broken file and tries to repair the file (with less success most times). I haven't seen "** ERROR in SST **" message in these cases. Regards, Mark -- http://www.markwiesemann.eu