You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Ty Davis <da...@bellsouth.net> on 2013/10/10 12:50:52 UTC
openxml beginner question
Hello,
Does POI support the openxml format?
Does anyone have an example?
Thank You
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: openxml beginner question
Posted by Nick Burch <ap...@gagravarr.org>.
On Thu, 10 Oct 2013, Ty Davis wrote:
> So, If I want to use the openxml file format, Id use the XSSF workbook.
> And that will create the file in the XML format.
Not quite. If you want to create a .xlsx file (Excel in OpenXML) you use
XSSF. If you want to create a .docx file (Word in OpenXML) use XWPF.
If you want to create some custom OpenXML file, with your own hand crafted
content inside it, and just need a library to create the manditory entries
and do the relations, use the OpenXML4J component directly
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: openxml beginner question
Posted by Ty Davis <da...@bellsouth.net>.
Thank You Nick.
I have been able to create a few SS's using the examples.
So, If I want to use the openxml file format, Id use the XSSF workbook.
And that will create the file in the XML format.
Is that correct?
On 10/10/2013 1:27 PM, Nick Burch wrote:
> On Thu, 10 Oct 2013, Ty Davis wrote:
>> The openxml format. I not sure what it's called. Ive got the
>> documentation from the ECMA376 site, and have been doing all night
>> coffee benders trying to learn this stuff.
>>
>> Im not sure what is meant by the "openxml packaging container". Im in
>> the process of learning java, and I get lost in terminology.
>
> When most people talk about openxml, they actually have in mind one or
> more of the file formats that use it, eg they want to process an Excel
> .xlsx file or add a new slide to a PowerPoint .pptx file. For those,
> you'd use XSSF (or the common SS interfaces) or .xlsx, XSLF for .pptx,
> and XWPF for .docx, all documented on the website.
>
> If you're interested in the overall container format, i.e. the wrapper
> zip with the various special xml files for types, relations,
> properties etc, then the POI component you want is OpenXML4J, see
> http://poi.apache.org/oxml4j/index.html for a very small bit. For the
> main examples of working with it, see how things like XSSF or XSLF
> call into it
>
> Nick
>
> ---------------------------------------------------------------------
> 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: openxml beginner question
Posted by Nick Burch <ap...@gagravarr.org>.
On Thu, 10 Oct 2013, Ty Davis wrote:
> The openxml format. I not sure what it's called. Ive got the
> documentation from the ECMA376 site, and have been doing all night
> coffee benders trying to learn this stuff.
>
> Im not sure what is meant by the "openxml packaging container". Im in
> the process of learning java, and I get lost in terminology.
When most people talk about openxml, they actually have in mind one or
more of the file formats that use it, eg they want to process an Excel
.xlsx file or add a new slide to a PowerPoint .pptx file. For those, you'd
use XSSF (or the common SS interfaces) or .xlsx, XSLF for .pptx, and XWPF
for .docx, all documented on the website.
If you're interested in the overall container format, i.e. the wrapper zip
with the various special xml files for types, relations, properties etc,
then the POI component you want is OpenXML4J, see
http://poi.apache.org/oxml4j/index.html for a very small bit. For the main
examples of working with it, see how things like XSSF or XSLF call into it
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: openxml beginner question
Posted by Ty Davis <da...@bellsouth.net>.
Thank You Sun,
That is a good link.
I appreciate your valuable time
On 10/10/2013 12:00 PM, Sun Kefan wrote:
> Another source: http://www.schemacentral.com/sc/ooxml/ss.html
> The documentation form the ECMA376 is pretty detailed and this one contains
> less information but is easier to view.
>
>
> On Thu, Oct 10, 2013 at 11:40 AM, Ty Davis <da...@bellsouth.net> wrote:
>
>> The openxml format. I not sure what it's called. Ive got the documentation
>> from the ECMA376 site, and have been doing all night coffee benders trying
>> to learn this stuff.
>>
>> Im not sure what is meant by the "openxml packaging container". Im in the
>> process of learning java, and I get lost in terminology.
>>
>> I sincerely appreciate your valuable time.
>>
>>
>>
>> On 10/10/2013 11:30 AM, Nick Burch wrote:
>>
>>> On Thu, 10 Oct 2013, Ty Davis wrote:
>>>
>>>> I was primarily looking for an openxml example, but I couldnt find one.
>>>>
>>> For what file format? Excel .xlsx? Word .docx? Or are you interested in
>>> the OpenXML packaging container format itself?
>>>
>>> Nick
>>>
>>> ------------------------------**------------------------------**---------
>>> To unsubscribe, e-mail: user-unsubscribe@poi.apache.**org<us...@poi.apache.org>
>>> For additional commands, e-mail: user-help@poi.apache.org
>>>
>>>
>>>
>> ------------------------------**------------------------------**---------
>> To unsubscribe, e-mail: user-unsubscribe@poi.apache.**org<us...@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: openxml beginner question
Posted by Sun Kefan <ca...@gmail.com>.
Another source: http://www.schemacentral.com/sc/ooxml/ss.html
The documentation form the ECMA376 is pretty detailed and this one contains
less information but is easier to view.
On Thu, Oct 10, 2013 at 11:40 AM, Ty Davis <da...@bellsouth.net> wrote:
> The openxml format. I not sure what it's called. Ive got the documentation
> from the ECMA376 site, and have been doing all night coffee benders trying
> to learn this stuff.
>
> Im not sure what is meant by the "openxml packaging container". Im in the
> process of learning java, and I get lost in terminology.
>
> I sincerely appreciate your valuable time.
>
>
>
> On 10/10/2013 11:30 AM, Nick Burch wrote:
>
>> On Thu, 10 Oct 2013, Ty Davis wrote:
>>
>>> I was primarily looking for an openxml example, but I couldnt find one.
>>>
>>
>> For what file format? Excel .xlsx? Word .docx? Or are you interested in
>> the OpenXML packaging container format itself?
>>
>> Nick
>>
>> ------------------------------**------------------------------**---------
>> To unsubscribe, e-mail: user-unsubscribe@poi.apache.**org<us...@poi.apache.org>
>> For additional commands, e-mail: user-help@poi.apache.org
>>
>>
>>
>
> ------------------------------**------------------------------**---------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.**org<us...@poi.apache.org>
> For additional commands, e-mail: user-help@poi.apache.org
>
>
--
孙柯凡
Re: openxml beginner question
Posted by Ty Davis <da...@bellsouth.net>.
The openxml format. I not sure what it's called. Ive got the
documentation from the ECMA376 site, and have been doing all night
coffee benders trying to learn this stuff.
Im not sure what is meant by the "openxml packaging container". Im in
the process of learning java, and I get lost in terminology.
I sincerely appreciate your valuable time.
On 10/10/2013 11:30 AM, Nick Burch wrote:
> On Thu, 10 Oct 2013, Ty Davis wrote:
>> I was primarily looking for an openxml example, but I couldnt find one.
>
> For what file format? Excel .xlsx? Word .docx? Or are you interested
> in the OpenXML packaging container format itself?
>
> Nick
>
> ---------------------------------------------------------------------
> 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: openxml beginner question
Posted by Nick Burch <ap...@gagravarr.org>.
On Thu, 10 Oct 2013, Ty Davis wrote:
> I was primarily looking for an openxml example, but I couldnt find one.
For what file format? Excel .xlsx? Word .docx? Or are you interested in
the OpenXML packaging container format itself?
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: openxml beginner question
Posted by Ty Davis <da...@bellsouth.net>.
Thank You Nick,
Im pretty much a newbie at all this. I appreciate your patience.
I was primarily looking for an openxml example, but I couldnt find one.
It may be there but the terminology escapes me ...
Thank You,
Ty Davis
Mobile, Al
On 10/10/2013 11:12 AM, Nick Burch wrote:
> On Thu, 10 Oct 2013, Ty Davis wrote:
>> Does POI support the openxml format?
>
>> From http://poi.apache.org/
> "The Apache POI Project's mission is to create and maintain Java APIs
> for manipulating various file formats based upon the Office Open XML
> standards (OOXML) and Microsoft's OLE 2 Compound Document format (OLE2)"
>
> So yes!
>
>> Does anyone have an example?
>
> Go to http://poi.apache.org/, pick the area for the format of
> interest, then see the examples and documentation there
>
> Nick
>
> ---------------------------------------------------------------------
> 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: openxml beginner question
Posted by Nick Burch <ap...@gagravarr.org>.
On Thu, 10 Oct 2013, Ty Davis wrote:
> Does POI support the openxml format?
>From http://poi.apache.org/
"The Apache POI Project's mission is to create and maintain Java APIs for
manipulating various file formats based upon the Office Open XML standards
(OOXML) and Microsoft's OLE 2 Compound Document format (OLE2)"
So yes!
> Does anyone have an example?
Go to http://poi.apache.org/, pick the area for the format of interest,
then see the examples and documentation there
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org