One Star

Cant Open Excel Files

Hi alll,
I have Exel source. I want to load the data from excel to my sql .. it shoes some errors as follow .. give me solutions

connecting to socket on port 3889
connected
Exception in component tFileInputExcel_1
org.apache.poi.openxml4j.exceptions.InvalidOperationException: Can't open the specified file: 'E:/SBD_15-Feb/xls/SBD_Account.xls'
at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:103)
at org.apache.poi.openxml4j.opc.Package.open(Package.java:194)
at org.apache.poi.openxml4j.opc.Package.open(Package.java:173)
at org.apache.poi.POIXMLDocument.openPackage(POIXMLDocument.java:63)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:173)
disconnected
at temp1.account_1_0.Account.tFileInputExcel_1Process(Account.java:1067)
at temp1.account_1_0.Account.runJobInTOS(Account.java:1833)
at temp1.account_1_0.Account.main(Account.java:1728)

thanks
5 REPLIES
One Star

Re: Cant Open Excel Files

Are you sure you have correct path and filename ? (E:/SBD_15-Feb/xls/SBD_Account.xls)
Moderator

Re: Cant Open Excel Files

Hi,
your excel file may be locked.
Close it in excel and retry
regards,
benjamin

Re: Cant Open Excel Files

hi,
I am getting this error
Exception in component tFileInputExcel_1
org.apache.poi.openxml4j.exceptions.InvalidOperationException: Can't open the specified file
I have specified the file path and the file is not locked or open. It still throws and error.
Please reply asap.
One Star

Re: Cant Open Excel Files

Hi,
Have you checked the access right (OS level) on this file for the user running Talend ?
Also, be sure that "Read Excel2007 file format(xlsx)" combo box is not checked in your tFileInputExcel as access method to 2007 file differs from previous versions and my throw this error !
Regards,
André
One Star

Re: Cant Open Excel Files

hi,
I am getting this error .
if you use XLS and XLSX,you can use :
FileInputStream is = new FileInputStream(new File("Z:\***\xx.xlsx"));
Workbook wb = WorkbookFactory.create(is);