comment on

Ya, i tried to patch this up in Formula.pm. It works for xlsx by just adding a Function (say PLSFUNCT) of desired name in Formula.pm hash list of functions. But this approach fails for xls writing.

I m able to achive the required in xlsx format but since the server has old version of perl 5.6.0 so xlsx not supported. I, somehow, need to achieve this for xls format

I am able to add function using Spreadsheet::WriteExcelXML but in the end its a XML spreadsheet not a proper xls format.

Requirement is some how to do this in perl 5.6.0. And produce Excel file should me able to support macros (i.e. no XML Spreadsheet).

I m trying to make this Excel::XLSX module (minimum perl 5.10) to work with this version of perl 5.6 but still lots of Headaches (realy messi).

In reply to Re: How to write Excel Addin functions!! by haxman
in thread How to write Excel Addin functions!! by haxman

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


There's more than one way to do things
	PerlMonks