You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by anjs <jn...@yahoo.com> on 2011/09/26 09:19:22 UTC
Re: Problem opening the written Excel file with BigGridDemo
I am also facing similar problem. My file has just 20 records, and it still
gives this alert on opening the xlsx file. Any reasons why this is
happening? Let me know if anybody has resolved the issue
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Problem-opening-the-written-Excel-file-with-BigGridDemo-tp4457747p4840446.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Problem opening the written Excel file with BigGridDemo
Posted by anjs <jn...@yahoo.com>.
StringEscapeUtils.escapeXml works for me . Thanks!
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Problem-opening-the-written-Excel-file-with-BigGridDemo-tp4457747p4844794.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Problem opening the written Excel file with BigGridDemo
Posted by anjs <jn...@yahoo.com>.
Hi Nick
You are right, My XML is not valid. It has some issues with escape
characters in text like & . My cell data has & in it. XSSF is a beta version
right now, and so we cannot use it right now. Hopefully when it rolls out,
we would be glad to use it. But till then, I think BigGridDemo seems to be a
promising solution. Although we have more bulk testing to do!.
Anyhow, this doesnt seem to be BigGridDemo issue, this is basically writing
a valid and more rich XML , in case you can provide me any good links on
that , it would help!!
thanks
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Problem-opening-the-written-Excel-file-with-BigGridDemo-tp4457747p4844500.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Problem opening the written Excel file with BigGridDemo
Posted by Nick Burch <ni...@alfresco.com>.
On 26/09/11 08:19, anjs wrote:
> I am also facing similar problem. My file has just 20 records, and it still
> gives this alert on opening the xlsx file. Any reasons why this is
> happening? Let me know if anybody has resolved the issue
If you're not confident at writing the correct XML by hand, then you're
likely much better off switching to using SXSSF. The big grid demo is
very powerful, but there aren't a lot of safety nets either...
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org