Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa Spring getting the excel path throuh web browser given from client(i.e thruogh .jsp)
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


harika
getting the excel path throuh web browser given from client(i.e thruogh .jsp)
1 Answer(s)      2 years and 6 months ago
Posted in : Spring


1)when client uploads the excel sheet through a .jsp page, 2)get that excel path from web browser and read the data from the excel and printing in a jsp page i.e response to client through jsp

please provide the code in spring thanks in advance


Advertisement
View Answers

November 8, 2013 at 11:45 AM


        HSSFWorkbook hwb=new HSSFWorkbook();
        HSSFSheet sheet =  hwb.createSheet("new sheet");
        HSSFRow rowhead=   sheet.createRow((short)0);
        HSSFRow row=   sheet.createRow((short)count1);
        rowhead.createCell((short) 0).setCellValue("SL NO");
        rowhead.createCell(1).setCellValue("BILL No");
        rowhead.createCell((short) 2).setCellValue("STUDENT NAME - CLASS");
        rowhead.createCell((short) 3).setCellValue("COLLECTION DATE");
        rowhead.createCell((short) 4).setCellValue("FEES NAME");
        rowhead.createCell((short) 5).setCellValue("AMOUNT");
        rowhead.createCell((short) 6).setCellValue("USER");


row=   sheet.createRow((short)count1);                              row.setHeightInPoints(20);                              row.createCell((short) 0).setCellValue(i);                              row.createCell((short) 1).setCellValue(res.getString(1));                           row.createCell((short) 2).setCellValue(res.getString(6)+" - "+res.getString(2)+" - "+strClassName);
                                    row.createCell((short) 3).setCellValue(validate.daterev(res.getString(5)));
                                    row.createCell((short) 4).setCellValue(x);                      row.createCell((short) 5).setCellValue(res1.getDouble(2));                      row.createCell((short) 6).setCellValue(res.getString(4)); 

        FileOutputStream fileOut =  new FileOutputStream(filename);
        hwb.write(fileOut);
        fileOut.close();
            <a href="<s:property value="feesReportExcelPath"/>">To Excel</a>


