Cant Open Excel Files

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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é

[Anonymous]

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);