Data driven approach - Excel limitations

book

Article ID: 4581

calendar_today

Updated On:

Products

CA Application Test Service Virtualization CA Continuous Application Insight (PathFinder) CA Service Virtualization (DevTest / LISA / VSE / Application Test)

Issue/Introduction

Limitations of Storing Large Response in Excel

 

Cause

When storing the response in the excel, we have a limitation that a cell can hold 30k characters only. So, the response xml if exceeding this limit (it always or mostly do) cannot be stored in a single cell and responded. It's tough to split xmls to fit in to each cell when it's huge. Has CA thought of an alternative around it? It makes this feature unusable!!

 

Environment

Not relevant.

Resolution

we don't have anything to control EXCEL in DEVTEST. This is a Microsoft limitation.   

Here is the link to EXCEL limitation : 

https://support.office.com/en-us/article/Excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3 

Microsoft says 32,767 is the maximum size of a cell

 

 

 

You can switch to a database table instead of using EXCEL.

 

 

 

Additional Information

Community post -

https://communities.ca.com/ideas/235733056