I’m trying to extract a table of data from an application I use at work. The application will produce the data in a temporary instance of excel. I want to copy the data from the temporary instance, and paste it into an actual excel workbook on my harddrive.
I was planning to copy the data from the excel instance (ctrl + c), get clipboard to a DataTable, and then use that datatable to write range to Excel.
However, when I use the “get from clipboard” feature, I get an error if I try to output to a DataTable variable. It appears that I can only copy it to a GenericValue.
Is there a way to either copy the clipboard as a DataTable, or convert the generic value to a DataTable?
Thanks in advance