Home > Archive > PERL CGI Beginners > February 2006 > open, update, save microsoft's excel file using CGI
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
open, update, save microsoft's excel file using CGI
|
|
|
| Hi! All,
I want to open a Microsoft's excel file,(a template - stored in
server). user will update the excel file - through browser, and on
clicking save button (will be available on page), the file will get
saved at server.
I need it very urgently.............could any body HELP?
Thanks in advance
Mnaoj
| |
| Paul Lalli 2006-02-08, 8:53 am |
| Manoj wrote:
> I want to open a Microsoft's excel file,(a template - stored in
> server). user will update the excel file - through browser, and on
> clicking save button (will be available on page), the file will get
> saved at server.
So what have you tried so far? Where are you encountering problems?
Have you visited CPAN and found all the various modules there that deal
with Excel spreadsheets?
> I need it very urgently.............could any body HELP?
Saying you need something "urgently" is generally considered rude. A
failure to plan on your part does not constitute an emergency on anyone
else's part.
Paul Lalli
| |
| Kenneth Tomiak 2006-02-28, 9:55 pm |
| Considering that cgi means running from a web server I forsee a few problems
with what you want to do.
1) The Microsoft Office suite is not likely to be installed on a server, but
if it was you could do something.
2) Windows does not really support file locking so are you sure two people
won't be trying to update it at the same time, nor even the same user
clicking the link twice really fast?
3) Linux does not run the Microsoft Office Suite.
I only know of using a module that directly reads the excel file, you turn
it into the html form they can update, then your next script processes the
form data and uses a module that directly writes an excel format file.
Sounds like you want them to click a link and hope their browser opens the
excel file with a native application on their machine. Are you sure they all
have something that can open excel files? Not everyone has a licensed copy
of the Office suite, nor installed OpenOffice. If your users have, wouldn't
letting them save the file on their machine and then you provide a form with
an upload process suffice? I've toyed with the idea, have used pages that
let me upload files, just haven't done one myself.
"Manoj" <manoj.mitra@gmail.com> wrote in message
news:1138955841.045862.8770@g47g2000cwa.googlegroups.com...
> Hi! All,
>
> I want to open a Microsoft's excel file,(a template - stored in
> server). user will update the excel file - through browser, and on
> clicking save button (will be available on page), the file will get
> saved at server.
>
> I need it very urgently.............could any body HELP?
>
> Thanks in advance
> Mnaoj
>
| |
| Kenneth Tomiak 2006-02-28, 9:55 pm |
| http://www.sitepoint.com/article/up...-files-cgi-perl has an article
about an pload cgi script I am starting to try.
"Manoj" <manoj.mitra@gmail.com> wrote in message
news:1138955841.045862.8770@g47g2000cwa.googlegroups.com...
> Hi! All,
>
> I want to open a Microsoft's excel file,(a template - stored in
> server). user will update the excel file - through browser, and on
> clicking save button (will be available on page), the file will get
> saved at server.
>
> I need it very urgently.............could any body HELP?
>
> Thanks in advance
> Mnaoj
>
|
|
|
|
|