How to get Excel data using Python?

I already showed You how to get data from Excel file using ListObject and using SQL query in VBA. To make things more interesting I thought it is time for something way more different. In this article I’m going to shortly present how to get Excel data using Python.

Continue reading “How to get Excel data using Python?”

How to close SAP Logon window?

In all of my SAP based articles I showed You how to open SAP Logon, choose the environment, go to transaction, do whatever You need inside and then close the environment. In this one I will present to You the last thing, which I never show You before – how to close SAP Logon window.

Continue reading “How to close SAP Logon window?”

How to get data from Excel table using ListObject?

Let’s go back to the basics and learn about getting the data from Excel worksheet. But not just filled worksheet cells with text and numbers. In this article I’m going to show You how to get the Excel table data using ListObject in VBA.

Continue reading “How to get data from Excel table using ListObject?”

How to Save As and Open Excel during SAP scripting?

I received from You so many questions about this, so I decided to investigate the issue. In this article I’m going to show You how to save as and open Excel spreadsheet during execution of SAP scripting code.

Continue reading “How to Save As and Open Excel during SAP scripting?”

Native Microsoft Windows dialogs in SAP

In one of my articles I showed You how to turn off the pop up message boxes in Accessibility & Scripting options , but didn’t really describe about the 3rd checkbox below Enable scripting. In this article I’m going to show You how Show native Microsoft Windows dialogs works in SAP.

Continue reading “Native Microsoft Windows dialogs in SAP”