Hello,
I've been using: tmp.df = read.xls(filename, stringsAsFactors = FALSE)
to read in my files. Even though I get the "There were 50 or more
warnings" thing, for the most part most of the data is read in correctly.
However, there are a few select rows where there are values but they are being
read in as NA. I copy and pasted those rows to their own individual xls file and
when I tried to read in that sheet, it worked fine. This makes me wonder if it
has something to do with the way that the cells are formatted, but I've
checked the individual cell formats and they are all indeed the same.
Another strange thing that happens is something like the following. Say you
have the following cash flows: NA NA NA NA 16000 0 0 0 0 0 0 900000 700000 0 0 0
0 0 0 0 -2000000. It won't read anything until the 700000 and after.
Finally, it actually looks like for ALL rows, the first few columns are
being read in as NA even though some of them have values (while others are read
in correctly as NA)
Any help would be great!
Thank you
THIS MESSAGE AND ANY ATTACHMENTS ARE CONFIDENTIAL, PROPRIETARY, AND MAY BE
PRIVILEGED. If this message was misdirected, BlackRock, Inc. and its
subsidiaries, ("BlackRock") does not waive any confidentiality or
privilege. If you are not the intended recipient, please notify us immediately
and destroy the message without disclosing its contents to anyone. Any
distribution, use or copying of this e-mail or the information it contains by
other than an intended recipient is unauthorized. The views and opinions
expressed in this e-mail message are the author's own and may not reflect
the views and opinions of BlackRock, unless the author is authorized by
BlackRock to express such views or opinions on its behalf. All email sent to or
from this address is subject to electronic storage and review by BlackRock.
Although BlackRock operates anti-virus programs, it does not accept
responsibility for any damage whatsoever caused by viruses being passed.
[[alternative HTML version deleted]]
