Madhav.T.Reddy wrote:Nope. Use third party stuff, or don't do it.
I have requirement to read&write data from Excel ,
I know many of third party libraries provide this fecility but my project restricted to use only JAVA API.
In My project ,we are not suppose to use any third party libraries.
is any JAVA API for Excel operations?
But thing is the text file treat as entire data is one data,it's not like row wise and column wise.I don't know what that means. An Excel file isn't 'one data', it is in fact one or more spreadsheets, each of which contains rows and columns.
we can read the data by stream as whole from file ,but how can get/know EMP data based on EMP id.It's just a column in a row, just like everything else in the file.
Regarding Secuirty constrains of my project i am not send the Actually Requirement or data.Nobody has asked for it. I don't see the point of this remark.
Basic requirement is Based Trans ID i need to get Email ID then send the email to Businees people.These statements have no relevance to this forum.
Right now Excel has data for all Trans ID.
how can acchive this issues the Same Excel data converted in to Text file data.This question has no ascertainable meaning whatsoever. You've been told you must use CSV. I have no idea what you're asking for now.