If, as you seem to be implying, centos precludes Excel (I've heard of centos vaguely but don't know what it is or does), then you can't run Excel macros anyway, so why would you worry about them being removed? If you want to run Excel macros, you need a copy of Excel (and that includes user-defined functions, which are a species of macro). If you have that, you can do what you like with Win32::OLE, but not with Spreadsheet::whatever. If you are generating Excel files for other people and want to save macros, you must have Excel, which you can automate with Win32::OLE. Either that, or write your own module to save Excel files with macros. You will have to understand the Excel file format extremely well and have quite a bit of time. I have discussed this with John McNamara, but I don't know enough Perl and, like him, am working on other projects. It's not impossible, but it's likely to be far easier to get yourself a dual boot system with Excel. Another option is one I have used in several places. Get hold of a gash machine that's going to the skip and, provided it has Losedows on it, commandeer it. Put Excel on if it's not already there, plus Perl. Then use that machine for stuff you need Excel to do and your main machine for everything else. If space is tight, get a KVM switch so you can put the gash machine on the floor & use the same peripherals.

Regards,

John Davies

In reply to Re^3: Problem Writing macros in an Excel File by davies
in thread Problem Writing macros in an Excel File by Striker

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • 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:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.