how to put a table in the clipboard

Moderator: Rathinagiri

User avatar
dragancesu
Posts: 811
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia
Has thanked: 30 times
Been thanked: 232 times

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: 3409
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Has thanked: 268 times
Been thanked: 173 times
Contact:

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: 811
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia
Has thanked: 30 times
Been thanked: 232 times

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 185 times

User avatar
Pablo César
Posts: 4059
Joined: Wed Sep 08, 2010 1:18 pm
Location: Curitiba - Brasil
Has thanked: 100 times
Been thanked: 182 times

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: 811
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia
Has thanked: 30 times
Been thanked: 232 times

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
Has thanked: 100 times
Been thanked: 182 times

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: 4538
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Has thanked: 410 times
Been thanked: 118 times
Contact:

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
Has thanked: 1 time
Been thanked: 2 times

Post by Javier Tovar »

Sr. Esgici,

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

Saludos

User avatar
danielmaximiliano
Posts: 2359
Joined: Fri Apr 09, 2010 4:53 pm
Location: Argentina
Has thanked: 435 times
Been thanked: 84 times
Contact:

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
Has thanked: 1 time
Been thanked: 2 times

Post by Javier Tovar »

Gracias DanielMaximiliano por el Tip!

Saludos

Post Reply