Thanks for the replies.
Our data group has decided that they will extract the
information from excel into their database themselves
I just need to generate excel and let users modify
that excel through the front end.
That get me to another dilema :-
Can I make portions of the excel 'read only' through
HSSF?
I went thru the previous questions and found that POI
HSSF does not support password protection in Excel.
I there a way I make some portions read only ? ( I do
not want any password protection)
Thanks,
qgh
--- Wulf Wechsung <[EMAIL PROTECTED]> wrote:
>
> Hi Ogh,
>
> if plattform is not an issue for you, you can use
> odbc for that purpose.
> One requirement though: Your tables need to be
> extremly well formed (header,
> data thats it, no fancy stuff). I made a convinience
> API that makes opening
> odbc datasources a charm. It can also create new
> ones or delete existing.
> For working on tables you can use either a JDBC
> Connection or the
> abstraction I made, which basically returns
> javax.swing.TableModel's instead
> of RecordSets. It's not very well documented (yet
> :), but includes testcases
> and a sample application. If you want to you use it,
> just email me and I'll
> send it to you (no need to pollute the mailing list
> :).
>
> Steps for doing it without my code (Win2k):
>
> First you need to register your excel file as odbc
> datasource
>
> Got to Control Panel -> Administrative Tools -> Data
> Sources -> Choose
> Excel-Files and 'New', the rest should be
> self-explaining, do remember the
> name you gave your new datasource though
>
> some sample code:
>
> // The jdbc driver you'll be using (is included in
> the J2SE)
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
>
> //Connection string where ds_name must be the
> datasource name you assigned
> before
> con =
>
DriverManager.getConnection("jdbc:odbc:ds_name","","");
>
>
> //sample select where sheet_name is the name of,
> well, the sheet you want to
> work with
> // for some strange reason, "[ $]" has to be there.
> select = con.prepareStatement("select * from
>
[sheet_name$]",ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
>
>
> Hope that helped!
>
> Cheers,
> Wulf
>
>
> -----Ursprungliche Nachricht-----
> Von: Qgh Rohgy [mailto:[EMAIL PROTECTED]
> Gesendet: Samstag, 15. Marz 2003 03:23
> An: [EMAIL PROTECTED]
> Betreff: Use of HSSF for Excel interface with
> Database?
>
>
> Hello,
>
> I have a project which need an excel interface for
> the
> users to create/update/delete multiple records in
> the
> database tables.
>
> Could I use POI HSSF API for this purpose?
>
> I went through the API and realized that there is no
> easy way to do so. Unless I find the value of each
> Cell in the Excel file.
>
> Example :-
>
> Date Amount
> 3/13 20
> 3/14 25
> 3/12 15
> 3/13 10
>
>
> I have 2 columns in my XLS file
> Date and Amount.
>
> I want to update values in my Database of rows whose
> Date is greater than 3/12.
>
> Is there an efficent way of querying this in HSSF
> and
> then updating the Db table?
>
> Is it possible? How should I do it?
>
> Is there any other API that I could use?
>
> Thanks in advance,
> qgh
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Web Hosting - establish your business online
> http://webhosting.yahoo.com
>
>
---------------------------------------------------------------------
> 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]
>
__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
