Reading data from xls/xlsx file

Hi,

Can we read the data from xls/xlsx file using Birt?

Find more posts tagged with

Comments

<blockquote class='ipsBlockquote' data-author="'rohitmali'" data-cid="97211" data-time="1330937085" data-date="05 March 2012 - 01:44 AM">
Hi, 
 
Can we read the data from xls/xlsx file using Birt? </blockquote>
 
 
Yes we can read the data from xls/xlsx file using BIRT. 
 
When you are creating DATASORCE. just choos flat file data source. 
 
Regards, 
Arun

rohitmali

<blockquote class='ipsBlockquote' data-author="'arunkumarb'" data-cid="97222" data-time="1330950250" data-date="05 March 2012 - 05:24 AM">
Yes we can read the data from xls/xlsx file using BIRT. 
 
When you are creating DATASORCE. just choos flat file data source. 
 
Regards, 
Arun </blockquote>
 
 
Hi Arun, 
 
Can I also read xls/xlsx data from DataSet using Java?

arunkumarb

<blockquote class='ipsBlockquote' data-author="'rohitmali'" data-cid="97223" data-time="1330950828" data-date="05 March 2012 - 05:33 AM">
Hi Arun, 
 
Can I also read xls/xlsx data from DataSet using Java? </blockquote>
 
 
Yes, you can also read xls/xlsx data from DATASET using java. 
When you are creating DATASOURCE, just choose scripted data source. 
Regards, 
Arun

rohitmali

<blockquote class='ipsBlockquote' data-author="'arunkumarb'" data-cid="97224" data-time="1330951420" data-date="05 March 2012 - 05:43 AM">
Yes, you can also read xls/xlsx data from DATASET using java. 
When you are creating DATASOURCE, just choose scripted data source. 
Regards, 
Arun </blockquote>
 
 
Hi Arun, 
 
I have created Data Source using Excel Data Source Option and also created the Data Set. 
In preview, I am able to see the data of excel file. 
Now I want to make list of this data and send it to Java method, so that I can save it DB. 
How to do this?

rohitmali

How to read data from XLS/XLSX file using BookModel and Document Objects? 
 
Is anybody able to share the Java Code?