Related Tutorials/Questions & Answers:
getting the excel path throuh web browser given from client(i.e thruogh .jsp)
getting the excel path throuh web browser given from client(i.e thruogh .jsp)  1)when client uploads the excel sheet through a .jsp page, 2)get that excel path from web browser and read the data from the excel and printing
how to present the excel to the web browser in jsp
how to present the excel to the web browser in jsp  How to present the content of the newly created excel file in the following jsp to the web browser: <%@ page import="java.io.InputStream" %> <%@ page import
Advertisements
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
shortest path from the given source to dstination
shortest path from the given source to dstination  Hi. Here in my databse. CREATE TABLE b ( id int(10) unsigned NOT NULL AUTO_INCREMENT, source... to find the shortest path from the given source to destination based
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
Shortest path in JSP for a given source and destination
Shortest path in JSP for a given source and destination  Hi. Here... the shortest path from the given source to destination based on the databse values. I want to do this in JSP. I have to get the source and destination in text box
Shortest path in JSP for a given source and destination
Shortest path in JSP for a given source and destination  Hi. Here... the shortest path from the given source to destination based on the databse values. I want to do this in JSP. I have to get the source and destination in text
Getting File path error - JSP-Servlet
Getting File path error  I have a requirement where i need to get certain properties on application login page start itself. I an currently using String str = request.getRealPath("/")+"a" + System.getProperty( "file.separator
difference from browser to browser - JSP-Servlet
difference from browser to browser  I am developing a project in jsp. When browse in mozilla it works good and when I open it with IE there is a difference how to overcome this problem.Thanks in advance
Show pdf's in web browser by using jsp?
Show pdf's in web browser by using jsp?  Hi, I want to display pdf file in browser by clicking the link, available in JSP page. When am trying to do this by using Anchor tag with absolute path, it is showing the error as: Http
Problem in getting file path in js
Problem in getting file path in js  hi, I am using ofbiz framework , How i can get the file path in javascript for input type = "file" and i am using only firefox not other browser. so please help me it is very important for me
to run html code in web browser - JSP-Servlet
to run html code in web browser  how to run jsp file which calls html file on web browser??  Hi Friend, Try the following code: 1)form.jsp: Enter Name: 2)welcome.html: Add Profile Edit
How to export web page to excel using java or jsp or servlets
How to export web page to excel using java or jsp or servlets  Hi I am trying to export web page(jsp page ) to excel using jsp or servlets. I am retrieving records from database and displaying in the jsp page, In this page I
Getting a absolute path
Getting a absolute path     ... the path of the file or directory so that you can access it. If you know the path... in front you where you don't know the path of the file, then what will you do
retrieving of value from excel file - JSP-Servlet
that excel sheet i.e this matter will take a para meter values from the excel...retrieving of value from excel file  Dear sir, Thanks for sending a code now i am getting a particular column values i.e EmailId column for sending
retrieving of value from excel file - JSP-Servlet
that excel sheet i.e this matter will take a para meter values from the excel...retrieving of value from excel file  Dear sir, Thanks for sending a code now i am getting a particular column values i.e EmailId column for sending
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 sheet and also edit with jsp? pls suggest me?   Hi Friend, 1
retrieving of value from excel file - JSP-Servlet
retrieving of value from excel file  Dear sir, Thanks for sending a code now i am getting a particular column value i.e EmailId column for snding a massmails,now i have to get a particular column values i.e Name(A),EL(B
PHP Open Excel File in browser - PHP
PHP Open Excel File in browser  How we can open an excel file using PHP code. I don?t want to let the user to download it rather I would like to get it open in the web browser. Any help would be great. Thank you very much
getting values from database - JSP-Servlet
getting values from database  I tried the following code abc.html aaa.jsp I am not getting exceptions now. But I am not getting output also. Plz help.   Hi Friend, Run your
getting contacts from gmail - JSP-Servlet
getting contacts from gmail  hi there, would you please tell me step by step how can i integrate the gmail contacts with my web application. please reply me asap. I'll be greatfull to you. Rajesh
File download from server to client machine - JSP-Servlet
File download from server to client machine  hi, I want to save a pdf file to my client machine from a button provoded in a jsp page.The file that was generated by jasper libraries.In my code i can give path for save
Web Server
or intranet and interacts with the client through a web browser and delivers the web... to support Servlet and JSP web components. A web server does not provide support for EJB component. Web server accepts HTTP requests from the client and provides
To download a website from a given url. - JSP-Servlet
To download a website from a given url.  write a program to download a website from a given URL.it must download all the pages from that website.it should take the depth of retrieval from user input.all the files pages must
web service client
web service client  i have implement web service client in netbeans and it work will using wsdl but know i want to Develop a webserivce (or a Java RMI server/client) for one of the e-services but i do not know the wsdl link how
excel uploading in jsp
excel uploading in jsp  could you provide the source code for: 1)have to upload an empty excel sheet at client side i.e if client clicks an excel... given and printing them in a jsp page. could you please provide the code in spring
Getting path name of uploading file in struts 2.1.8
Getting path name of uploading file in struts 2.1.8  In my question I used struts 2.8.1 instead of 2.1.8. Sorry
Getting path name of uploading file in struts 2.8.1
Getting path name of uploading file in struts 2.8.1  Hai! I am using struts 2.8.1. I want to upload file into database with the path name. How can I can get the original path name of the file in struts 2.8.1? It only display
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
Java Web Browser Problem
Java Web Browser Problem  Hello When run my web browser this is not displaying complete page any of the website like other browser.So Plz help me...."); setTitle("NextVision Browser"); setSize(600,400); Container
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
 

 

 

DMCA.com