Extracting the data from SAP

[ovidiu_2088]

Hello, I started to learn UiPath and I love it so much. I need a little help, I learn to extract the data from SAP. The extension of the file is .html, and I want to upload the content, the file is open, into a website, can you tell me how can I do that? I have only one sheet with 6 columns. What activities should add? Thank you very much.

[Pablito (Pawel Wozniak)]

Hi @ovidiu_2088,
Welcome to the Community!
Could you visualize it a little bit for a better understanding?

[ovidiu_2088]

Hi, I want to do something else much easier, after extracting the file from SAP, extension is .html, I don’t know how can I convert into .xlsx extension and save on desktop. Thank you!

[lena2505 (Lena E)]

What transaction do you use? there is often the possibility to choose file type of SAP exports, e.g. excel
so your bot does not have to convert the file

[ovidiu_2088]

Maybe something is wrong in my steps. I use spreadsheet from the transaction LX03, basically is the stock from some materials, so that means I save in .html extension so that’s why I think I’m not doing anything right. I tried with “Data Scraping” but it takes to long because there is a lot of data. As you can say, how can I save directly into excel file with extension .xlsx?

[LevKushnir]

HI @ovidiu_2088

Check this screenshot

In your SAP WinGUI it can look a bit different, but navigate to SAP Menu, goto LIST and export all stuff as an Excel file.

Best regards, Lev

[ovidiu_2088]

Yes, I discover now, I was a little confused. After the file was exported, from the open table, I copied all the data into another excel file and I uploaded to a web site. My issue was that how can I transform that excel file with extension .html (exported from SAP) into an excel file with extension .xlsx. Sorry for misunderstanding but also, thank you very much!

[LevKushnir]

this is the right format