Topic: Change spreadsheet
Hi everyone, I would like to know how to replace the 'Excel' function with another spreadsheet because I use 'MyOffice Standard'.
Sabine
My Visual Database → Script → Change spreadsheet
Hi everyone, I would like to know how to replace the 'Excel' function with another spreadsheet because I use 'MyOffice Standard'.
Sabine
Hi Sabine,
Like you, I don't use Excel or LibreOffice Calc.
To export the contents of a tablegrid, what I do instead is
procedure Form1_Button1_OnClick (Sender: TObject; var Cancel: boolean);
begin
form1.tablegrid1.dbPopupMenu.Items.Find('Copy all').Click;
openfile('C:\Program Files\Spread32\Spread32.exe');
end;
The script
1. copies all rows in the tablegrid
2. opens my spreadsheet software (Spread32)
3. I then manually use ctrl+V (or right-click+paste) to copy the tablegrid contents. If you wanted to automate this, I guess you could use something like 'AutoIt' or 'Autohotkeys' (but it's not something I do very often so it's not really worth setting up).
Regards,
Derek.
Thanks Derek it works well. I tried directly putting a 'desktop' shortcut in the program and it worked.
Do you know 'Essential Office', it's a very nice all-in-one that replaces Microsoft Office and is free.
Here is the link:
https://www.neoteo.com/essential-office … tibilidad/
Thanks Sabine, I'll check it out.
Derek.
My Visual Database → Script → Change spreadsheet
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi