From an Oracle application, I need to get the output from a search result by copying it.
This is what I’ve found:
When copying all lines from the search result, i get the result from the Clipboard (Ctrl+A, Ctrl+V) pasted into an empty Excel sheet. From the Excel sheet, I read range into Data Table, and can work from there. This works fine. But:
I would like to do this without having to have the Visible option in Excel App Scope properties ticked. Meaning: I would like the procedure to take place in the background.
Task: From Clipboard to DataTable (the copyed data is structured).
1: Is there a way to do this without visible Excel file?
2: Maybe there is another way to solve the task? Scrape is not good, because it rules out line 1 (blue). Also in this matter, the scraping has proven not to be reliable, because the letters get mixed, 6 sometimes gives 5 and 5 sometimes gives 6 and so on. Not reliable.