What versions of Excel are supported in LISA 7.5? I need an exhaustive list.
TATA Consultancy Services
I just had this question too and here is the brief but definitive reply from LISA support:
“CA LISA 7.5 supports the .xlsx format that is used starting in the Microsoft Excel 2007 version.”
CA Support Request 21768003 01 - EXCEL SUPPORT
Hope that helps!
Any answers here for Peter?
I have played with the Excel functionality. I can't say definitively what versions of Excel are supported, but LISA Workstation uses Apache POI for its Excel functionality.
http://poi.apache.org/ suggests Excel 97-2008. I know for certain that I have used both XLS and XLSX files as data sets in LISA.
I suppose my question to you would be: What versions of Excel are you using?
Perhaps the more relevant question is: What file formats does your organization use?
LISA supports both .xls and .xlsx (.xls goes back all the way to Excel in 97).
Do the file formats you use predate this?
Retrieving data ...