|
Further to my previous posting (below), I've taken what seems sensible advice from Richard Heiberger (many thanks Richard), and attached a sample file. I'd be immensely grateful if anyone could test the following code on an Splus version later than 6.1, to see if you end up with nonsense fields (\240\240\240\240\240) inserted into some of the slots where there is white space in the excel chart. It may be that the problems I'm having relate only to 6.1. The attached file should be copied onto the main root of the C drive (in windows) or please modify the pathway in the first line accordingly. diary <- importData("c:\\Diary_test.xls",
print (diary)
In response to the suggestions from other users, I've got hundreds of these to sort out, so opening each and replacing blanks with something more sensible would be arduous indeed. I've also tried using "keep" instead of specifying startCol and endCol, and various other ways about. Many thanks. Jonathan Dakin . <<...>> Previous posting:
I've have a large number of excel files which I need to import into Splus. (Each is a daily diary card). I'm getting very unpredictable results when there are blank cells in the Excel file. Quite often Splus substitutes: "\240\240\240\240\240" where there should be a blank, or NA. There is no very easy way of removing the blanks, without going through hundreds of spreadsheets and modifying each. Exporting each to a text file would be equally as arduous. The only solutions I've found in the archive of the mailing list involve one of the above. Does anyone know of a work-around or a solution to this ? I'm using Splus 6.1 Professional under W2K. Many thanks and any help much appreciated.
|
