How to extract worksheet Descriptions within BPC

[Former Member]

Hi All,

I have a question, I would like to know is there any other method besides doing it manual, to extract worksheet descriptions?

I have logged on SAP GUI, used UJFS to download the files needed, I have then unzipped the files, allowing full access to all files downloaded.

what I'm trying to achieve is to document the list.

for example of one workbook, there are 5 worksheets, and each worksheet has its own descriptions,

I need to document that onto one spreadsheet..

it basically needs to look like the image below.

Thank You,

Chantal

[former_member186338]

Hi Chantal,

If you have done:

"I have logged on SAP GUI, used UJFS to download the files needed, I have then unzipped the files, allowing full access to all files downloaded."

Then create in some Excel file VBA script to loop the files in the download folder and get the required info. You need to know VBA!

Vadim

[Former Member]

Hi Vadim,

Thank You for your help.

I understand what you mean.

Kind Regards:

Chantal

[former_member186338]

If the answer is clear then close the discussion!

[Former Member]

just one more thing, is there any other way besides using VBA to extract the worksheet descriptions?

Thank You,

Chantal

[former_member186338]

There is no other practical way besides VBA! You can try to search for open source PHP library to work with Excel files but it's not very reliable...