topic Re: tFileExcelWorkbookOpen throwing error for .XLSX in Talend Studio

tFileExcelWorkbookOpen throwing error for .XLSX

sjaganmo — Wed, 17 Feb 2016 20:08:54 GMT

Hi,
I am using the custom components tFileExcelWorkbookOpen, tFileExcelWorkbookSave, tFileExcelSheetOutput and it worked fine for .XLS.
But the minute I switched to creating .XLSX files, it started throwing this error if I try to read the file I just created using tFileExcelWorkbookOpen (Create Empty Workbook option.)
Please note that we also did a java version upgrade from 1.7.8 to 1.7.97
This is the actual error I am getting
2016-02-11 23:33:13|lQqABm|20160211233302_3NxWK|yPGLrN|GRP_ETL|jo_GRP_RPT_0003_generateServiceSummaryXls_J1|Default|6|Java Exception|tFileExcelWorkbookOpen_1|java.lang.IllegalStateException:Zip File is closed|1
Attached are my screenshots. screenshots.zip
Can someone please respond to this? We have a big performance hit because of the out of the box component to create xlsx file as it opens and closes the file each time.
Thanks
Shuba

Re: tFileExcelWorkbookOpen throwing error for .XLSX

Anonymous — Thu, 18 Feb 2016 05:57:59 GMT

Hi,
tFileExcelWorkbookOpen, tFileExcelWorkbookSave, tFileExcelSheetOutput are custom components written by Talend community user and shared on Talend exchange. Feel free to contact to the author jlolling directly.
Best regards
Sabrina

Re: tFileExcelWorkbookOpen throwing error for .XLSX

sjaganmo — Thu, 18 Feb 2016 06:32:38 GMT

Thanks Sabrina for your response. I have been writing back and forth with him on a different thread as well. But he hasnt responded for the last 3 days and I still dont have a solution for this issue. I have sent him a personal email. Hopefully he will respond.

Re: tFileExcelWorkbookOpen throwing error for .XLSX

sjaganmo — Thu, 18 Feb 2016 19:04:49 GMT

Hi Jolling, As per our discussion, I am attaching the .zip file of a sample job here which is similar to what I'm trying to do. Although I coudnlt reproduce the same error here, I still get an apache POI null pointer error for this basic job. Hope this helps!
SampleMaster.zip
Thanks
Shuba

Re: tFileExcelWorkbookOpen throwing error for .XLSX

sjaganmo — Thu, 18 Feb 2016 19:14:05 GMT

Jan, Please use the latest .zip file attached. Thanks!