473,662 Members | 2,693 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

how to retriew the data from the excel into the jsp page

kaleeswaran
132 New Member
hi!
i need to get the value from the excel sheet and display it on the jsp page...
i have no idea about this...so give me some solution regarding this,.,,,,,,,
thank you,
kaleeswaran
Nov 19 '07 #1
2 1351
itsraghz
127 New Member
As MS-Excel is totally different kinda application and it has its own structure, headers etc, we may have to make use of a different third party API to interact with it and give us the content.

Its like a Driver to the database.

I would suggest you can go for 2 different open source APIs.

(1) Apache POI HSSF
(2) JExcel

Just google for the same. You will get a sample tutorial on how to do it also.

Hope this helps!

Cheers,
Raghavan alias Saravanan M.
Nov 19 '07 #2
kaleeswaran
132 New Member
thank you for your replay!
i need to post the gode into my project...i need to insert the excel data into the database....it there ant idea?...
i need a sample code...
can u give me some links regarding these;......
thank you,
kaleeswaran
Nov 19 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
2835
by: Hugh McLaughlin | last post by:
Hello everyone and thanks for your help in advance. This is somewhat of a continuation of a thread that I posted about one week ago. the heart of the project requires using ADO.Net to extract data from an Excel spreadseet and display it in an ASP.Net page. Unfortuantely, the format of the page changes somewhat from day to day. For that reason, I have determined that using the Find method in Excel is the best way to determine the...
3
5238
by: Saur | last post by:
Hi, I am using an export to excel functionality from my ASP page. I have set the content type as Response.ContentType = "application/vnd.ms-excel" The data i am exporting has values like 1-2, 2-5 Now when they get exported to excel, these values get exported as 1-02-2003,2-05-2003.
3
9238
by: sridevi | last post by:
Hello How to export data from ms-access database to excel worksheet using ASP. mainly i need to export data to multiple worksheets. it is very urgent to us. i have a sample code which works only exporting to single worksheet. but i need to export data to multiple worksheets. it is very urgent to us. so please help me in code.
1
17404
by: Steven Stewart | last post by:
I have a user who has been using Excel for a while to keep statistics and print reports. She finds using it cumbersome because of long formulas and a lot of copying and pasting. I have designed a database for her which is intended to make things a lot easier; however, I don't have a lot of experience with Access and I find that designing the reports in Access is tedious. I want to be able to print the reports (which are simply based on...
1
6119
by: Anonieko | last post by:
Here are some of the approaches. 1. Transform DataGrid http://www.dotnetjohn.com/articles.aspx?articleid=36 3. Use the Export approach http://www.aspnetpro.com/NewsletterArticle/2003/09/asp200309so_l/asp200309so_l.asp
1
907
by: nemo | last post by:
Hey guys - hope this one is simple Need an app that will take a list of web site addresses (in our intranet) and return the results of the web page.. any quick way to do this?
1
1543
by: pramodrepaka | last post by:
Hello Guys Plz Help me Here is my problem . Unable to retriew the data beteen oracle and vb by using ADODC control i.e if a table consists of Nll values. i am created table and i got successful connection between oracle and VB6.0 .So i want to add some fields at vb and it should update in oracle(But not all fields) by using Addnew. But it is not able to add some fileld. But it is accepting all fields In a table some...
7
28893
Merlin1857
by: Merlin1857 | last post by:
Its great producing data for users to look at in your web pages and generally that is sufficient for their needs but sometimes you may want to supply your user with the data in a form they can actually do something more with. This code shows you how to display data from your database and then how to give that data to the user in the form of a useable Excel spreadsheet which they can then take away and play with themselves. The way I have shown...
4
1526
by: nazimsal | last post by:
Imports System.Data.SqlClient Namespace Accounts Public Class NewAccount Dim cmd As New SqlCommand Dim c As New DatabaseConnection.DataBaseConnaction.ConnectionClass Function CreateAccount(ByVal BankID As String, ByVal Account_TypeID As String, ByVal First_Name As String, ByVal Last_Name As String, ByVal Date_Birth As DateTime, ByVal Citizenship As String, ByVal Civil_Id As Integer, ByVal address As String, ByVal...
0
8345
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8857
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8547
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7368
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6186
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5655
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4181
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4348
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2763
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.