I am having an Excel file and i want to read that in R, without using packages or just open it and save it as .csv. I have tried to rename it from e.g data.xlsx to data.csv and these commands with many ways : "read.csv2(...)" , "read.csv(...)" but nothing happened. I know it seems strange but my professor in the exam won't allow us to use packages and also I won't be able to open the file even to do the "save as" .csv process , because of the many people trying to open it at the same time.
Thanks in advance.
Update: These are the warnings that R always give me in this problem. I have checked working directory,file name and tried that for different "header" and "sep". I can't understand where are in my test excel embedded nulls.It doesn't matter that i don't have sep in my excel... Without sep=";" , the warnings stay the same.
> data<-read.table("TESTDDD.xlsx",sep=";")
Warning messages:
1: In read.table("TESTDDD.xlsx", sep = ";") :
line 1 appears to contain embedded nulls
2: In read.table("TESTDDD.xlsx", sep = ";") :
line 2 appears to contain embedded nulls
3: In read.table("TESTDDD.xlsx", sep = ";") :
line 4 appears to contain embedded nulls
4: In read.table("TESTDDD.xlsx", sep = ";") :
incomplete final line found by readTableHeader on 'TESTDDD.xlsx'