Exporting data from excel

122 views
Skip to first unread message

Selenium Tester

unread,
Mar 17, 2012, 6:24:35 AM3/17/12
to Selenium Users
Hello everyone,

When i try to retrive data from excel sheet and use it in my script it
shows the bello error


Exception in thread "main" jxl.read.biff.BiffException: Unable to
recognize OLE stream
at jxl.read.biff.CompoundFile.<init>(CompoundFile.java:116)
at jxl.read.biff.File.<init>(File.java:127)
at jxl.Workbook.getWorkbook(Workbook.java:268)
at jxl.Workbook.getWorkbook(Workbook.java:253)
at test.main(test.java:30)

Please help me.

Akash ARK

unread,
Mar 17, 2012, 12:32:30 PM3/17/12
to seleniu...@googlegroups.com
Hi,

Have you imported the necessary libraries.
import java.io.FileInputStream;
import jxl.Sheet;
import jxl.Workbook; 




--
You received this message because you are subscribed to the Google Groups "Selenium Users" group.
To post to this group, send email to seleniu...@googlegroups.com.
To unsubscribe from this group, send email to selenium-user...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/selenium-users?hl=en.


Selenium Tester

unread,
Mar 18, 2012, 6:09:22 AM3/18/12
to seleniu...@googlegroups.com
Hi,
i have imported all necessary files.

sachin

unread,
Mar 18, 2012, 10:38:50 AM3/18/12
to Selenium Users
Hi,

Please check whether u r specifying the correct extension of the file
or not when u r creating the File object...



On Mar 18, 3:09 pm, Selenium Tester <automation.seleni...@gmail.com>
wrote:
Reply all
Reply to author
Forward
0 new messages