how to display the data from excel to webpage

Hi,

I need help on following

I have a webpage contains a text box and a button(get), i give a value in text box such as serial no. like 4024 and by click on get button it should search for the value 4024 in a excel file and to display the remaining values on the same row.

please help me out of this

View Answers

August 8, 2012 at 10:40 AM

Here is a jsp code that reads the excel file and store data into table.

<%@page import="java.io.*"%>
<%@page import="java.util.*"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFSheet"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFWorkbook"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFRow"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFCell"%>
<html>
<table border="1">
<%
 short a=0;
  short b=1;
  short c=2;
  short d=3;
  int i=0;
   String   value1="", value2="",value3=" ", value4="";
    String filename ="C:/hello.xls"; 
    if (filename != null && !filename.equals("")) {
    try{
    FileInputStream fs =new FileInputStream(filename);
    HSSFWorkbook wb = new HSSFWorkbook(fs);
    for (int k = 0; k < wb.getNumberOfSheets(); k++){
    int j=i+1;
    HSSFSheet sheet = wb.getSheetAt(k);
    int rows  = sheet.getPhysicalNumberOfRows();
    for (int r = 0; r < rows; r++){
    HSSFRow row   = sheet.getRow(r);
    int     cells = row.getPhysicalNumberOfCells(); 
    out.write("<br>");
    HSSFCell cell1  = row.getCell(a);
      value1 = cell1.getStringCellValue();
      HSSFCell cell2  = row.getCell(b);
        value2 = cell2.getStringCellValue();
         HSSFCell cell3  = row.getCell(c);
         value3 = cell3.getStringCellValue();
          HSSFCell cell4  = row.getCell(d);
          value4 = cell4.getStringCellValue();
    %>
    <tr><td><%=value1%></td><td><%=value2%></td><td><%=value3%></td><td><%=value4%></td></tr>
    <%
    }
        i++;
    }
    }
    catch(Exception e){
        System.out.println(e);
    }
    }
    %>
    </table>
    </html>

Advertisements

How to export the table content from an webpage to excel using java?
How to export the table content from an webpage to excel using java? How to export the table content from an webpage to excel using java? The table contents are generated dynamically in that java page

How to get data from Excel sheet - Struts
How to get data from Excel sheet Hi, I have an excel sheet with some data(including characters and numbers). Now i want read the data from excel sheet and display in console first then later insert this data into database

how to display data from database in jsp
how to display data from database in jsp how to display data from database in jsp

How to export data from html to excel sheet by using java
How to export data from html to excel sheet by using java How to export data from html to excel sheet by using java

How to export data from jsp to excel sheet by using java
How to export data from jsp to excel sheet by using java How to export data from jsp to excel sheet by using java

Fetching data from excel file on other website and display in interactive graph form
Fetching data from excel file on other website and display in interactive graph... which have zip files and excel files and they get updated everyday, so how can i pull data data from those and generate graphs out of it? I really need it urgently

read data from Excel sheet
read data from Excel sheet Hi, How to read data from an excel sheet using JSP. Thank you

How to Get The Data from Excel sheet into out jsp page???
How to Get The Data from Excel sheet into out jsp page??? How to Get The Data from excel sheet to out jsp page in webApp

How to export data from html file to excel sheet by using java
How to export data from html file to excel sheet by using java How to export data from html file to excel sheet by using java

How to export data from html file to excel sheet by using java
How to export data from html file to excel sheet by using java reading the data from Html file

How to Retrieve Data from the database and write into excel file using Java
How to Retrieve Data from the database and write into excel file using Java Hi, I am trying to develop an small application where i trying to retrieve Data from the database and store the details in excel file. Please can

How to read and display data from a .properties file from a jsp page
How to read and display data from a .properties file from a jsp page�... the data from this .properties file and display it in table format. Ex:by using... = DEDCHGG_PWDP and goes on... I have to create a jsp page to show these data

how to display data from jsp file into database
how to display data from jsp file into database this is a jsp file...(); in the below example. the error is "cannot convert from java.sql.Statement...+","+ph2+")"); out.println("Data is successfully inserted

