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]]

