> -----Original Message-----
> From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 02, 2001 10:56 PM
> To: 'Simon Oliver '
> Cc: '''[EMAIL PROTECTED]' ' '
> Subject: RE: Extract data from MS Excel Spreadsheets. Can it be done?
>
>
> Also I would think that this is a big enough issue to
> address, since most of
> the servers are not NT and most of the clients are win32, therefore if
> clients are working on excel which is later uploaded to the
> server (Unix),
> it should be processed on the server side, rather than having
> users save as
> CSV.
I think we have side tracked here somewhat and are getting away from seeing
the problem. What needs to be addressed?
For an Excel Document to exist, there must be a Windows Machine somewhere.
Information can be extracted from this using ODBC, OLE, ADO, and all manner
of text ripping that Perl is well suited to. As a "database client", this
Windows machine has all of the Native Windows ways of doing things and, of
all wonderous suprises, a Perl that runs on it too.
It seems that the focus of this thread has hitherto been about getting an MS
Excel spreadsheet onto Solaris and then processing the contents. The point
that should be open for consideration is, do you really want the whole
spreadsheet anyway, or is this just a simple tool for a user to fill in
table
information?
Unless you have some arcane layout of information in the Spreadsheet, your
probably just want to extract a table with DBD::ADO or DBD::ODBC. In fact if
the layout is anything but a table, DBI is just not your tool.
The simple thing to do is process the Excel Data on the Win32 box and send
that data to your database of choice. This can be done from either end, very
easily with just a little thought put into the process.
-- Neil
> Ilya Sterin
>
> -----Original Message-----
> From: Simon Oliver
> Cc: ''[EMAIL PROTECTED]' '
> Sent: 05/02/2001 2:27 AM
> Subject: Re: Extract data from MS Excel Spreadsheets. Can it be done?
>
> Steve Sapovits wrote:
>
> > If I'm wrong about this and someone's used either DBD::ADO or
> > DBD::ODBC on Sun/Solaris, I'd like to hear how you did it.
> One can't use DBD::ADO because that uses Win32::OLE which
> needs a Win32
> Operating System.
>
> --
> Simon Oliver
>
__________________________________________________________________________
Please Note :
Only the intended recipient is authorised to access or use this e-mail. If
you are not the intended recipient,
please delete this e-mail and notify the sender immediately. The contents
of this e-mail are the writer's
opinion and are not necessarily endorsed by the Gunz Companies unless
expressly stated.
We use virus scanning software but exclude all liability for viruses or
similar in any attachment.
