ktperl has asked for the wisdom of the Perl Monks concerning the following question:

I want to copy the format of one spreadsheet to another spreadsheet. My source worksheet has both data and charts(3 of them). My perl code is able to copy both data and chart but the formatting is lost. please help with some suggestions. thnks.

Replies are listed 'Best First'.
Re: copying format
by dragonchild (Archbishop) on Jan 18, 2005 at 20:11 UTC
    If you showed the important bits from your Perl code, we might be able to help add the missing piece(s) ...

    Being right, does not endow the right to be rude; politeness costs nothing.
    Being unknowing, is not the same as being stupid.
    Expressing a contrary opinion, whether to the individual or the group, is more often a sign of deeper thought than of cantankerous belligerence.
    Do not mistake your goals as the only goals; your opinion as the only opinion; your confidence as correctness. Saying you know better is not the same as explaining you know better.

Re: copying format
by sasikumar (Monk) on Jan 19, 2005 at 07:21 UTC


    Use the Binary mode of copying files.

    As dragonchild says please provide us with ur work so that we could help you out.

    Thanks
    SasiKumar