search for: writeexcel

...to ALL worksheets created in the XLS file. Please note that after researching the potential for being able to append new worksheets to an existing XLS file, this does not appear to be a robust option via Perl. The combination of the required Perl packages Spreadsheet::ParseExcel and Spreadsheet::WriteExcel does not support the preservation of many pre-existing worksheet objects as noted in: http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.37/lib/Spreadsheet/WriteExcel.pm#MODIFYING_AND_REWRITING_EXCEL_FILES These include embedded graphics, cell formulae, macros, etc. which would be lost du...

...to ALL worksheets created in the XLS file. Please note that after researching the potential for being able to append new worksheets to an existing XLS file, this does not appear to be a robust option via Perl. The combination of the required Perl packages Spreadsheet::ParseExcel and Spreadsheet::WriteExcel does not support the preservation of many pre-existing worksheet objects as noted in: http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.37/lib/Spreadsheet/WriteExcel.pm#MODIFYING_AND_REWRITING_EXCEL_FILES These include embedded graphics, cell formulae, macros, etc. which would be lost du...

.... Note of course that Excel has certain (version specific) limitations with respect to file formats. I list the MS link below for Excel 2007. Similar specs are available for earlier versions: http://office.microsoft.com/en-us/excel/HP100738491033.aspx Finally, note that I use 'Spreadsheet::WriteExcel::Big', as the regular version of the Perl package has a constraint where the ENTIRE Excel file cannot be larger than 7 Mb, which was a problem for my application. Here is the Perl code: #!/usr/bin/perl -w use strict; use Spreadsheet::WriteExcel::Big; use Getopt::Long; use File::Glob; use F...

Hi all: I wanna know how to expoort ".xls" file. And in the exported ".xls" file, how to set different cells with different color? Thanks a lot! My best. ------------------------------ ******************************************* Xin Meng Capitalbio Corporation National Engineering Research Center for Beijing Biochip Technology BioPharma-informatics & Software

Hello, Thanks in advance for reading. I''m attempting to export data to an excel spreadsheet, and have done so successfully using RubySpreadsheet ( http://sourceforge.net/projects/rubyspreadsheet/ ) which is a port of the Perl WriteExcel module... Many of the methods however were left out, one of them being "insert_bitmap" and unfortunatley the bitmap is an important part of the export. Does anyone know how this can be done, and/or is anyone adventurous enough to help me update the RubySpreadsheet so it can accept im...

...it contains. The package requires that Perl and several specific Perl modules are installed in order to function. These modules, which may already be installed on systems with Perl installed, include: OLE::Storage_Lite Parse::RecDescent Getopt::Long File::Basename Spreadsheet::WriteExcel Encode File::Glob Text::CSV_XS With the exception of the last three modules listed, for convenience all are included in the CRAN package and will be made available by adding the installed package path for these modules to the Perl @INC array. The last three modules (Encode, File::...

Maybe this helps, too. readExcel <- function(row.names = 1, check.names = FALSE, ...) read.delim("clipboard", row.names = row.names, check.names = check.names, ...) writeExcel <- function(x, check.rows = FALSE, check.names = FALSE, ...){ df <- data.frame(x, check.rows = check.rows, check.names = check.names) write.table(df, "clipboard", sep = "\t", col.names = NA, ...) } Best regards, Stefan -----------------------------------------------...

...it contains. The package requires that Perl and several specific Perl modules are installed in order to function. These modules, which may already be installed on systems with Perl installed, include: OLE::Storage_Lite Parse::RecDescent Getopt::Long File::Basename Spreadsheet::WriteExcel Encode File::Glob Text::CSV_XS With the exception of the last three modules listed, for convenience all are included in the CRAN package and will be made available by adding the installed package path for these modules to the Perl @INC array. The last three modules (Encode, File::...

Hans-Peter and other R developers, How are you? Have you made any progess with embedding Url's in Excel? Well, I have been busy thinking of more things for you to do;) My colleagues in the lab are not R literate, and some are barely computer literate, so I give them everything in Excel workbooks. I have gradually evolved a system such that these workbooks have become compendia of my

Your surest bet is to look into S+, not R, since the former does 'integrate' with Microsoft applications. To what extent, I don' know. This is a desirable feature (IMO) and a reason to use S+ rather then R (already discussed in different thread). Try the S+ newsgroup. > -----Original Message----- > From: r-help-bounces at stat.math.ethz.ch > [mailto:r-help-bounces at

..."End of Month" for computer systems this may be important for # extra processing and what not. # # You may need to set yout TZ environment variable if the script cannot # determine your time zone from the system (e.g. SET TZ=CST ) ###### use Getopt::Long; use Date::Manip; use Spreadsheet::WriteExcel; use Calendar::Functions; use Date::Holidays::USFederal; use Set::Array; use POSIX qw/strftime/; use Time::Local; my @regressors = (); #my $holidays = Date::Holidays->new(countrycode => 'us'); $result = GetOptions ("start|s=s" => \$start, "end|e=s" => \$...

...uot;End of Month" for computer systems this may be important for # extra processing and what not. # # You may need to set yout TZ environment variable if the script cannot # determine your time zone from the system (e.g. SET TZ=CST ) ###### use Getopt::Long; use Date::Manip; use Spreadsheet::WriteExcel; use Calendar::Functions; use Date::Holidays::USFederal; #use Date::Holidays; use Set::Array; use POSIX qw/strftime/; use Time::Local; my @regressors = (); #my $holidays = Date::Holidays->new(countrycode => 'us'); $result = GetOptions ("start|s=s" => \$start, "e...

Dear all, I am interested in reading Excel spreadsheets (*.xls) directly into R (I am using version 1.1.1 at the moment). I have not had much luck so far. For the time being, I have been converting Excel files to comma delimited files (*.csv) and reading these into R (using commands such as "read.csv"). This works well, but it would be more efficient if I could read the Excel files

I've been a big fan of CentOS for a while, and didn't have many issues with CentOS 4.X over the past few years. However, since moving to CentOS 5.1 a few weeks ago, I have received more problem reports from my users than in the last year and a half on CentOS 4.X. I've previously reported the problem with gnome-terminal crashing (and since there is a single gnome-terminal

Dear members of the R Development Team, I am looking for people with a deep understanding of R internals to assist in bridging R to OpenOffice. While R is a state of the art statistical environment, less experienced users often find it difficult to work with R. Therefore, I believe that a bridge between R and a spreadsheet program will make this transition less painful. I sincerely believe

r-help, Is there a package available for R which allows you to export data directly to .xls, much like exportData(foo,"foo.xls","EXCEL") in S-PLUS ? If not, is anyone working on this, or thinking about working on this? I apologise in advance if this question has already been answered. Many thanks, Matthew

I have a two part question one about statistical theory and the other about implementations in R. Thank you for all help in advance. (1) Am I correct in understanding that Heteroscedasticity is a problem for Generalized Additive Models as it is for standard linear models? I am asking particularly about the GAMs as implemented in the mgcv package. Based upon my online search it seems that some