Don't think about opening the excel file in the server side.
I'm not going to say that is impossible to control the client, because there are many security holes, but I'm going to say that is not easy, and is not secure (maybe you find that your code doesn't work tomorrow)
Try instaling this modules in the server (if you use ActivePerl, is very easy with ppm)
Spreadsheet-ParseExcel
Spreadsheet-ParseExcel_XLHTML
Spreadsheet-ParseExcel-Simple
Spreadsheet-WriteExcel
Spreadsheet-WriteExcel-FromDB
Spreadsheet-WriteExcel-Simple
I have used Spreadsheet-ParseExcel and is easy to make what you want.
With the first three, you can parse xls archives.
With the last three, you can write xls archives (and then you can send them to the browser)
Hopes
$_=$,=q,\,@4O,,s,^$,$\,,s,s,^,b9,s,
$_^=q,$\^-]!,,print
Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
Read Where should I post X? if you're not absolutely sure you're posting in the right place.
Please read these before you post! —
Posts may use any of the Perl Monks Approved HTML tags:
- a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
| |
For: |
|
Use: |
| & | | & |
| < | | < |
| > | | > |
| [ | | [ |
| ] | | ] |
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.