How to display data from database in a TableView
How to display data from database in a TableView I need to populate... at this. The classes: This is the Class that creates the database data object: import...; data; private List<NewBeautifulKiwi> initializeTable() { data

Function data from web in MS excel
Function data from web in MS excel Hello, I would like to import data from one webpage to Excel using function Data - From Web. The problem is that this web page has at the end .jsp . When I open it via Excel, click to data

How to import data from sql server table into an excel file by creating the rows dynamically in the excel according to the dataabase??
How to import data from sql server table into an excel file by creating the rows dynamically in the excel according to the dataabase?? How to import data from sql server table into an excel file by creating the rows dynamically

How to draw to graph in Ms Excel from the data which is sent from an java application....?
How to draw to graph in Ms Excel from the data which is sent from an java application....? How to draw to graph in Ms Excel from the data which is sent from an java application

displaying data from ms excel in form.
displaying data from ms excel in form. Hi all, I have a requirement as mentioned below: Requirement: I have stored some data in the ms excel... in the column of the excel and also the mechanism to get this data and display

how to display data into textboxes which is retrieved from the database
how to display data into textboxes which is retrieved from the database I would like to know how to display data into textboxes which is retrieved from database in jsf. could you please provide a small example of how to do

How to display data in jsp from dao using java beans?
How to display data in jsp from dao using java beans? Hi I need to display data in jsp pulling from dao using java beans, Please can anyone give me the sample application with above topics. Any help would be highly appreciated

php import data from excel to mysql
php import data from excel to mysql php import data from excel to mysql

Retrieving specific data from excel
Retrieving specific data from excel Hello everyone, i have written a simple code to retrieve data from excel sheet and working fine, the excel file... first sheet from the workbook HSSFSheet sheet = workbook.getSheetAt(0

How to export data from database to excel sheet by using java in standalone project
How to export data from database to excel sheet by using java in standalone project How to export data from database to excel sheet by using java in standalone project

read excel data from jsp - JSP-Servlet
read excel data from jsp Hi how to read excel file from jsp? Excel file is created manually entered data having many sheets? and read the entire...)excel.jsp: Read And Edit Excel File continue

Store data in HTML forms from Excel sheet
Store data in HTML forms from Excel sheet I have a excel file having multiple coloums, and having one Html page having forms corrospoding to excel coloums. I want to auto fill up the excel data into html forms, Any one please

copy something from a webpage to my webpage
copy something from a webpage to my webpage How can I copy something from a webpage to my webpage

extract data from excel sheet to mysql
extract data from excel sheet to mysql sir, i want to extract data from excel sheet and save the data in mysql5.0 database in the form of table

Hi how to transfer table data from html page to excel sheet by using javascript .
Hi how to transfer table data from html page to excel sheet by using javascript . html page to excel sheet by using javascript and i dont want to transfer all rows in table, i want to hide some rows in excel sheet. Please send

How to display data from database in a TableView via Hibernate
How to display data from database in a TableView via Hibernate I... at this. The classes: This is the Class that creates the database data object...;NewBeautifulKiwi> data; private List<NewBeautifulKiwi> initializeTable

how to get the data from database&how to display the database data in jsf - Java Server Faces Questions
how to get the data from database&how to display the database data in jsf Hi, 1.how to get the data from database. 2.how to display the database... and to display the data from database in jsf visit to : http://www.roseindia.net/jsf

how to display the selected row from the data table in model panel ??
how to display the selected row from the data table in model panel ?? the below displayed is my datatable:tableDatas.xhtml <rich:dataTable value="#{tableRecordBean.dataList}" var="dataItems" onRowClick="#{rich

how to display data from database according to entered value in search field
how to display data from database according to entered value in search...;/html> this is my searchview2.jsp file where it display the result <...("SELECT M.MEMBER_ID, M.FNAME,M.LNAME,M.AGE,B.HEIGHT,B.WEIGHT, B.BMI_VALUE FROM

how to display data from mysql table in text box using jsp??
how to display data from mysql table in text box using jsp?? <p>hi, i have a written a code to display data from a mysql table into txtboxes... QueryString = "SELECT * FROM code<em>ot WHERE code</em>codeot=12

export data from database to excel sheet - JDBC
export data from database to excel sheet I am facing a problem about exporting required data from database table to ms-excel sheet.i mean whenever I execute a query then result will be display in MS-EXCEL sheet. please give me

Display Data from Database in JSP
; <html> <head> <title>display data from...;To display all the data from the table click here...</h2></TD>...;head> <title>display data from the table using jsp</title> <

Read data from Excel and insert in to DB and export data from DB to Excel
Read data from Excel and insert in to DB and export data from DB to Excel Read data from Excel and insert in to DB and export data from DB to Excel Hi, I need to read the data from excel and I need to insert the same in to DB

reading data from excel file and plotting graph
reading data from excel file and plotting graph I am doing a project... at the same time from one excel file using different columns..how can i do that? waiting... the data in excel file, i have to plot graphs based on CELL ID selected. please help

how to read data from excel file through browse and insert into oracle database using jsp or oracle???
how to read data from excel file through browse and insert into oracle database using jsp or oracle??? sir.. i have number of excel sheets which... a browse button which can upload a excelfile and after uploading the data should

how to send the content of jtextarea from netbeans IDE to webpage's textarea in java
how to send the content of jtextarea from netbeans IDE to webpage's textarea in java Hi, i m interested to send the content of my jtextarea which i have developed in netbeans IDE to the webpage's textarea. how can i do

how to display the excel file content in the jsp
how to display the excel file content in the jsp How to present the content of the newly created excel file in the following jsp to the web browser...="application/vnd.ms-excel" %> <%@ page import="java.io.*" %> <

how to display the output of the newly created excel file
how to display the output of the newly created excel file the following program will create the test.xlsx file, how can i display the content...;%@ page contentType="application/vnd.ms-excel" %> <%@ page import="java.io.

How to insert rows from Excel spreadsheet into database by browsing the excel file?
How to insert rows from Excel spreadsheet into database by browsing the excel file? I want to insert rows from excel sheet to database.for this i... the excel file using file browsing dialogue through form in JSP. How can i select

Fetch the data from mysql and display it on php form
Fetch the data from mysql and display it on php form when i press on login button, after succesful login the related data of that person should be display in other textbox

How to export data from database to excel sheet by using java swing in standalone project - Java Beginners
How to export data from database to excel sheet by using java swing... from u to solve my problem. my problem is i don know how to export data from database to excel sheet by using java swing in standalone project.I get solution from

how to display the excel file in the web browser.
how to display the excel file in the web browser. > %@ page.../vnd.ms-excel" > %> <%@ page import="java.io.*" %> <% >... FileOutputStream > ("c:\\excel\\aqtemplate.xlsx"); > wb.write

Ads