Hi,
Thank you.
I will work on an update to the package that includes Archive::Zip so that it
covers this situation.
Regards.
Marc
On Jul 25, 2013, at 10:30 AM, Orvalho Augusto <orvaq...@gmail.com> wrote:
> 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.
______________________________________________
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.
