Retrieve Data from CSV file in JSP

Home Jsp Retrieve Data from CSV file in JSP

Google Advance Search
RoseIndia.Net Search

Retrieve Data from CSV file in JSP
Posted on: September 26, 2008 at 12:00 AM

CSV file : A CSV file is commonly known as a Comma Delimited File or a Character Separated File.

Retrieve Data from CSV file in JSP

CSV file : A CSV file is commonly known as a Comma Delimited File or a Character Separated File. It is a text file that has a specific format which allows saving of text in organized manner. This format known as a flat table, is very simple. Each row contains one record of information. The character used to distinguish each piece of data within each record is most commonly used a comma ",".

"myfile.csv" in the c:\csv folder

Create a Page ("ReadCsvFile.jsp") to retrieve the data from CSV file "myfile.csv".

<%@ page import="java.io.*"%>
<html>
<body>
<%
String fName = "c:\\csv\\myfile.csv";
String thisLine;
int count=0;
FileInputStream fis = new FileInputStream(fName);
DataInputStream myInput = new DataInputStream(fis);
int i=0;
%>
<table>
<%
while ((thisLine = myInput.readLine()) != null)
{
String strar[] = thisLine.split(",");
for(int j=0;j<strar.length;j++)
{
if(i!=0)
{
out.print(" " +strar[j]+ " ");
}
else
{
out.print(" <b>" +strar[j]+ "</b> ");
}
}
out.println("<br>");
i++;
}
%>
</table>
</body>
</html>

Output

Download full source code

Related Tags for Retrieve Data from CSV file in JSP:
c, gui, com, file, orm, table, text, data, ui, form, csv, io, sed, format, char, vi, limit, this, ai, character, simple, tab, row, if, tex, for, ie, record, cte, with, to, contains, each, avi, information, ci, ws, sh, ext, e, il, it, comma, li, mit, use, pe, im, man, ce, in, no, rm, saving, info, cs, as, m, nt, par, separate, thin, sti, os, os, spec, flat, common, all, pie, pi, rate, which, s, sp, delimited, del, at, rac, k, is, ha, inf, ll, mpl, fla, ea, ann, ar, act, specific, sa, sim, xt, vin, z, s, s, rd, th, av, st, ab, abl, ati, hat, ga, inform, informat, org, piece, ple, pl, most, mi, only, on, om, o, nl

«Previous Index Next»