I need to copy a entire column “K” from an Excel file and save it the clipboard. My script then opens SAP and there is a portion where i will upload that data to the file. This is the best way to ensure the data from the excel file transfers to the SAP module. My issue is everywhere i search I can not find a way to do this. I can copy one cell or data point to the clipboard, i need to copy an entire column and paste it.
All help will be greatly appreciated.