You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by dpront <ge...@xmarter.com> on 2011/09/06 02:30:46 UTC
read xlsm and write to xls
Hi!
Is Apache POI capable of converting an xlsm file into a xls file? Is
there some sort of formatting before saving in POI, because when I try to
read an xlsm file and writes it as xls file, the program worked fine but
when I open the xls file, I got an error saying, "The file you are trying to
open, "*.xls", is in a different format than specified by the file
extension. Verify that the file is not corrupted nd is from a trusted
source before opening the file. Do you want to open the file now?" and when
I save it and open it again, the same error still prompts.
Thanks.
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/read-xlsm-and-write-to-xls-tp4772585p4772585.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: read xlsm and write to xls
Posted by Dave Fisher <da...@comcast.net>.
An xlsm file is an OOXML type file, and uses XSSF.
An xls file is a BIFF binary file, and uses HSSF.
You can convert from xlsm to xlsx, but not to xls without copying cell by cell.
Regards,
Dave
On Sep 5, 2011, at 5:30 PM, dpront wrote:
> Hi!
>
> Is Apache POI capable of converting an xlsm file into a xls file? Is
> there some sort of formatting before saving in POI, because when I try to
> read an xlsm file and writes it as xls file, the program worked fine but
> when I open the xls file, I got an error saying, "The file you are trying to
> open, "*.xls", is in a different format than specified by the file
> extension. Verify that the file is not corrupted nd is from a trusted
> source before opening the file. Do you want to open the file now?" and when
> I save it and open it again, the same error still prompts.
>
>
> Thanks.
>
> --
> View this message in context: http://apache-poi.1045710.n5.nabble.com/read-xlsm-and-write-to-xls-tp4772585p4772585.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
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: read xlsm and write to xls
Posted by dpront <ge...@xmarter.com>.
*BUMP
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/read-xlsm-and-write-to-xls-tp4772585p4855947.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: read xlsm and write to xls
Posted by dpront <ge...@xmarter.com>.
Any Ideas about this one?
Thanks.
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/read-xlsm-and-write-to-xls-tp4772585p4800900.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