similar to: Changing font of a certrain column in an excel file

Hi all! While I am trying to read .cel files with oligo package: afbatch=read.celfiles(list.celfiles()) I get an error: Package 'pd.mirna.1.0.2xgain' was not found in the BioConductor repository How can I overcome this? Thank you in advance

I''ve successfully installed ferret and acts_as_ferret and have no problem with utf-8 for accented characters. It returns correct results fot e.g. fran?ais. My problem is with non latin characters (Persian indeed). I have tested different locales with no success both on Debian and Mac. Any idea? (ferret 0.11.4, acts_as_ferret 0.4.0, rails 1.1.6) -- Posted via http://www.ruby-forum.com/.

Dear R Helpers, I want to localize my plots, i.e. the numbers by x & y axis be Persian, using Persian numerals and Persian decimal separator. I change the locale to fa_IR.utf8, but nothing on plots change. I can change the numerals shaping to Persian ones (???? instead of 1234) using some non-standard fonts but the decimal point is a problem. I asked about that in Persian-Computing mailing

R-Help Trying to convert a Gregorian calendar dataset to a Persian calendar dataset. But I end up with a list and not sure what to do. For example ... dates <- c("2017-10-1","2017-10-2","2017-10-3") myData <- data.frame(dates) myData$dates <- as.Date(myData$dates, format = "%Y-%m-%d") > myData dates 1 2017-10-01 2 2017-10-02 3

I have categories and sub-categories in a table called "categories". Every row has a "parent" field to note if the entry is the sub-category of another (never goes deeper than 1 level). So there might be something like this: id | name | parent 1 Dog 0 2 Pug 1 3 Siamese 5 4 Shih Tzu 1 5 Cat 0 6 Wiener Dog 1 7 Persian

Hi, I have a R script file with Persian letters in it defined as a variable: #' @export letters_fa <- c('???','?','?','?','?','?','?','?','?','?','?','?') I have specified the encoding field in my DESCRIPTION file of my package. ... Encoding: UTF-8 ... I also included

Hello R community, I basically created a normal distribution with mean 2500 and standard deviation = 450 with a sample of size 50 and assigned that to a variable named genvar2 with the following command: genvar2<-rnorm(mean=2500, sd=450, n=50) Now, the output of genvar2 generates de following: [1] 2478.126 2671.259 2163.879 2440.796 2702.234 1871.514 2525.127 2830.688 [9] 2704.148 3464.478

How about > p_dates <- paste0(p.dates[[3]], "-", p.dates[[2]], "-", p.dates[[1]]) > myData$p_dates <- p_dates > print(myData, right=FALSE) dates p_dates 1 2017-10-01 1396-7-9 2 2017-10-02 1396-7-10 3 2017-10-03 1396-7-11 > str(myData) 'data.frame': 3 obs. of 2 variables: $ dates : Date, format: "2017-10-01"

Dear Rxperts, Through Windows OS, I created shortcuts (paste as shortcut) to excel spreadsheets ( with "xlsx" as the file extension). I wasn't able to read the shortcuts through R and using "read" functions of "xlsx" package. exf <- "a1.xlsx.lnk" > read.xlsx(exf,1) Error in .jcall("RJavaTools", "Ljava/lang/Object;",

i am unable to open a file which is saved as .xlsx format in R . The file contains approximately 1,50,000 rows. So I m not able to save it as csv file.Please suggest ways to open this file -- View this message in context: http://n4.nabble.com/how-to-open-excel-2007-xlsx-file-in-R-tp1017273p1017273.html Sent from the R help mailing list archive at Nabble.com.

Hi, I need some help to export a data frame with 83 rows and 1411 colums. I have used the package RODBC until now. But now, I have 1411 colums that I can't send to the old excel. If anybody knows a package to convert my data frame in xlsx tell me! Thanks for help in advance! Pamela Botrel -- View this message in context:

Hello, speexers. I'm new to the list and new to audio compression. I've been asked to look into creating a digital archive of 20-minute speeches (sermons) and speex seems to be what I need. My experience is in image compression; I shepherded gzip, deflate, zlib, and png through the IETF process, put "image/png" through the IANA registration process, and I maintain several

HI, I have large 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"

I?ve got an Excel workbook with about 30 worksheets. Each worksheet has 10000 rows of data over 30 columns. I?d like to read the data from each worksheet into a dataframe or matrix in R for processing. Normally, I use read.csv when interacting with Excel but I?d rather manipulate a multisheet workbook directly than set about splitting the original workbook and saving down each part as a csv.

Hi List, just to know if the issue is only a problem of mine or if it is a general issue due to the new MS Office pack. I'm using R 2.11.1 32 bits in a Windows 7 x64 with the MS office 2010 x64 installed. I can import .xls files normally (the same way I did with my Excel 2007 32 bits). But the function odbcConnectExcel2007 isn't able to import .xlsx files now that I have the new version of

Dear group, I am working on a rather big project where the output data frames have dimensions of 3000 x 15 or greater. We are using xlsx and xlsx2 to write the data.frames to Excel sheets. Since recently we get the following error, when trying to write the data frames to the excel sheets: Error in ls(envir = envir, all.names = private) : invalid 'envir' argument We figured out that

I have several hundred Excel 2007 data files in a folder. I would like to read every file in a single given folder using a loop. I have searched the FAQ, the forum archives here, other or older R boards and the R Import / Export documentation, and have asked some very knowledgeable R users without learning of a solution. I hope someone here can help. I understand that the most common

Hi to all. I have a problem to connect to an Excel database using RODBC. Namely, I am using 64-bit R 2.14.0, under Windows 7 and I tried following: library(RODBC) > channel <- odbcConnectExcel("results.xlsx") Error in odbcConnectExcel("results.xlsx") : odbcConnectExcel is only usable with 32-bit Windows # ok this is clear why it doesn't work > channel

Hello again, I'd like to determine if an Excel file is open or writable. Can anyone help me with that? I write some stats to an .xlsx Excel file using the xlsx package. I can't write to the file unless its closed. How do I determine if the .xlsx file is open or closed so I can write to it? I've looked at file.info and file.access and I couldn't get those to work for me. Any

Hello I am trying to import an Excel file but I am loosing the headers, My headers are in the first to rows of the EXCEL file. In the following R output, the NA are supposed to be the second item in the Header. Is there any way to Import more than one row as headers?. Thank you Felipe Parra > Data<-odbcConnectExcel('Curva LIBOR.xlsx',readOnly=T,) >