search for: sheetnam

...NG * checking for code/documentation mismatches ... WARNING whita$ Can anyone suggest a fix to those warnings. My package only has one function in it which has nothing to do with replacement and has no S3 methods. Here it is (from file excelpoi/R/excelpoi.R): write.xls <- function(x,filename,sheetName,writeColNms=T,writeRowNms=T) { if(missing(sheetName) && typeof(x)=="list") sheetName <- NULL .Call("R2xls",x,filename,sheetName,writeColNms,writeRowNms,PACKAGE="excelpoi ") } Thanks in advance, Whit [[alternative HTML version deleted]]

...l, "Visible", TRUE) NULL > > owb <- comGetProperty(oxl, "Workbooks") > > ob <- comInvoke(owb, "Open", xlsfile) > > osheets <- comGetProperty(ob, "Worksheets") > > n <- comGetProperty(osheets, "Count") > > ithSheetName <- function(i) comGetProperty(comGetProperty(osheets, "Item", i), "Name") > > sheetNames <- sapply(1:n, ithSheetName) > > #> sheetNames > # [1] "Platten gesamt" "Platte 1-5" "Platte 6-10" &quot...

Hi Adrian, dat=data.frame(matrix(0,3,3)) write.xlsx(dat,"z:/dat.xlsx",sheetName="sheet1",append=F) write.xlsx(dat,"z:/dat.xlsx",sheetName="sheet2",append=F) The above code works and creates new worksheets. But if I want to append to an existing worksheet I seem to get an error. write.xlsx(dat,"z:/dat.xlsx",sheetName="sheet...

...arge dataset of many countries. I have written the program to run through each country to generate one output for each country. I want to put the output like this: one sheet has output for one country. How do I achieve it by r. I have tried this: library(xlsx) write.xlsx(nnn, "vn.xlsx", sheetName="Sheet1") [1] but when I change sheetName="Sheet2" to add up another country into one sheet. it autimatically deleted which I have down on [1]. index<-unique(dataset$country) for (i in 1:length(index)){ data<-dataset[dataset$country==index[i],] (...) output<-dd #t...

Dear All, I am using WriteXLS to write tables with multiple sheets with the command: WriteXLS("tables", ExcelFileName = fileName, SheetNames = tableList, perl = "perl", verbose = FALSE, Encoding = c("UTF-8", "latin1"), row.names = TRUE, col.names = TRUE, AdjWidth = TRUE, AutoFilter = FALSE, BoldHeaderRow = FALSE, FreezeRow = 0, FreezeCol = 0, envir =...

...Author(s): Marc Schwartz <marc_schwartz at me.com> Maintainer: Marc Schwartz <marc_schwartz at me.com> License: GPL (>=2) Changes since version 1.6.0: 1. Added \'verbose\' argument to testPerl so that it can be used in an if() manner without console output 2. Added \'SheetNames\' argument to WriteXLS to enable user specified worksheet names 3. Added various checks to code for unique worksheet names, worksheet names <= 31 chars, length(SheetNames) == length(x) 4. Added check for invalid worksheet names for chars []:*?/\\ 5. Added argument \'--SN\' to Wr...

...Author(s): Marc Schwartz <marc_schwartz at me.com> Maintainer: Marc Schwartz <marc_schwartz at me.com> License: GPL (>=2) Changes since version 1.6.0: 1. Added \'verbose\' argument to testPerl so that it can be used in an if() manner without console output 2. Added \'SheetNames\' argument to WriteXLS to enable user specified worksheet names 3. Added various checks to code for unique worksheet names, worksheet names <= 31 chars, length(SheetNames) == length(x) 4. Added check for invalid worksheet names for chars []:*?/\\ 5. Added argument \'--SN\' to Wr...

We need to keep the discussion on the list. When I run your code, there are several problems. strain.data <- read.xlsx("Dee rhiz.xlsx", sheetName ="strain", header = T, row.names = 1) str(strain.data) # lists 9 columns at the end with all NAs strain.data1 <- (strain.data, sqrt.dist = TRUE) # this is not a valid R line. I get Error: unexpected ',' in "strain.data1 <- (strain.data," strain.cca1 <- cca(...

Hello Sir I am getting problem in plotting in CCA . Could you please help me? I wrote the below command but I don't know why it is taking only first 5 env data rather than all 9. > strain.data <- read.xlsx("Dee rhiz.xlsx", sheetName="strain", header = T, row.names = 1) > env.data <- read.xlsx("Dee rhiz.xlsx", sheetName="env", header = T, row.names = 1) > strain.cca <- cca(strain.data ~ Ph+TotalN+Organicmatter+Ca+K+Na+P+Cu+Mn, data=env.data) > strain.cca Call: cca(formula = strain.d...

Dear list, I have some .xls files that I need to read into R. I am able to do so using read.xls in the gdata package, however the helper functions sheetNames and sheetCount fail. This is the error: Unable to open file '~/SharedFolder/MyData/mydata.xls'. Warning: running command ''/usr/bin/perl' '/usr/local/lib/R/site-library/gdata/perl/sheetCount.pl' '~/SharedFolder/MyData/mydata.xls'' had status 2 Googling I...

...: RcallMethod: invalid object parameter > res <- read.xlsx("C:/Users/FELIPE PARRA/Documents/Quantil/Federacion/Curva LIBOR.xlsx", 4) Error en .jcall(rowCells[[ic]], "I", "getColumnIndex") : RcallMethod: invalid object parameter > res <- read.xlsx(file, sheetName="LIBORSWAP") Error en .jcall(rowCells[[ic]], "I", "getColumnIndex") : RcallMethod: invalid object parameter does anybody knows what does this error means? Or do you have nay idea what is a good way of importing big EXCEL files to R. Thank you Felipe Parra

...e. This works fine for small test files ? e.g. suppose I?m trying to read from the test_file workbook on my desktop. The following code extracts rows 1 and 2 from worksheet = ?johnny?. setwd("C:\\Documents and Settings\\dmenezes\\Desktop") info<- read.xlsx("test_file.xlsx",sheetName="johnny",rowIndex=1:2,header=FALSE) info However, when I try to apply this to my real, large workbook, things go wrong, with the following error message. Any ideas/workarounds? Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, : j...

Hallo all, I`ve read a lot of things in this forum about an Excel export via R. It is no problem to export my data frames via write.table or write.xls (xls or csv), but some things are not very convenient for me: I always have to adjust the column with to see all the numbers or the text and there is no frame between the cells. And I missing the possibility to make some headers bold or coloured.

...e "ERROR: cannot open $FileName. $!\n"; # Create new sheet with filename prefix # ($base, $dir, $ext) = fileparse ($FileName, '..*'); my $FName = (fileparse ($FileName, '\..*'))[0]; # Only take the first 31 chars, which is the # limit for a worksheet name my $SheetName = substr($FName, 0, 31); print "Creating New WorkSheet: $SheetName\n\n"; my $WorkSheet = $XLSFile->add_worksheet($SheetName); # Rows and columns are zero indexed my $Row = 0; # Write to Sheet while (<CSVFILE>) { if ($csv->parse($_)) { my @Fields = $...

...e that WorkbookBig.pm is no longer required and is therefore removed from the packaged Perl modules. 5. Fixed the underscores "_" in testPerl.Rd 6. Added check of the data frames for rows > 65536 and columns > 256. 7. Temporary CSV file names are now (1:number of data frames).csv 6. SheetNames are now always written to temporary file SheetNames.txt, so the '--SN' argument is deleted from the Perl script The major user visible functional change is number 2, such that the name of a list can now be specified, where the list contains one or more data frames. An example of this us...

...e that WorkbookBig.pm is no longer required and is therefore removed from the packaged Perl modules. 5. Fixed the underscores "_" in testPerl.Rd 6. Added check of the data frames for rows > 65536 and columns > 256. 7. Temporary CSV file names are now (1:number of data frames).csv 6. SheetNames are now always written to temporary file SheetNames.txt, so the '--SN' argument is deleted from the Perl script The major user visible functional change is number 2, such that the name of a list can now be specified, where the list contains one or more data frames. An example of this us...

...e.path(path.package('gdata'),'xls','madrid.xls') df = read.xls (xlsfile) df = read.xls (xlsfile, sheet = 1, header = TRUE) df = read.xls ("madrid.xls", sheet = 1, header = TRUE) df = read.xls ("madrid.xls") require(xlsx) read.xlsx("madrid.xls", sheetName = "Sheet1") library(XLConnect) wk = loadWorkbook("madrid.xls") df = readWorksheet(wk, sheet="Sheet1") -- también he probado directamente read.table ya que el fichero es tipo xml por dentro: df = read.table("madrid.xls", header = TRUE) -- ejemplo del fic...

Hai, I'm trying to write these var output data from these codes inside excel file. My directory to store the data is /D:\FYP\image / but receive an error message : /Error in write.xls(mydata, "D:\\FYP\\image.mydata.xls") : object 'mydata' not found/ these are my codes, can you help give an advice or idea with my problem: /library("biOps")

Hi, I would like to some excel files with some worksheets. I tried this with the following R script: library(gdata) i<-1 rc<-0 while(rc != "try-error") { wksh<-try(read.xls("cluster-microarray-FW.xls",sheet=i,verbose=TRUE,perl="perl")) rc<-class(wksh) print(sprintf("------- i=%2d rc=%s ---------------",i,rc)) if (rc !=

Thank you so much Rui. 1. How do I export this table to excel file? I used this tbl1 <- table(Country, IDNum) tbl2=addmargins(tbl1) write.xlsx(tbl2,"tt1.xlsx"),sheetName="summary", row.names=FALSE) The above did not give me that table. 2. I want select those unique Ids that do have records in all countries. From the above data set, this ID "FIN1540166" should be excluded from the summary table and the table looks like as follow...