Solved

How to export data to an excel sheet ?

Posted on 2004-10-18
9
451 Views
Last Modified: 2008-02-01
I read data from database. I need to put all data to an excel sheet and display at the client side.
Let me know how can i do that. I tried changing contentType to vnd-msexcel. But this does not display the cell borders
0
Comment
Question by:AbhijitCPatil
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
  • +1
9 Comments
 
LVL 14

Expert Comment

by:Thandava Vallepalli
ID: 12338342
0
 
LVL 14

Expert Comment

by:Thandava Vallepalli
ID: 12338344
0
 
LVL 14

Expert Comment

by:Thandava Vallepalli
ID: 12338354
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Accepted Solution

by:
matthew_york earned 125 total points
ID: 12338700
In case you want to do this in java rather than using the ASP examples that itsvtk gave:

You could use the hssf part of poi in a servlet:

http://jakarta.apache.org/poi/hssf/
http://jakarta.apache.org/poi/hssf/how-to.html

Let me know if you need any further code examples.


0
 

Author Comment

by:AbhijitCPatil
ID: 12338789
HI

i am using JSP as UI so this has to done at clients side
so is there any way i can do it in javascript

any way Thanks a lot for Help

Rgds
Abhijit
0
 
LVL 1

Expert Comment

by:prabhukrishnan
ID: 12343215

When you need to set content type to something other that text/html, I think it is better to use a servlet.

In one project where we needed this functionality,we used a servlet.Set the content type to application/vnd.ms-excel.
Created a tab delimited string for the required columns and sent the string.

regards
Prabhu
0
 
LVL 14

Expert Comment

by:Thandava Vallepalli
ID: 12355062
Convert your code from JSP to ASP is very easy.... Almost most of the code will work as it is...

itsvtk
0
 

Author Comment

by:AbhijitCPatil
ID: 12431100
Hi  matthew_york

Now i am able to write to excel file. Thanks for Ur help.

Now there is one more problem Now i want to retrive the data.
back means now i want to read the Excel file
is there any way

Thanking you

Abhijit
0
 
LVL 1

Expert Comment

by:matthew_york
ID: 12654182
Hi Abhijit, I'd use something along the following lines:

// Open workbook
HSSFWorkbook wb = new HSSFWorkbook(new POIFSFileSystem(new FileInputStream("c:\\temp\\blank.xls")));

// Edit workbook
HSSFSheet sheet = wb.getSheet("Sheet1");
HSSFRow row = sheet.getRow(9);
HSSFCell cell = row.getCell((short) 2);

// Get Value
double value = cell.getNumericCellValue();
// or
String value = cell.getStringCellValue();

Hope this helps.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
grep code 4 216
Using Tomcat as raspberry pi java app server 13 278
equalIsNot  challenge 43 183
Suggestion on WebSite Template Sites 6 124
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
A big percent of today’s marketing activity is performed through the online environment. The marketing strategies that have existed a decade ago no longer relate to what’s happening today. We’re currently facing a revolutionary era, called the digit…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question