Using Excel SDK of SAP Build Process Automation to extract data from multiple spreadsheets

[LuisBenavidesA]

Tutorials: https://developers.sap.com/tutorials/spa-create-excel-automation.html
--------------------------

Dear developer there are a one module to allow you to extract data from a workbook with multiple spreadsheets.

Main modules:

Enumerations Collection of the MS Excel constants.

Error Excel errors.

Application Collection of functions based on the MS Excel application.

Workbook Collection of functions related to MS Excel workbook. Use the Workbook activities to activate, close, open or close workbooks.

Worksheet Set of activities related to MS Excel worksheet. Use the Worksheet activities to read (get) or write (set) cells with different options.

Pivot Table Set of activities related to MS Excel pivot table. Use the activities to refresh or get names of the existing pivot tables.

Excel Helper Collection of functions to ease MS Excel operations within an automation.

I have created a automation artifact where I have used Excel Cloud Link, but it module just allow me to extract data from specific spreadsheet and not for all sheets available into workbook. I am wonder if I need prepare workbooks with a one sheet before processed.

Thanks,

Luis 🙂

[Dan_Wroblewski]

raghuraman.ramakrishnan Can you help with this question?

[LuisBenavidesA]

Thanks a lot daniel.wroblewski, I am try it and work well, thanks 🙂

[Tom_G]

Is there any way to extract Excel data without the Desktop Agent?