Topic: Copy paste

Hi all,
Is there a way if i multiselect and copy some rows from an excell file and paste them in a tablegrid ? I have asked it before a long time ago but get no answere.

Re: Copy paste

Hi,
This is a revision of the Prahousefamily example
(http://myvisualdatabase.com/forum/viewt … 906#p28906)

Post's attachments

Attachment icon CopyScript1.zip 6.13 kb, 97 downloads since 2023-02-14 

Re: Copy paste

Привіт Sparrow,
Thanks for this - it's going to be very useful.
Derek.

Re: Copy paste

Hi Derek,


There are some features when working with Excel and an example program:


1. Work in the program is carried out exclusively with an already created table in the database.
2.Columns exceeding the number of columns in the database are cut off.
3. To copy complete lines (let's say line numbers 1, 4), lines 2 and 3 must be hidden, otherwise lines 1, 2, 3, 4 will be copied.


And yes))) I forgot to remove the stupid check in the script ( if Length(arrFields) <> 2 then.. ).
But it can be converted into a check for 0, or whatever you need.

Re: Copy paste

Hi Sparrow,
Thanks for the extra information.
Derek.