Re: XLSX tmp file error

You can change the default temp dir that Excel::Writer::XLSX uses via the set_tempdir() method.

--
John.

Comment on Re: XLSX tmp file error

Replies are listed 'Best First'.
Re^2: XLSX tmp file error by vishi83 (Pilgrim) on Mar 05, 2012 at 17:08 UTC
Hi John, Glad to hear from you! I tried with 0.46 version of XLSX module.. But after setting the tmp dir in this way, `workbook->set_tempdir('/opt/apache/secure-htdocs/exceldir/');` [download] I still see this error, `Couldn't create sub directory /opt/apache/secure-htdocs/exceldir/CQ2RN +O0V36/xl/worksheets: Permission denied at /opt/perl-5.8.3/lib/site_pe +rl/5.8.3/Excel/Writer/XLSX/Workbook.pm line 809` [download] I've given 777 permissions to the exceldir folder with ownership belonging to the web user..	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^2: XLSX tmp file error
by vishi83 (Pilgrim) on Mar 05, 2012 at 17:08 UTC

workbook->set_tempdir('/opt/apache/secure-htdocs/exceldir/');
[download]

Couldn't create sub directory /opt/apache/secure-htdocs/exceldir/CQ2RN
+O0V36/xl/worksheets: Permission denied at /opt/perl-5.8.3/lib/site_pe
+rl/5.8.3/Excel/Writer/XLSX/Workbook.pm line 809
[download]

[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom