• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 461
  • Last Modified:

How to export data to an excel sheet ?

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
AbhijitCPatil
Asked:
AbhijitCPatil
  • 4
  • 2
  • 2
  • +1
1 Solution
 
Thandava VallepalliCommented:
0
 
Thandava VallepalliCommented:
0
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
matthew_yorkCommented:
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
 
AbhijitCPatilAuthor Commented:
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
 
prabhukrishnanCommented:

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
 
Thandava VallepalliCommented:
Convert your code from JSP to ASP is very easy.... Almost most of the code will work as it is...

itsvtk
0
 
AbhijitCPatilAuthor Commented:
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
 
matthew_yorkCommented:
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

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 4
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now