User Profile
brentjames
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Re: Question about the excel spreadsheet row limit
Detlef_Lewin When I open it, I get this message: If I press yes, then I get this message: In excel, it only shows the first 1,048,576 rows, as expected. When I close out of excel, it asks if I want to save. If I say yes, then the rows after 1,048,576 rows are removed (checking in R). If I don't save, they remain.Re: Question about the excel spreadsheet row limit
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?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 cannot store data for more than than 1,048,576 rows? For example, if I combine various datasets and write this combined dataset to an excel spreadsheet file, and this dataset contains 2 million rows and 20 columns, will the excel spreadsheet contain all 2 million rows and the data contained in each of them? Not being able to view all 2 million rows in Excel is not an issue; I just want to be sure that no data is being lost. Thank you!
