Game Development Community

Excel in TGE?

by Zergcow · in Torque Game Engine · 02/26/2008 (10:24 am) · 7 replies

Hey i didnt know where else to post this but i was wonding how to open a Excel sheet in a pop up window in TGE. I have a working button and currently have it where it opens a website. now i want a button that can open an Excel document. any ideas?

Also on a more advanced note and i am sure it would take alot more code but i was wanting to eventually be able to display only certain cells in the excel document and even make it so the user could select what data they want to see.

any ideas/hints?
NextNext Thread
PrevPrevious Thread
More from Torque Game Engine


Torque Owner Zergcow
#1
02/26/2008 (11:05 am)
Or hey how about bringing in data from an access database? And then being able to export it into excel from in the game and then having a window that could display that excel sheet (or any excel sheet)

so, any thoughts on how to acess an external data base and/or an excel sheet?

Associate Jaimi McEntire
King of Flapjacks
#2
02/26/2008 (11:49 am)
You could create a c++ function that would ShellExecute() a file, and then expose that to script. Then in the script you could ShellExecute the XLS file you want to display.

Torque 3D Owner Thomas Bang
#3
02/27/2008 (6:42 am)
I wrote a Plugin (DLL) to transfer data from and to a Microsoft Access Database.

Torque Owner Zergcow
#4
02/27/2008 (7:43 am)
Any links to examples? I am mostly a 3D artist but i do know the basics of coding, i dont think i could do this from scratch with my limited knowlege though.

Torque 3D Owner Thomas Bang
#5
02/27/2008 (7:48 am)
No. There are no examples.
I wrote this DLL for another engine.

In TGE i did a test with the same Access Database and could display all values in a Gui (Listview).

Torque Owner Zergcow
#6
02/27/2008 (4:34 pm)
Did you want to share how you did that or give some advice on how to do it or were you just trying to say it can be done? Do you know where I can go to find info on database access coding or any source of help that may lead me in the general direction of how to accomplish this? Not that your input is not appreciated but I am asking for help not evidence that it has been done before. So any help or input that would lead me in the right direction for getting this done would be great thanks!

Torque 3D Owner Thomas Bang
#7
02/28/2008 (12:08 am)
Oh, sorry. My mistake.

I wrote this DLL in Delphi. You can get a free Version of Delphi at http://www.turboexplorer.com (private AND commercial use allowed !!!).

Now you can include this DLL in TGE's Source via dynamic and static.
If you are interested in Delphi-Programming (Pascal) then you will get the complete Workflow from me.


Greetings

Thomas Bang
Germany