Thank you for the feedback.
I installed the missing Archive::Zip packge and everthing went fine.
Orvalho
On Thu, Jul 25, 2013 at 3:00 PM, Marc Schwartz <marc_schwa...@me.com> wrote:
> Hi,
>
> Perl is still required for WriteXLS. That dependency has not changed.
>
> What did change is that I removed the requirement for Text::CSV_XS, which
> contains C code in the Perl package source that required compilation and
> therefore could not be included in the WriteXLS CRAN package. The
> compilation process to create the binary is OS and Perl version specific.
> Thus, if not already installed, WriteXLS users would either have to install
> a pre-compiled binary using their Perl or OS package manager or via the CLI
> using 'cpan' and compile during local installation, which requires that
> compiler related tools also be installed, making it a bit more cumbersome.
>
> I can now include Text::CSV_PP, which is recently stable enough to use and
> is a Perl only implementation of the CSV file parsing functionality found
> in Text::CSV_XS.
>
> The output below suggests that you have Perl version 5.14 installed but
> that you may be missing Archive::Zip, which based upon my prior research is
> typically installed with most recent Perl distributions. Thus, I did not
> include it in the WriteXLS CRAN package nor do I check for it in
> testPerl(). Archive::Zip is a dependency for Excel::Writer::XLSX, which
> creates the XLSX files in WriteXLS().
>
> Can you run testPerl() from the WriteXLS package and post back the output
> and also let me know what OS you are running? I presume some Linux
> distribution, albeit feedback from others using the new version of WriteXLS
> on Linux, OSX and Windows have not indicated that Archive::Zip is missing.
>
> I may then need to update WriteXLS to include Archive::Zip if there are
> some Perl installations that do not include it.
>
> Thanks,
>
> Marc
>
>
> On Jul 24, 2013, at 11:24 PM, Orvalho Augusto <orvaq...@gmail.com> wrote:
>
> > Hello!
> >
> > None can imagine how this package is helpful for me. I might have
> > understood wrong... is it correct that WriteXLS doesn't no more require
> > Perl?
> >
> > It is because I got this on my machine:
> >> WriteXLS("iris", "iriscomments.xlsx", AdjWidth = TRUE, BoldHeaderRow
> > = TRUE)
> > Can't locate Archive/Zip.pm in @INC (@INC contains:
> > /usr/local/lib/R/site-library/WriteXLS/Perl /etc/perl
> > /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5
> > /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14
> > /usr/local/lib/site_perl .) at
> > /usr/local/lib/R/site-library/WriteXLS/Perl/Excel/Writer/XLSX/Workbook.pm
> > line 25.
> > BEGIN failed--compilation aborted at
> > /usr/local/lib/R/site-library/WriteXLS/Perl/Excel/Writer/XLSX/Workbook.pm
> > line 25.
> > Compilation failed in require at
> > /usr/local/lib/R/site-library/WriteXLS/Perl/Excel/Writer/XLSX.pm line 18.
> > BEGIN failed--compilation aborted at
> > /usr/local/lib/R/site-library/WriteXLS/Perl/Excel/Writer/XLSX.pm line 18.
> > Compilation failed in require at
> > /usr/local/lib/R/site-library/WriteXLS/Perl/WriteXLSX.pl line 35.
> > BEGIN failed--compilation aborted at
> > /usr/local/lib/R/site-library/WriteXLS/Perl/WriteXLSX.pl line 35.
> > The Perl script 'WriteXLSX.pl' failed to run successfully.
> >
> > Thank you
> > Caveman
> >
> >
> >
> > On Wed, Jul 24, 2013 at 2:27 PM, Marc Schwartz <marc_schwa...@me.com>
> wrote:
> >
> >> On Jul 23, 2013, at 5:40 PM, cognizio <ge...@uyleman.com> wrote:
> >>
> >>> Great summary! It works great without the heavy PERL library. I am
> >> running
> >>> the YAML package I thought I needed to support WRITEXLS. Do I need it
> or
> >> is
> >>> YAML not a dependency?
> >>>
> >>> Other question is on your last point: 'WRITEXLS COMMENT:' now shows up
> >>> across the first row of the data output in the XLS. How do I modify
> these
> >>> values?
> >>>
> >>> Thx!
> >>>
> >>> Cog
> >>
> >>
> >> Hi,
> >>
> >> There is no direct dependency on YAML.
> >>
> >> The comments that appear in the first row in Excel are based upon the
> use
> >> of the ?comment function, which adds a 'comment' attribute to the
> columns
> >> of the data frame. If that attribute is present on one or more columns,
> an
> >> Excel comment will be created for the columns that have it.
> >>
> >> There is an example of this in ?WriteXLS:
> >>
> >> # Example using comment()
> >> # Commented cells with have a small red triangle in the
> >> # upper right hand corner of the cell. Click on the cell
> >> # or place the cursor over the cell to see the pop-up
> >> # containing the comment text.
> >> # Create an XLSX (Excel 2007) file
> >> # Adjust the column widths
> >> # Bold the header row
> >> comment(iris$Sepal.Length) <- "Length of the sepals (cm)"
> >> comment(iris$Sepal.Width) <- "Width of the sepals (cm)"
> >> comment(iris$Petal.Length) <- "Length of the petals (cm)"
> >> comment(iris$Petal.Width) <- "Width of the petals (cm)"
> >> comment(iris$Species) <- "Species of the flowers"
> >> WriteXLS("iris", "iriscomments.xlsx", AdjWidth = TRUE, BoldHeaderRow
> =
> >> TRUE)
> >>
> >>
> >> The 'comment' attribute is not seen when printing the data frame, but
> can
> >> be seen when using ?str to print the structure of the data frame:
> >>
> >>> str(iris)
> >> 'data.frame': 150 obs. of 5 variables:
> >> $ Sepal.Length: atomic 5.1 4.9 4.7 4.6 5 5.4 4.6 5 4.4 4.9 ...
> >> ..- attr(*, "comment")= chr "Length of the sepals (cm)"
> >> $ Sepal.Width : atomic 3.5 3 3.2 3.1 3.6 3.9 3.4 3.4 2.9 3.1 ...
> >> ..- attr(*, "comment")= chr "Width of the sepals (cm)"
> >> $ Petal.Length: atomic 1.4 1.4 1.3 1.5 1.4 1.7 1.4 1.5 1.4 1.5 ...
> >> ..- attr(*, "comment")= chr "Length of the petals (cm)"
> >> $ Petal.Width : atomic 0.2 0.2 0.2 0.2 0.2 0.4 0.3 0.2 0.2 0.1 ...
> >> ..- attr(*, "comment")= chr "Width of the petals (cm)"
> >> $ Species : Factor w/ 3 levels "setosa","versicolor",..: 1 1 1 1 1 1
> >> 1 1 1 1 ...
> >> ..- attr(*, "comment")= chr "Species of the flowers"
> >>
> >>
> >>
> >> Regards,
> >>
> >> Marc Schwartz
>
>
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
