To get Excel version by ABAP

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[kesavadas_thekkillath]

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 )

[kesavadas_thekkillath]

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.

[Former Member]

Hi, Kesavadas

Thank you very much for your commnet.

Finally I solved the problem.

Thanks again.