Re: HSSF Servlet.

[Mike Troxclaire]

Thanks a lot for your response, Danny. That is exactly what I thought but I 
just wanted to verify with you experts before going through that route. So I 
am trying to follow this approach, please feel free to throw any kind of 
input that you guys might have. I will write vba functions for the 
validation of the spreadsheet and put that as a template on a common network 
drive. I will provide a simple link on our intranet site for the user to 
download that spreadsheet. When they download that spreadsheet they can copy 
and paste the data into the spreadsheet. I can write vba functions which 
would highlight the data pasted in wrong format so that the user can correct 
it themselves. Now here is the problem, I want the user to be able to upload 
that spreadsheet data into a db2 database. I do not know if there is a way 
for the user to do that without specifying odbc connection. I have created a 
odbc connection on the server and I can upload the spreadsheet data to the 
database without any trouble at all. Do you think that the user can upload 
the spreadsheet onto the server with the same name that I have set up the 
DSN for and then click on a upload link(this will be a java bean) and then 
the bean loads up the data into the database that way the user does not have 
to go through setting up the odbc stuff. But this may cause a conflict if 
there are multiple users trying to upload the spreadsheets at the same time. 
Dont you think? Please feel free to throw some light....

Cheers,
Mike.

From: Danny Mui <[EMAIL PROTECTED]>
Reply-To: "POI Users List" <[EMAIL PROTECTED]>
To: POI Users List <[EMAIL PROTECTED]>
Subject: Re: HSSF Servlet.
Date: Thu, 23 Sep 2004 11:07:25 -0400
MIME-Version: 1.0
Received: from mail.apache.org ([209.237.227.199]) by mc3-f12.hotmail.com 
with Microsoft SMTPSVC(5.0.2195.6824); Thu, 23 Sep 2004 08:06:18 -0700
Received: (qmail 19619 invoked by uid 500); 23 Sep 2004 15:02:35 -0000
Received: (qmail 19533 invoked by uid 99); 23 Sep 2004 15:02:34 -0000
Received: pass (hermes.apache.org: local policy)
Received: from [69.28.209.52] (HELO muibros.com) (69.28.209.52)  by 
apache.org (qpsmtpd/0.28) with ESMTP; Thu, 23 Sep 2004 08:02:34 -0700
Received: from [127.0.0.1] (softdnserr [::ffff:127.0.0.1])  by muibros.com 
with esmtp; Thu, 23 Sep 2004 11:03:24 -0400
X-Message-Info: JGTYoYF78jFaz7uWfuwrZhUjFptYY8DU
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:[EMAIL PROTECTED]>
List-Subscribe: <mailto:[EMAIL PROTECTED]>
List-Help: <mailto:[EMAIL PROTECTED]>
List-Post: <mailto:[EMAIL PROTECTED]>
List-Id: "POI Users List" <poi-user.jakarta.apache.org>
Delivered-To: mailing list [EMAIL PROTECTED]
X-ASF-Spam-Status: No, hits=0.0 required=10.0tests=
X-Spam-Check-By: apache.org
Message-ID: <[EMAIL PROTECTED]>
User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913)
X-Accept-Language: en-us, en
References: <[EMAIL PROTECTED]>
In-Reply-To: <[EMAIL PROTECTED]>
X-Virus-Checked: Checked
Return-Path: 
[EMAIL PROTECTED]
X-OriginalArrivalTime: 23 Sep 2004 15:06:19.0601 (UTC) 
FILETIME=[E1981C10:01C4A17E]

this sounds like frontend functionality that is best put into 
macros/vbscript for excel to maintain unless you want to do the validation 
on the server side (cell by cell...).

Mike Troxclaire wrote:
Hello Gurus,
I am trying to create an application where the user could a link and it 
would create a formatted spreadsheet for them and lets them download that 
spreadsheet onto their harddrive. Then I want to force them to follow the 
format that I have set in the spreadsheet but I am not able to do that. 
When the user is copying and pasting data all the formatting is lost in 
the spreadsheet. I want the formatting to stay and may be give them a pop 
up message if they are pasting the wrong data in the spreadsheet. Is this 
doable? Any suggestions/input/ideas are much appreciated.

Cheers,
Mike.
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
_________________________________________________________________
Don�t just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]