Is updating an Excel Workbook the same as the following? 1) reading in the entire workbook in memory
2) update specific contents - i.e. updating a value in a single cell or updating values in several cells 3) writing the workbook replacing the original workbook I noticed that the size of the xls or xlsx is less than the original regardless of how many cells I update. Does that mean that some information is left out (or not read in) from the original file? Are there any limitation in this use case (charts, formulas, etc..)?
