Groups | Search | Server Info | Login | Register

Groups > perl.vmsperl > #4

Re: Excel::Writer on OpenVMS

Show all headers | View raw

> On Oct 29, 2015, at 1:53 PM, Brian Schenkenberger, VAXman- <system@TMESIS.COM> wrote:
> 
> Hi,
> 
> I need to get Excel::Writer functioning on VMS.  If you download the first
> of the example scripts for this package, you'll see that it complains when
> trying to create temporary directories into which worksheets and workbooks
> are stored.

What do those complaints look like?  This, perhaps?

$ 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.

Looks like mongrel syntax to me.  It’s getting a temp file in native syntax, then pasting “/xl” onto it.  I’ll see if I can spot where it’s doing that and what to do about it as this would be a very nice module to have available.

> I've played about with defining various DECC$features logicals and results
> change but the errors all seem to focus about the creation of the temporary
> directories and files.
> 
> Has anyone got this package working on VMS?

I think I might’ve built a previous version once but don’t recall actually using it.

> 
> Thanks in advance. 
> 
> FWIW, I did have Spreadsheet::WriteExcel working to write .XLS files but I
> now need to write .XLSX files and Excel::Writer::XLSX looks to be the only
> package available.
> 
> -- 
> VAXman- A Bored Certified VMS Kernel Mode Hacker    VAXman(at)TMESIS(dot)ORG
> 
> I speak to machines with the voice of humanity.

________________________________________
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 | Next — Previous 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