Hi Gurus,
    Sorry for less(or maybe wrong) data. I have uploaded the file through an
html page. Now my action program has to parse this excel file. It is in CGI so I
tried the following thing:

<code>
use CGI;

 my $file_handle = $query->upload("excel_file");
 if (defined $file_handle)
{
     binmode($file_handle);

     $attachment .= $_  while <$file_handle>;
 }
 close $file_handle;

open(UPLOAD, ">$file_name")  ||  print "Can not open $file_name:$!";
binmode UPLOAD;
print UPLOAD $attachment;
close(UPLOAD);

## Now I start with my excel parsing using Spreadsheet::ParseExcel on $file_name

</code>

I hope I am clear. I am too confised currently.

Thanx,
Parvez


"$Bill Luebkert" wrote:

> parvez wrote:
> > Hi Gurus,
> >     I want to parse an excel file which will be uploaded through the
> > browser and passed to my CGI script. I can read the file through the
> > command prompt(Thanks to Spreadsheet::ParseExcel !!). My problem is that
> > I cannot detach the file and read it.
> > Please HELP !!
>
> What do you mean you can't detach it ?  Detach from what ?
>
> Are you having trouble doing the upload or what ?
>
> --
>    ,-/-  __      _  _         $Bill Luebkert   ICQ=162126130
>   (_/   /  )    // //       DBE Collectibles   Mailto:[EMAIL PROTECTED]
>    / ) /--<  o // //      http://dbecoll.tripod.com/ (Free site for Perl)
> -/-' /___/_<_</_</_     Castle of Medieval Myth & Magic http://www.todbe.com/

_______________________________________________
Perl-Unix-Users mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Reply via email to