Export table and contents from mail to an excel sheet using JAVA code

[Foni kumar]

Hi Experts,

Can anyone suggest me or provide me any sample codes/useful reference links that can read a table named "SAMPLE" with three columns ,sent to me in my GMAIL mail. Now my code should read the table and its column data , then copy it into an automatically created excel sheet in my local drive.

Appreciate for all your assistance in this regard. I wonder if we need to use any other method to read the table structure from a mail into an excel , from excel to excel a=or database to excel i know we make use of POI..

Thanks and Regards,
Debashis

[I Wayan Saryada]

So, what was the real questions are? Do you need a better way to read a data from a database? Do you need to send email using Gmail?, etc. It would be better if you could post your code and tell us what improvement that you want.

[Foni kumar]

I Wayan Saryada wrote:So, what was the real questions are? Do you need a better way to read a data from a database? Do you need to send email using Gmail?, etc. It would be better if you could post your code and tell us what improvement that you want.

I think you got my question wrong, well what I wanted to state is I have one pictorial view of a table say SAMPLE with three columns and 3 rows values in it. Now please let me know if there is a way I can fetch this table from the mail into my excel sheet and populate all the data corresponding to the columns in the table.

I know the approach we need to do for fetching it from DATABASE but in this case it is an email where we have the table structure. so any idea, I am actually looking for ideas or approach if you suggest any before I can look into the coding part.

Thanks!

[I Wayan Saryada]

So this is not a database table? Do you mean an html table? And you want to convert this table into excel document?

Sorry, I am still confuse with the question.

[Campbell Ritchie]

That sounds too difficult a question for “beginning”, so I shall move it.