Re: Excel::Writer on OpenVMS

"Craig A. Berry" <[email protected]> Thu, 29 Oct 2015 14:40:47 -0500
Newsgroups gmane.comp.lang.perl.ports.vms
Message-ID <[email protected]>
> On Oct 29, 2015, at 1:53 PM, Brian Schenkenberger, VAXman- =
<[email protected]> wrote:
>=20
> Hi,
>=20
> 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=E2=80=99s getting a temp file in =
native syntax, then pasting =E2=80=9C/xl=E2=80=9D onto it.  I=E2=80=99ll =
see if I can spot where it=E2=80=99s 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.
>=20
> Has anyone got this package working on VMS?

I think I might=E2=80=99ve built a previous version once but don=E2=80=99t=
 recall actually using it.

>=20
> Thanks in advance.=20
>=20
> 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.
>=20
> --=20
> VAXman- A Bored Certified VMS Kernel Mode Hacker    =
VAXman(at)TMESIS(dot)ORG
>=20
> I speak to machines with the voice of humanity.

________________________________________
Craig A. Berry
mailto:[email protected]

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