I have a Delphi application using DevExpress cxGrid (which is connected to database).
I require to be able to copy-paste data from Excel into the grid.
Is this possible? If so, how to do it, which additional components do i need?
I have a Delphi application using DevExpress cxGrid (which is connected to database).
I require to be able to copy-paste data from Excel into the grid.
Is this possible? If so, how to do it, which additional components do i need?
Check the format with
Clipboard.HasFormat(CF_TEXT)
.Extract the text with
Clipboard.AsText
.Split into rows with
StringList.Text := Clipboard.AsText
. Each item in the string list is now a row from the clipboard.Split each row into individual cells using a Split function: