Forum Discussion
Question about the excel spreadsheet row limit
Hi, I'm having trouble understanding what is meant by the excel worksheet/workbook row limit of 1,048,576 rows. Does this mean that Excel cannot display a greater number of rows or that it c...
I've just run an experiment using an R data frame with 1.5 million rows of data (1 column with random numbers from 1-9). I wrote the dataset to an .xlsx file, then I read the .xlsx file into SAS. The SAS dataset has all 1.5 million rows. Do you know why this is?
I cannot explain that.