When using the loadTable action with the TIKACONV=True option to convert and load Microsoft Excel (.xlsx) files into SAS Cloud Analytic Services tables, missing or incomplete text content might occur in the resulting SAS Cloud Analytic Services table.

This issue is related to the way .xlsx files are processed. The .xlsx format is a compressed ZIP archive that contains multiple XML components. During parsing, these components are decompressed in memory. Although the original file size might be relatively small (for example, 10 MB), certain embedded ZIP entries can inflate to over 100 MB during decompression.

To protect against ZIP bomb attacks and out-of-memory errors, the underlying parsing library enforces a 100 MB limit per ZIP entry. If any individual entry exceeds this limit, its content is truncated or skipped, which leads to partial or missing data in the loaded SAS Cloud Analytic Services table.