topic Re: To get Excel version by ABAP in Application Development and Automation Discussions

To get Excel version by ABAP

Former Member — Wed, 11 Apr 2012 05:26:55 GMT

Hi all,

I'm wondering there are any methods to get Excel version by ABAP.

I'd like to know EXCEL 2002, 2007, or 2010 by ABAP.

Is it possible by ABAP?

Thaks.

Re: To get Excel version by ABAP

Former Member — Wed, 11 Apr 2012 05:55:02 GMT

Hi,

I did not get whet you are saying. Be more specific and clear.

Do you want to upload excel files to SAP and want to know whether the following versions mentioned by you are compatible with SAP ?

Well, based on my experience, I can surely say that upto Microsoft Office 2007 (*.XLSX), excel upload works perfect. Microsoft Office 2010 should also work perfectly as the file has extension has not changed as that we saw from 2003 to 2007 version.

Regards,

Danish.

Re: To get Excel version by ABAP

Former Member — Wed, 11 Apr 2012 06:41:58 GMT

Hi,

Thanks for your prompt reply.

What I would llike to do is only to check excel version of client PC by ABAP.

I'm facing the problem of the number of downloading records due to the difference of max rows between Excel 2003 and 2007.

Excel 2003 : Max rows →　65,536

Excel 2007 : Max rows →　1,048,576

Therefore, I d like to insert the check logic that checks Excel version of client PC.

The process of programm is following.

1.Count number of records that will be absorbed.

2. Absorb records from DB.

3. Download absorbed data from DB in text file(.txt).

4. Read and Display the downloaded text file by Excel Macro.

Between 1 and 2, I d like to insert check logic in order to restrict the number of records.

Re: To get Excel version by ABAP

kesavadas_thekkillath — Wed, 11 Apr 2012 07:14:33 GMT

This will give you the result in Windows. For other OS there must be another way similar


DATA: excel TYPE string. 

CALL METHOD cl_gui_frontend_services=>registry_get_value
  EXPORTING
    root      = cl_gui_frontend_services=>hkey_classes_root
    key       = 'Excel.Application\CurVer'
  IMPORTING
    reg_value = excel.

Re: To get Excel version by ABAP

Former Member — Wed, 11 Apr 2012 07:41:32 GMT

Hi, Kesavadas

Thank you very much for your commnet.

Finally I solved the problem.

Thanks again.

Re: To get Excel version by ABAP

Former Member — Wed, 11 Apr 2012 07:42:30 GMT

Hi Junichi,

Kesav has suggested a very nice code to find the excel version.

Kesav - In cases of Office 2007, this value contains Excel.Application.12. Does this mean that in case of Office 2003, this contains Excel.Application.11 and so on ?

Also, what if 2 versions of Microsoft Office are installed in the same PC ?

Regards,

Danish.

Re: To get Excel version by ABAP

kesavadas_thekkillath — Wed, 11 Apr 2012 07:49:03 GMT

Hi Danish,

I donot have much idea on that. To be frank I got the registry key value from a java source code and just used it in that class. I did not even execute it. . Let the OP update the output which he got. The OS help documents explains about this.

When there are 2 versions installed , the registry values must be different accordingly. ( Does it allow to install two versions at a time )