You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Jörn Franke <jo...@gmail.com> on 2016/12/27 14:52:46 UTC
Writing workbooks with linked workbooks using XSSFWorkbook
Dear all,
I am currently writing an open source library for reading/writing office
files on Hadoop/Spark/Hive/etc. The code is on Github and an official
release in form of a library on maven central will follow soon.
The Excel files will be supported by the Apache POI library (3.15).
So far everything works quiet well, such as reading from linked workbooks
(HSSF & XSSF), writing workbooks with linked workbooks (HSSF). However, I
have some issues with writing workbooks with linked workbooks using XSSF. I
receive the following exception (when calling linkexternalworkbooks):
RuntimeException
<http://grepcode.com/file/repository.grepcode.com/java/root/jdk/openjdk/6-b27/java/lang/RuntimeException.java#RuntimeException>("Not
Implemented - see bug #57184");
The bug (https://bz.apache.org/bugzilla/show_bug.cgi?id=57184) refers
to bug 60219, which is supposed to be fixed in 3.15. However, it does
not seem that this bug really solves the issue I have.
Does anyone know when external workbooks for XSSFWorkbooks will be supported?
Thank you a lot.
best regards
Re: Writing workbooks with linked workbooks using XSSFWorkbook
Posted by Jörn Franke <jo...@gmail.com>.
Ok, thank you. I will see, but I cannot promise anything.
> On 8 Jan 2017, at 21:23, Dominik Stadler <do...@gmx.at> wrote:
>
> Hi,
>
> Unfortunately this is likely to stay unsupported until somebody comes up
> with the necessary changes. None of the few active devs is currently
> working on this as far as I see, though. Patches are always welcome if you
> managed to take a closer look yourself.
>
> Dominik.
>
>> On Tue, Jan 3, 2017 at 9:06 PM, Jörn Franke <jo...@gmail.com> wrote:
>>
>> oh btw. you do not need a Hadoop installation to run the tests, they are
>> simple unit tests.
>> Simply clone https://github.com/ZuInnoTe/hadoopoffice.git
>> Remove all the @Ignore tags from
>> *
>> fileformat/src/test/java/org/zuinnote/hadoop/office/format/mapred/
>> OfficeFormatHadoopExcelTest.java
>> * fileformat/src/test/java/org/zuinnote/hadoop/office/format/mapreduce/
>> OfficeFormatHadoopExcelTest.java
>>
>> Go to the fileformat. Run gradle clean build
>>
>>> On Tue, Jan 3, 2017 at 9:03 PM, Jörn Franke <jo...@gmail.com> wrote:
>>>
>>> Hi,
>>>
>>> sorry I was a little bit late. I tried with 82 and still the same error:
>>>
>>> java.lang.RuntimeException: Not Implemented - see bug #57184
>>>
>>>
>>> I do have a unit test, but it contains a lot of Hadoop stuff. Basically
>> this line fails with the message above:
>>>
>>> currentWorkbook.linkExternalWorkbook(name,currentLinkedWorkbookParser.
>> getCurrentWorkbook());
>>>
>>>
>>> I can clearly see in the source code of XSSFWorkbook that
>> linkExternalWorkbook simply throws a runtime Exception.
>>>
>>> The only thing that i want to do - and which works with the Excel2003
>> .xls format - is to add an external workbook to the current workbook, refer
>> in a formula to it, e.g. via [linkedwbfile.xlsx]Sheet1!B1. Even if do not
>> use linkExternalWorkbook, but only setupReferencedWorkbooks then i get a
>> null pointer exception when setting the formula referring to an external
>> workbook in the cell. Again this is only for XSSFWorkbook when
>> modifying/adding cells. HSSFWorkbook works fine.
>>>
>>> I assume the formula evaluator of XSSFWorkbook simply does not
>> understand formulas with external workbook references.
>>>
>>>
>>> Let me know if I can do further analysis to solve the issue.
>>>
>>> thank you a lot.
>>>
>>> Best regards
>>>
>>>
>>> On Sat, Dec 31, 2016 at 6:00 PM, Dominik Stadler <dominik.stadler@gmx.at
>>>
>>> wrote:
>>>
>>>> Hi,
>>>>
>>>> Bug 60219 was not fixed yet, but it is now.
>>>>
>>>> Can you re-try with a recent build from trunk or use the binaries from
>>>> https://builds.apache.org/view/POI/job/POI-DSL-1.6/65/ when it
>> finishes.
>>>>
>>>> Thanks... Dominik.
>>>>
>>>> On Tue, Dec 27, 2016 at 5:21 PM, Jörn Franke <jo...@gmail.com>
>>>> wrote:
>>>>
>>>>> There is already a bug report, see my message.
>>>>>
>>>>>> On 27 Dec 2016, at 17:15, Murphy, Mark <mu...@metalexmfg.com>
>>>>> wrote:
>>>>>>
>>>>>> If you create an issue in bugzilla with a unit test, It will be
>> easier
>>>>> to get that fixed.
>>>>>>
>>>>>> -----Original Message-----
>>>>>> From: Jörn Franke [mailto:jornfranke@gmail.com]
>>>>>> Sent: Tuesday, December 27, 2016 9:53 AM
>>>>>> To: user@poi.apache.org
>>>>>> Subject: Writing workbooks with linked workbooks using XSSFWorkbook
>>>>>>
>>>>>> Dear all,
>>>>>>
>>>>>> I am currently writing an open source library for reading/writing
>>>> office
>>>>> files on Hadoop/Spark/Hive/etc. The code is on Github and an official
>>>>> release in form of a library on maven central will follow soon.
>>>>>> The Excel files will be supported by the Apache POI library (3.15).
>>>>>> So far everything works quiet well, such as reading from linked
>>>>> workbooks (HSSF & XSSF), writing workbooks with linked workbooks
>> (HSSF).
>>>>> However, I have some issues with writing workbooks with linked
>> workbooks
>>>>> using XSSF. I receive the following exception (when calling
>>>>> linkexternalworkbooks):
>>>>>>
>>>>>> RuntimeException
>>>>>> <http://grepcode.com/file/repository.grepcode.com/java/
>>>>> root/jdk/openjdk/6-b27/java/lang/RuntimeException.java#
>> RuntimeException
>>>>>> ("Not
>>>>>> Implemented - see bug #57184");
>>>>>>
>>>>>>
>>>>>> The bug (https://bz.apache.org/bugzilla/show_bug.cgi?id=57184)
>> refers
>>>>> to bug 60219, which is supposed to be fixed in 3.15. However, it does
>>>> not
>>>>> seem that this bug really solves the issue I have.
>>>>>>
>>>>>> Does anyone know when external workbooks for XSSFWorkbooks will be
>>>>> supported?
>>>>>>
>>>>>>
>>>>>> Thank you a lot.
>>>>>>
>>>>>>
>>>>>> best regards
>>>>>> B‹KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK
>>>> KKKKKKKKKKCB•
>>>>> È [œÝXœØÜšX™K K[XZ[ ˆ \Ù\‹][œÝXœØÜšX™P ÚK˜\ XÚ K›Ü™ÃB‘›Üˆ Y ] [Û˜[
>>>>> ÛÛ[X[™ Ë K[XZ[ ˆ \Ù\‹Z [ ÚK˜\ XÚ K›Ü™ÃB
>>>>>
>>>>> ---------------------------------------------------------------------
>>>>> 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: Writing workbooks with linked workbooks using XSSFWorkbook
Posted by Dominik Stadler <do...@gmx.at>.
Hi,
Unfortunately this is likely to stay unsupported until somebody comes up
with the necessary changes. None of the few active devs is currently
working on this as far as I see, though. Patches are always welcome if you
managed to take a closer look yourself.
Dominik.
On Tue, Jan 3, 2017 at 9:06 PM, Jörn Franke <jo...@gmail.com> wrote:
> oh btw. you do not need a Hadoop installation to run the tests, they are
> simple unit tests.
> Simply clone https://github.com/ZuInnoTe/hadoopoffice.git
> Remove all the @Ignore tags from
> *
> fileformat/src/test/java/org/zuinnote/hadoop/office/format/mapred/
> OfficeFormatHadoopExcelTest.java
> * fileformat/src/test/java/org/zuinnote/hadoop/office/format/mapreduce/
> OfficeFormatHadoopExcelTest.java
>
> Go to the fileformat. Run gradle clean build
>
> On Tue, Jan 3, 2017 at 9:03 PM, Jörn Franke <jo...@gmail.com> wrote:
>
> > Hi,
> >
> > sorry I was a little bit late. I tried with 82 and still the same error:
> >
> > java.lang.RuntimeException: Not Implemented - see bug #57184
> >
> >
> > I do have a unit test, but it contains a lot of Hadoop stuff. Basically
> this line fails with the message above:
> >
> > currentWorkbook.linkExternalWorkbook(name,currentLinkedWorkbookParser.
> getCurrentWorkbook());
> >
> >
> > I can clearly see in the source code of XSSFWorkbook that
> linkExternalWorkbook simply throws a runtime Exception.
> >
> > The only thing that i want to do - and which works with the Excel2003
> .xls format - is to add an external workbook to the current workbook, refer
> in a formula to it, e.g. via [linkedwbfile.xlsx]Sheet1!B1. Even if do not
> use linkExternalWorkbook, but only setupReferencedWorkbooks then i get a
> null pointer exception when setting the formula referring to an external
> workbook in the cell. Again this is only for XSSFWorkbook when
> modifying/adding cells. HSSFWorkbook works fine.
> >
> > I assume the formula evaluator of XSSFWorkbook simply does not
> understand formulas with external workbook references.
> >
> >
> > Let me know if I can do further analysis to solve the issue.
> >
> > thank you a lot.
> >
> > Best regards
> >
> >
> > On Sat, Dec 31, 2016 at 6:00 PM, Dominik Stadler <dominik.stadler@gmx.at
> >
> > wrote:
> >
> >> Hi,
> >>
> >> Bug 60219 was not fixed yet, but it is now.
> >>
> >> Can you re-try with a recent build from trunk or use the binaries from
> >> https://builds.apache.org/view/POI/job/POI-DSL-1.6/65/ when it
> finishes.
> >>
> >> Thanks... Dominik.
> >>
> >> On Tue, Dec 27, 2016 at 5:21 PM, Jörn Franke <jo...@gmail.com>
> >> wrote:
> >>
> >> > There is already a bug report, see my message.
> >> >
> >> > > On 27 Dec 2016, at 17:15, Murphy, Mark <mu...@metalexmfg.com>
> >> > wrote:
> >> > >
> >> > > If you create an issue in bugzilla with a unit test, It will be
> easier
> >> > to get that fixed.
> >> > >
> >> > > -----Original Message-----
> >> > > From: Jörn Franke [mailto:jornfranke@gmail.com]
> >> > > Sent: Tuesday, December 27, 2016 9:53 AM
> >> > > To: user@poi.apache.org
> >> > > Subject: Writing workbooks with linked workbooks using XSSFWorkbook
> >> > >
> >> > > Dear all,
> >> > >
> >> > > I am currently writing an open source library for reading/writing
> >> office
> >> > files on Hadoop/Spark/Hive/etc. The code is on Github and an official
> >> > release in form of a library on maven central will follow soon.
> >> > > The Excel files will be supported by the Apache POI library (3.15).
> >> > > So far everything works quiet well, such as reading from linked
> >> > workbooks (HSSF & XSSF), writing workbooks with linked workbooks
> (HSSF).
> >> > However, I have some issues with writing workbooks with linked
> workbooks
> >> > using XSSF. I receive the following exception (when calling
> >> > linkexternalworkbooks):
> >> > >
> >> > > RuntimeException
> >> > > <http://grepcode.com/file/repository.grepcode.com/java/
> >> > root/jdk/openjdk/6-b27/java/lang/RuntimeException.java#
> RuntimeException
> >> > >("Not
> >> > > Implemented - see bug #57184");
> >> > >
> >> > >
> >> > > The bug (https://bz.apache.org/bugzilla/show_bug.cgi?id=57184)
> refers
> >> > to bug 60219, which is supposed to be fixed in 3.15. However, it does
> >> not
> >> > seem that this bug really solves the issue I have.
> >> > >
> >> > > Does anyone know when external workbooks for XSSFWorkbooks will be
> >> > supported?
> >> > >
> >> > >
> >> > > Thank you a lot.
> >> > >
> >> > >
> >> > > best regards
> >> > > B‹KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK
> >> KKKKKKKKKKCB•
> >> > È [œÝXœØÜšX™K K[XZ[ ˆ \Ù\‹][œÝXœØÜšX™P ÚK˜\ XÚ K›Ü™ÃB‘›Üˆ Y ] [Û˜[
> >> > ÛÛ[X[™ Ë K[XZ[ ˆ \Ù\‹Z [ ÚK˜\ XÚ K›Ü™ÃB
> >> >
> >> > ---------------------------------------------------------------------
> >> > To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> >> > For additional commands, e-mail: user-help@poi.apache.org
> >> >
> >> >
> >>
> >
> >
>
Re: Writing workbooks with linked workbooks using XSSFWorkbook
Posted by Jörn Franke <jo...@gmail.com>.
oh btw. you do not need a Hadoop installation to run the tests, they are
simple unit tests.
Simply clone https://github.com/ZuInnoTe/hadoopoffice.git
Remove all the @Ignore tags from
*
fileformat/src/test/java/org/zuinnote/hadoop/office/format/mapred/OfficeFormatHadoopExcelTest.java
* fileformat/src/test/java/org/zuinnote/hadoop/office/format/mapreduce/OfficeFormatHadoopExcelTest.java
Go to the fileformat. Run gradle clean build
On Tue, Jan 3, 2017 at 9:03 PM, Jörn Franke <jo...@gmail.com> wrote:
> Hi,
>
> sorry I was a little bit late. I tried with 82 and still the same error:
>
> java.lang.RuntimeException: Not Implemented - see bug #57184
>
>
> I do have a unit test, but it contains a lot of Hadoop stuff. Basically this line fails with the message above:
>
> currentWorkbook.linkExternalWorkbook(name,currentLinkedWorkbookParser.getCurrentWorkbook());
>
>
> I can clearly see in the source code of XSSFWorkbook that linkExternalWorkbook simply throws a runtime Exception.
>
> The only thing that i want to do - and which works with the Excel2003 .xls format - is to add an external workbook to the current workbook, refer in a formula to it, e.g. via [linkedwbfile.xlsx]Sheet1!B1. Even if do not use linkExternalWorkbook, but only setupReferencedWorkbooks then i get a null pointer exception when setting the formula referring to an external workbook in the cell. Again this is only for XSSFWorkbook when modifying/adding cells. HSSFWorkbook works fine.
>
> I assume the formula evaluator of XSSFWorkbook simply does not understand formulas with external workbook references.
>
>
> Let me know if I can do further analysis to solve the issue.
>
> thank you a lot.
>
> Best regards
>
>
> On Sat, Dec 31, 2016 at 6:00 PM, Dominik Stadler <do...@gmx.at>
> wrote:
>
>> Hi,
>>
>> Bug 60219 was not fixed yet, but it is now.
>>
>> Can you re-try with a recent build from trunk or use the binaries from
>> https://builds.apache.org/view/POI/job/POI-DSL-1.6/65/ when it finishes.
>>
>> Thanks... Dominik.
>>
>> On Tue, Dec 27, 2016 at 5:21 PM, Jörn Franke <jo...@gmail.com>
>> wrote:
>>
>> > There is already a bug report, see my message.
>> >
>> > > On 27 Dec 2016, at 17:15, Murphy, Mark <mu...@metalexmfg.com>
>> > wrote:
>> > >
>> > > If you create an issue in bugzilla with a unit test, It will be easier
>> > to get that fixed.
>> > >
>> > > -----Original Message-----
>> > > From: Jörn Franke [mailto:jornfranke@gmail.com]
>> > > Sent: Tuesday, December 27, 2016 9:53 AM
>> > > To: user@poi.apache.org
>> > > Subject: Writing workbooks with linked workbooks using XSSFWorkbook
>> > >
>> > > Dear all,
>> > >
>> > > I am currently writing an open source library for reading/writing
>> office
>> > files on Hadoop/Spark/Hive/etc. The code is on Github and an official
>> > release in form of a library on maven central will follow soon.
>> > > The Excel files will be supported by the Apache POI library (3.15).
>> > > So far everything works quiet well, such as reading from linked
>> > workbooks (HSSF & XSSF), writing workbooks with linked workbooks (HSSF).
>> > However, I have some issues with writing workbooks with linked workbooks
>> > using XSSF. I receive the following exception (when calling
>> > linkexternalworkbooks):
>> > >
>> > > RuntimeException
>> > > <http://grepcode.com/file/repository.grepcode.com/java/
>> > root/jdk/openjdk/6-b27/java/lang/RuntimeException.java#RuntimeException
>> > >("Not
>> > > Implemented - see bug #57184");
>> > >
>> > >
>> > > The bug (https://bz.apache.org/bugzilla/show_bug.cgi?id=57184) refers
>> > to bug 60219, which is supposed to be fixed in 3.15. However, it does
>> not
>> > seem that this bug really solves the issue I have.
>> > >
>> > > Does anyone know when external workbooks for XSSFWorkbooks will be
>> > supported?
>> > >
>> > >
>> > > Thank you a lot.
>> > >
>> > >
>> > > best regards
>> > > B‹KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK
>> KKKKKKKKKKCB•
>> > È [œÝXœØÜšX™K K[XZ[ ˆ \Ù\‹][œÝXœØÜšX™P ÚK˜\ XÚ K›Ü™ÃB‘›Üˆ Y ] [Û˜[
>> > ÛÛ[X[™ Ë K[XZ[ ˆ \Ù\‹Z [ ÚK˜\ XÚ K›Ü™ÃB
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
>> > For additional commands, e-mail: user-help@poi.apache.org
>> >
>> >
>>
>
>
Re: Writing workbooks with linked workbooks using XSSFWorkbook
Posted by Jörn Franke <jo...@gmail.com>.
Hi,
sorry I was a little bit late. I tried with 82 and still the same error:
java.lang.RuntimeException: Not Implemented - see bug #57184
I do have a unit test, but it contains a lot of Hadoop stuff.
Basically this line fails with the message above:
currentWorkbook.linkExternalWorkbook(name,currentLinkedWorkbookParser.getCurrentWorkbook());
I can clearly see in the source code of XSSFWorkbook that
linkExternalWorkbook simply throws a runtime Exception.
The only thing that i want to do - and which works with the Excel2003
.xls format - is to add an external workbook to the current workbook,
refer in a formula to it, e.g. via [linkedwbfile.xlsx]Sheet1!B1. Even
if do not use linkExternalWorkbook, but only setupReferencedWorkbooks
then i get a null pointer exception when setting the formula referring
to an external workbook in the cell. Again this is only for
XSSFWorkbook when modifying/adding cells. HSSFWorkbook works fine.
I assume the formula evaluator of XSSFWorkbook simply does not
understand formulas with external workbook references.
Let me know if I can do further analysis to solve the issue.
thank you a lot.
Best regards
On Sat, Dec 31, 2016 at 6:00 PM, Dominik Stadler <do...@gmx.at>
wrote:
> Hi,
>
> Bug 60219 was not fixed yet, but it is now.
>
> Can you re-try with a recent build from trunk or use the binaries from
> https://builds.apache.org/view/POI/job/POI-DSL-1.6/65/ when it finishes.
>
> Thanks... Dominik.
>
> On Tue, Dec 27, 2016 at 5:21 PM, Jörn Franke <jo...@gmail.com> wrote:
>
> > There is already a bug report, see my message.
> >
> > > On 27 Dec 2016, at 17:15, Murphy, Mark <mu...@metalexmfg.com>
> > wrote:
> > >
> > > If you create an issue in bugzilla with a unit test, It will be easier
> > to get that fixed.
> > >
> > > -----Original Message-----
> > > From: Jörn Franke [mailto:jornfranke@gmail.com]
> > > Sent: Tuesday, December 27, 2016 9:53 AM
> > > To: user@poi.apache.org
> > > Subject: Writing workbooks with linked workbooks using XSSFWorkbook
> > >
> > > Dear all,
> > >
> > > I am currently writing an open source library for reading/writing
> office
> > files on Hadoop/Spark/Hive/etc. The code is on Github and an official
> > release in form of a library on maven central will follow soon.
> > > The Excel files will be supported by the Apache POI library (3.15).
> > > So far everything works quiet well, such as reading from linked
> > workbooks (HSSF & XSSF), writing workbooks with linked workbooks (HSSF).
> > However, I have some issues with writing workbooks with linked workbooks
> > using XSSF. I receive the following exception (when calling
> > linkexternalworkbooks):
> > >
> > > RuntimeException
> > > <http://grepcode.com/file/repository.grepcode.com/java/
> > root/jdk/openjdk/6-b27/java/lang/RuntimeException.java#RuntimeException
> > >("Not
> > > Implemented - see bug #57184");
> > >
> > >
> > > The bug (https://bz.apache.org/bugzilla/show_bug.cgi?id=57184) refers
> > to bug 60219, which is supposed to be fixed in 3.15. However, it does not
> > seem that this bug really solves the issue I have.
> > >
> > > Does anyone know when external workbooks for XSSFWorkbooks will be
> > supported?
> > >
> > >
> > > Thank you a lot.
> > >
> > >
> > > best regards
> > > B‹KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK
> KKKKKKKKCB•
> > È [œÝXœØÜšX™K K[XZ[ ˆ \Ù\‹][œÝXœØÜšX™P ÚK˜\ XÚ K›Ü™ÃB‘›Üˆ Y ] [Û˜[
> > ÛÛ[X[™ Ë K[XZ[ ˆ \Ù\‹Z [ ÚK˜\ XÚ K›Ü™ÃB
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> > For additional commands, e-mail: user-help@poi.apache.org
> >
> >
>
Re: Writing workbooks with linked workbooks using XSSFWorkbook
Posted by Dominik Stadler <do...@gmx.at>.
Hi,
Bug 60219 was not fixed yet, but it is now.
Can you re-try with a recent build from trunk or use the binaries from
https://builds.apache.org/view/POI/job/POI-DSL-1.6/65/ when it finishes.
Thanks... Dominik.
On Tue, Dec 27, 2016 at 5:21 PM, Jörn Franke <jo...@gmail.com> wrote:
> There is already a bug report, see my message.
>
> > On 27 Dec 2016, at 17:15, Murphy, Mark <mu...@metalexmfg.com>
> wrote:
> >
> > If you create an issue in bugzilla with a unit test, It will be easier
> to get that fixed.
> >
> > -----Original Message-----
> > From: Jörn Franke [mailto:jornfranke@gmail.com]
> > Sent: Tuesday, December 27, 2016 9:53 AM
> > To: user@poi.apache.org
> > Subject: Writing workbooks with linked workbooks using XSSFWorkbook
> >
> > Dear all,
> >
> > I am currently writing an open source library for reading/writing office
> files on Hadoop/Spark/Hive/etc. The code is on Github and an official
> release in form of a library on maven central will follow soon.
> > The Excel files will be supported by the Apache POI library (3.15).
> > So far everything works quiet well, such as reading from linked
> workbooks (HSSF & XSSF), writing workbooks with linked workbooks (HSSF).
> However, I have some issues with writing workbooks with linked workbooks
> using XSSF. I receive the following exception (when calling
> linkexternalworkbooks):
> >
> > RuntimeException
> > <http://grepcode.com/file/repository.grepcode.com/java/
> root/jdk/openjdk/6-b27/java/lang/RuntimeException.java#RuntimeException
> >("Not
> > Implemented - see bug #57184");
> >
> >
> > The bug (https://bz.apache.org/bugzilla/show_bug.cgi?id=57184) refers
> to bug 60219, which is supposed to be fixed in 3.15. However, it does not
> seem that this bug really solves the issue I have.
> >
> > Does anyone know when external workbooks for XSSFWorkbooks will be
> supported?
> >
> >
> > Thank you a lot.
> >
> >
> > best regards
> > B‹KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKCB•
> È [œÝXœØÜšX™K K[XZ[ ˆ \Ù\‹][œÝXœØÜšX™P ÚK˜\ XÚ K›Ü™ÃB‘›Üˆ Y ] [Û˜[
> ÛÛ[X[™ Ë K[XZ[ ˆ \Ù\‹Z [ ÚK˜\ XÚ K›Ü™ÃB
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
Re: Writing workbooks with linked workbooks using XSSFWorkbook
Posted by Jörn Franke <jo...@gmail.com>.
There is already a bug report, see my message.
> On 27 Dec 2016, at 17:15, Murphy, Mark <mu...@metalexmfg.com> wrote:
>
> If you create an issue in bugzilla with a unit test, It will be easier to get that fixed.
>
> -----Original Message-----
> From: Jörn Franke [mailto:jornfranke@gmail.com]
> Sent: Tuesday, December 27, 2016 9:53 AM
> To: user@poi.apache.org
> Subject: Writing workbooks with linked workbooks using XSSFWorkbook
>
> Dear all,
>
> I am currently writing an open source library for reading/writing office files on Hadoop/Spark/Hive/etc. The code is on Github and an official release in form of a library on maven central will follow soon.
> The Excel files will be supported by the Apache POI library (3.15).
> So far everything works quiet well, such as reading from linked workbooks (HSSF & XSSF), writing workbooks with linked workbooks (HSSF). However, I have some issues with writing workbooks with linked workbooks using XSSF. I receive the following exception (when calling linkexternalworkbooks):
>
> RuntimeException
> <http://grepcode.com/file/repository.grepcode.com/java/root/jdk/openjdk/6-b27/java/lang/RuntimeException.java#RuntimeException>("Not
> Implemented - see bug #57184");
>
>
> The bug (https://bz.apache.org/bugzilla/show_bug.cgi?id=57184) refers to bug 60219, which is supposed to be fixed in 3.15. However, it does not seem that this bug really solves the issue I have.
>
> Does anyone know when external workbooks for XSSFWorkbooks will be supported?
>
>
> Thank you a lot.
>
>
> best regards
> B‹KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKCB•È [œÝXœØÜšX™KK[XZ[ˆ \Ù\‹][œÝXœØÜšX™P ÚK˜\XÚK›Ü™ÃB‘›ÜˆY][Û˜[ÛÛ[X[™ ËK[XZ[ˆ \Ù\‹Z[ ÚK˜\XÚK›Ü™ÃB
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
RE: Writing workbooks with linked workbooks using XSSFWorkbook
Posted by "Murphy, Mark" <mu...@metalexmfg.com>.
If you create an issue in bugzilla with a unit test, It will be easier to get that fixed.
-----Original Message-----
From: Jörn Franke [mailto:jornfranke@gmail.com]
Sent: Tuesday, December 27, 2016 9:53 AM
To: user@poi.apache.org
Subject: Writing workbooks with linked workbooks using XSSFWorkbook
Dear all,
I am currently writing an open source library for reading/writing office files on Hadoop/Spark/Hive/etc. The code is on Github and an official release in form of a library on maven central will follow soon.
The Excel files will be supported by the Apache POI library (3.15).
So far everything works quiet well, such as reading from linked workbooks (HSSF & XSSF), writing workbooks with linked workbooks (HSSF). However, I have some issues with writing workbooks with linked workbooks using XSSF. I receive the following exception (when calling linkexternalworkbooks):
RuntimeException
<http://grepcode.com/file/repository.grepcode.com/java/root/jdk/openjdk/6-b27/java/lang/RuntimeException.java#RuntimeException>("Not
Implemented - see bug #57184");
The bug (https://bz.apache.org/bugzilla/show_bug.cgi?id=57184) refers to bug 60219, which is supposed to be fixed in 3.15. However, it does not seem that this bug really solves the issue I have.
Does anyone know when external workbooks for XSSFWorkbooks will be supported?
Thank you a lot.
best regards