Groups | Search | Server Info | Keyboard shortcuts | Login | Register


Groups > perl.vmsperl > #3

Re: Excel::Writer on OpenVMS

Newsgroups perl.vmsperl
Subject Re: Excel::Writer on OpenVMS
Date 2015-10-29 14:58 -0500
Message-ID <7593FF06-3BAB-4184-9DFC-487A4DF0C5D2@me.com> (permalink)
References <00AFF5E2.09AEECCB.9@TMESIS.COM> <615DF848-CE0D-4DC8-9CE2-3C10A54E0659@me.com>
From craigberry@me.com ("Craig A. Berry")

Show all headers | View raw


> On Oct 29, 2015, at 2:40 PM, Craig A. Berry <craigberry@me.com> wrote:
> 
> 
> $ perl -"I[.blib.lib]" examples/array_formula.pl
> 	(in cleanup) Couldn't create sub directory mda0:[craig.scratch.QHki3CLXLC]/xl: no such file or directory at blib/lib/Excel/Writer/XLSX/Workboo
> k.pm line 957.
> 

The fix for that is simple:

$ gdiff -pu lib/Excel/Writer/XLSX/Workbook.pm;-0 lib/Excel/Writer/XLSX/Workbook.pm
--- lib/Excel/Writer/XLSX/Workbook.pm;-0	2015-10-29 14:09:16 -0500
+++ lib/Excel/Writer/XLSX/Workbook.pm	2015-10-29 14:47:56 -0500
@@ -918,6 +918,8 @@ sub _store_workbook {
     my $packager = Excel::Writer::XLSX::Package::Packager->new();
     my $zip      = Archive::Zip->new();

+    # We'll be appending Unix-style paths onto this.
+    $tempdir    = VMS::Filespec::unixpath($tempdir) if $^O eq 'VMS';

     # Add a default worksheet if non have been added.
     $self->add_worksheet() if not @{ $self->{_worksheets} };
[end]

Now it runs but creates empty files.  I’ll have to look into that sometime but have to get back to real work at the moment.

________________________________________
Craig A. Berry
mailto:craigberry@mac.com

"... getting out of a sonnet is much more
 difficult than getting in."
                 Brad Leithauser

Back to perl.vmsperl | Previous | NextPrevious in thread | Next in thread | Find similar


Thread

Excel::Writer on OpenVMS system@TMESIS.COM ("Brian Schenkenberger, VAXman-") - 2015-10-29 14:53 -0400
  Re: Excel::Writer on OpenVMS craigberry@me.com ("Craig A. Berry") - 2015-10-29 18:44 -0500
    Re: Excel::Writer on OpenVMS craigberry@mac.com ("Craig A. Berry") - 2015-10-30 09:43 -0500
      Re: Excel::Writer on OpenVMS craigberry@mac.com ("Craig A. Berry") - 2015-10-30 15:59 -0500
        RE: Excel::Writer on OpenVMS friedberg@exs.esb.com (Carl Friedberg) - 2015-10-30 21:04 +0000
          Re: Excel::Writer on OpenVMS VAXman@tmesis.com (Brian Schenkenberger) - 2015-11-02 12:09 -0500
  Re: Excel::Writer on OpenVMS craigberry@me.com ("Craig A. Berry") - 2015-10-29 14:58 -0500
  Re: Excel::Writer on OpenVMS craigberry@me.com ("Craig A. Berry") - 2015-10-29 14:40 -0500

csiph-web