Worksheet Technical Specifications
The following technical specifications for the worksheet include the number of cells allowed in the worksheet and the nature of the numbers allowed in the worksheet.
- Maximum number of rows in a worksheet: 1 billion
- Maximum number of columns in a worksheet: 1 billion
- Approximate memory requirements (for unformatted numeric data): 10.5 bytes per cell + 24 bytes per column
- Maximum numeric precision (counting the digits before and after the decimal place): 15 digits
- Maximum numeric resolution (the smallest detectable difference between two numbers): 2.22E-16
- Maximum absolute value (the largest value that can be represented): 1.79769E+308
- Minimum absolute value (the smallest value that is different from zero): 2.22507E-308
Example 1
This example has 10,000 rows of numbers in three columns.
30,000 cells x 10.5 bytes/cell = 315,000 bytes (308 Kbytes)
3 columns x 24 bytes/column = 72 bytes
TOTAL MEMORY NEEDED (in addition to memory needed to run the program): 380 Kbytes
Example 2
This example has three rows of numbers in 10,000 columns.
30,000 cells x 10.5 bytes/cell = 315,000 bytes (308 Kbytes)
10,000 columns x 24 bytes/column = 240,000 bytes (234 Kbytes)
TOTAL MEMORY NEEDED (in addition to memory needed to run the program): 542 Kbytes