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

Displaying 20 results from an estimated 1915 matches similar to: "Changing font of a certrain column in an excel file"

2018 Mar 21
1
Package 'pd.mirna.1.0.2xgain' was not found in the BioConductor repository
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
2009 Apr 27
1
MDL - Fayyad & Irani Discretization
Hey, I''m looking for a function which provides a supervised Fayyad & Irani discretization (MDL). I''ve already found RWeka which has such a function. But is there anything else? I''d prefer to use sth lighter in my own package. Regards, Peter
2013 Sep 26
3
Read shortcuts of MS Excel files through R
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",
2010 Jul 13
2
RODBC and Excel 2010 xlsx
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
2017 Sep 23
1
"XLConnect" packages; Excel dates read incorrectly
Hi, I tried to read xlsx files by "XLConnect" packages, but the dates are one day earlier than it is supposed to be. I moved from California to Taiwan (Eastern Asia), and it worked well in California, but not in Taiwan. Even if I adjust my Mac time to California time zone, it gives the wrong dates. I don't know which part of the setting (in RStudio or in my Mac?) I should adjust.
2007 Apr 08
10
Ferret and non latin characters support
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
2017 Sep 23
1
"XLConnect" packages; Excel dates read incorrectly
Hi John, It could be due to this: https://support.microsoft.com/en-au/help/214330/differences-between-the-1900-and-the-1904-date-system-in-excel Jim On Sat, Sep 23, 2017 at 1:04 PM, John <miaojpm at gmail.com> wrote: > Hi, > > I tried to read xlsx files by "XLConnect" packages, but the dates are > one day earlier than it is supposed to be.
2017 Sep 23
1
"XLConnect" packages; Excel dates read incorrectly
Jim, I don't see how that link could be related to John's issue. Symptoms related to your link involve discrepancies of four years whereas John is seeing discrepancies of one day. John, I do not see any attached files. Regards On Sat, Sep 23, 2017 at 1:30 PM, Jim Lemon <drjimlemon at gmail.com> wrote: > Hi John, > It could be due to this: > >
2006 Jun 17
5
Having trouble listing tiers of categories
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
2011 Aug 12
1
Extract named regions from an Excel file using XLConnect?
Hi Everybody In R, the XLConnect package can read and write named region to and from Excel. In order to read a named region with the readNamedRegion function you need to know it''s name. You can check is a name exists with existsName, but you still have to know the name. Is there a way to actually get a list of the named regions in XLConnect sinilar to getRanges in the xlsx package. On
2017 Sep 24
1
"XLConnect" packages; Excel dates read incorrectly
> On Sep 23, 2017, at 6:30 AM, Eric Berger <ericjberger at gmail.com> wrote: > > Jim, > I don't see how that link could be related to John's issue. Symptoms > related to your link involve discrepancies of four years whereas John is > seeing discrepancies of one day. > The MS Excel starting point was off by one day. R does not repeat that error. MS claims that
2017 Nov 08
1
Help Converting Calendars
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
2017 Sep 24
1
"XLConnect" packages; Excel dates read incorrectly
Hi John, I was able to reproduce your problem in my environment. I modified the statement date11<-as.Date(a_col$date, format="%Y-%m-%d") to date11<-as.Date(as.POSIXlt(a_col$date),format="%Y-%m-%d") which then gives the output you would like to see (at least on my system) > date11 [1] "2004-01-01" "2004-01-02" "2004-01-05"
2017 Nov 08
1
Help Converting Calendars
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"
2017 Sep 24
2
"XLConnect" packages; Excel dates read incorrectly
Hi, Thank you for all your responses. For Eric, The files are attached. (I believe it was also attached in my first message) For David, Could you send me the link regarding possible solutions or a more comprehensive description of the problem? Thanks, John 2017-09-23 22:29 GMT-07:00 David Winsemius <dwinsemius at comcast.net>: > > > On Sep 23, 2017, at 6:30 AM,
2018 May 29
1
Excel Add-Ins Not Loaded When Using excel.link & RDCOM
Dear All, I am using excel.link package to open and modify Excel files. When I manually open Excel, all my add-ins are loaded without a problem. But when I open Excel using excel.link package, like: xls<-xl.get.excel() xl.workbook.open("MyFile.xlsx") some Excel add-ins are (installed but) not loaded. Since the problem is related to local add-ins at my side, I cannot reproduce the
2010 Feb 23
2
Importing Headers from excel files
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,) >
2009 May 28
4
Read & name multiple excel sheets using RODBC
I''d like to be able to read multiple sheets from an excel workbook and use the sheet name to name the resulting dataframe using RODBC. at the moment i''ve figured out how to do it the long way (see below) but feel sure that there is a speedier & possibly automatic way to do it in R. i''ve tried to run a loop using sqlTables but it seemed to break the connection.
2011 Jan 26
2
Re: Can not open Excel password protected file
meonline, when you say > if I save the original .xlsx w/o a password, then open under wine and create a password, things work as expected do you mean that you can open the new password protected with MS Office in Windows? Because I can''t... I''ve tried with Wine 1.3.12, but the problem is still here.
2011 Mar 31
0
Problems reading excel file with RODBC connect
Hello, I am trying to read an Excel file using RODBC connect (its attached) using the following code: Data<-odbcConnectExcel2007(''acciones_col.xlsx'',readOnly=T,) datos<-sqlFetch(Data,''Bloomberg'') odbcClose(Data) The file contains stock data downloaded from bloomberg, and it contains five variables per stock (so every five columns there is an empty