similar to: "XLConnect" packages; Excel dates read incorrectly

Displaying 20 results from an estimated 2000 matches similar to: ""XLConnect" packages; Excel dates read incorrectly"

2017 Sep 23
0
"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. I moved from California
2017 Sep 23
2
"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: > >
2017 Sep 24
0
"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 Sep 24
3
"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,
2017 Sep 24
0
"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
2013 May 02
1
Problems with reading data by readWorksheetFromFile of XLConnect Package
Hi, Attached are two datasheet to be read. My raw data "130502temp.xlsx" contains numbers with ' symbols, and they can't be read as numbers. Even if I copy and paste as numbers to form a new file "130502temp_number1.xlsx", they could not be read smoothly. 1. How can I read the datasheet as numbers? 2. How can I treat the notation "-" as (1)
2017 Aug 30
2
Converting character to numeric using the package "XLConnect"
Hello, >From an Excel file imported into R where each cell contains characters, I would like to convert some characters to numeric. However, my code doesn?t work. When I write data to worksheets in an Excel file, some numbers in the cells are stored as text (instead of numeric). Here is my code (the Excel file is attached): rm(list=ls(all=TRUE)) library(XLConnect) tab <-
2017 Aug 30
0
Converting character to numeric using the package "XLConnect"
> On Aug 30, 2017, at 12:24 PM, Nelly Reduan <nell.redu at hotmail.fr> wrote: > > Hello, > > From an Excel file imported into R where each cell contains characters, I would like to convert some characters to numeric. However, my code doesn?t work. When I write data to worksheets in an Excel file, some numbers in the cells are stored as text (instead of numeric). Here is my
2017 Aug 30
3
Converting character to numeric using the package "XLConnect"
The Excel file can be found from this link: https://1drv.ms/x/s!Apkg2VlgfYyDgQ_mcJ8F4CaXV_Nh [https://r1.res.office365.com/owa/prem/images/dc-xlsx_40.png]<https://1drv.ms/x/s!Apkg2VlgfYyDgQ_mcJ8F4CaXV_Nh> File.xlsx<https://1drv.ms/x/s!Apkg2VlgfYyDgQ_mcJ8F4CaXV_Nh> Partag? via OneDrive Thanks very much for your help. Nell ________________________________ De : David Winsemius
2016 Apr 23
1
Java memory error when reading a small xlsx file
Hi, I tried to read a (small) xlsx file by "readWorksheetFromFile" function of "XLConnect" package and "read.xlsx" function in "xlsx" package, but I got this error message: Error: OutOfMemoryError (Java): Java heap space I tried to follow the solution on the web
2013 Jul 22
1
problem loading large xlsx file into r
Hi, I am facing trouble when trying to read large xlsx file into R. please find the code and error below. The file I was trying to read has 36,500 rows X 188 col, ~ 37 MB size. > options( java.parameters = "-Xmx4g" ) > library(xlsx) Loading required package: xlsxjars Loading required package: rJava > cftc =
2015 Nov 12
3
Problema con la lectura de datos
Otra opción es importar directamente los datos que necesites usando XLConnect (sin llevarlos a CSV). Ese paquete permite hacer cosas muy potentes desde el propio fichero de Excel. https://cran.r-project.org/web/packages/XLConnect/index.html Recomiendo, encarecidamente, la lectura de sus dos vignettes. Un Saludo, -- Miguel Ángel Rodríguez Muíños Dirección Xeral de Saúde Pública Consellería de
2012 May 09
4
Can't read xlsx file into R. Seem, Seem to have XLConnect loaded.
I have spent hours on R in Windows 7. Just installed 2 days ago so the R package should be current. Currently I am using the RGui (64-bit) for Windows. I can not read an Excel file into R from my computer. Have hours on this. Completely crazy!! I have the XLConnect package loaded. I think it is loaded because when I enter: > loadedNamespaces() [1] "base"
2013 Apr 23
1
Questions on function "readNamedRegionFromFile" in XLConnect pacakge
Hi, I have two questions on the function "readNamedRegionFromFile" in XLConnect pacakge. 1. In the documentation, # multiregion xlsx file from demoFiles subfolder of package XLConnect demoExcelFile <- system.file("demoFiles/multiregion.xlsx", package = "XLConnect") # Load a single named region into a single data.frame. df
2012 Aug 08
4
Saving Splitted Series to Excel via XLConnect
Dear R Discussion List, I would like to save my data as a xlsx file. But at first I need to split it and then save each series into a Excel column. Please take a look at the following code: dados <- data.frame(matrix(c("2012-01-01","2012-02-01", "2012-03-01","2012-04-01","2012-05-01","2012-06-01",
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 that
2016 Nov 17
2
problem with normalizePath()
The packages "readxl" and "haven" (and possibly others) no longer access files on shared network drives. The problem appears to be in the normalizePath() function. The file can be read from a local drive or by functions that don't call normalizePath(). The error thrown is Error: path[1]="\\Hzndhhsvf2/data/OCPH/EPI/BHSDM/Group/17.xls": The system cannot find the
2012 May 25
1
Java problem - XLConnect/xlsx package
Hi, I hope you guys can help me, I already posted this question on stackoverflow but did not get any help (which worked). And I need to solve this problem as quick as possible: In our firm we migrated to windows 7 (64-bit) and also updated the java packages (1.6.0_24) and also R (to 2.15). Then I tried to install my packages which i use daily and one of em is the xlsx package. But if I load the
2012 Aug 17
4
Appending many different and separate Excel files using R
Dear all, Good day! I have a problem in reading Excel files in R and appending them to each other. Suppose we have several Excel files in a directory with headers and want to use R to append them in a single file with an additional variable in the final file indicating from which files the data come from. As I have many Excel files and their sizes are very big I should write a loop in R to do
2016 Nov 18
2
problem with normalizePath()
>>>>> Evan Cortens <ecortens at mtroyal.ca> >>>>> on Thu, 17 Nov 2016 15:51:03 -0700 writes: > I wonder if this could be related to the issue that I > submitted to bugzilla about two months ago? ( > https://bugs.r-project.org/bugzilla3/show_bug.cgi?id=17159) > That is to say, could it be that it's treating the first >