how to put a table in the clipboard

Moderator: Rathinagiri

User avatar
dragancesu
Posts: 921
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

how to put a table in the clipboard

Post by dragancesu »

in the examples I've found to put some text in the clipboard

Question: how to put a table (or part) to the clipboard, in larger systems, it is the simplest way to transfer data from a table in Excel (for example)
User avatar
mol
Posts: 3720
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Contact:

Re: how to put a table in the clipboard

Post by mol »

You can separate cells by chr(9) and end rows with chr(13)+chr(10)
Such a prepared string you should paste to clipboard:
System.Clipboard := cClipboard
User avatar
dragancesu
Posts: 921
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

Re: how to put a table in the clipboard

Post by dragancesu »

Thanks for the tip

Based on that, I made a program that creates a program for it, is independent but it is easily converted to a routine

What better way to transfer the date field?
Attachments
program.zip
(1.44 KiB) Downloaded 302 times
User avatar
Pablo César
Posts: 4059
Joined: Wed Sep 08, 2010 1:18 pm
Location: Curitiba - Brasil

Re: how to put a table in the clipboard

Post by Pablo César »

Yeah, you're right Marek !

Dragan, please see this example: http://hmgforum.com/viewtopic.php?p=22771#p22771
HMGing a better world
"Matter tells space how to curve, space tells matter how to move."
Albert Einstein
User avatar
dragancesu
Posts: 921
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

Re: how to put a table in the clipboard

Post by dragancesu »

I saw a program ok but I need something different

HMG in the windows world, and as I understand Clipboard is a powerful system, other programs to use so I thought I take this opportunity

Often faced with the problem of data transmission, Excel knows to open DBF, knows and openoffice but the question is whether it knows the user. I think that is enough for click button "Copy to the clipboard <Ctrl-C>", open Excel (or OpenOffice) and choose Paste <Ctrl-V>
User avatar
Pablo César
Posts: 4059
Joined: Wed Sep 08, 2010 1:18 pm
Location: Curitiba - Brasil

Re: how to put a table in the clipboard

Post by Pablo César »

No entendi :(
HMGing a better world
"Matter tells space how to curve, space tells matter how to move."
Albert Einstein
User avatar
esgici
Posts: 4543
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Contact:

Re: how to put a table in the clipboard

Post by esgici »

mol wrote:You can separate cells by chr(9) and end rows with chr(13)+chr(10)
Such a prepared string you should paste to clipboard:
System.Clipboard := cClipboard
Hi Mol

As far as I know you are an expert on working with Excel files :arrow:

My question is : which method is the best for import / export Excel files ?

Better : would you give a SSW sample ?

Thanks in advance :)
Viva INTERNATIONAL HMG :D
Javier Tovar
Posts: 1275
Joined: Tue Sep 03, 2013 4:22 am
Location: Tecámac, México

Re: how to put a table in the clipboard

Post by Javier Tovar »

Sr. Esgici,

Que es "SSW", busque información sin buenos resultados.

Saludos
User avatar
danielmaximiliano
Posts: 2612
Joined: Fri Apr 09, 2010 4:53 pm
Location: Argentina
Contact:

Re: how to put a table in the clipboard

Post by danielmaximiliano »

Hola Javier...

cuando busques algo especifico que este en un foro como en este caso SSW al buscarlo en Google usa
"SSW hmgforum" por supuesto sin comillas, te traerá un enlace y a simple vista esto
SSW (short, simple and working) ...
*´¨)
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`. Harbour/HMG : It's magic !
(¸.·``··*

Saludos / Regards
DaNiElMaXiMiLiAnO

Whatsapp. := +54901169026142
Telegram Name := DaNiElMaXiMiLiAnO
Javier Tovar
Posts: 1275
Joined: Tue Sep 03, 2013 4:22 am
Location: Tecámac, México

Re: how to put a table in the clipboard

Post by Javier Tovar »

Gracias DanielMaximiliano por el Tip!

Saludos
Post Reply