LucasForums

LucasForums (http://www.lucasforums.com/index.php)
-   T3-M4's Astromech Droid Center (http://www.lucasforums.com/forumdisplay.php?f=646)
-   -   Excel Add-In to Read/Write 2da files v1.6 (http://www.lucasforums.com/showthread.php?t=147961)

tk102 04-22-2005 02:25 AM

Excel Add-In to Read/Write 2da files v1.6
 
v1.6 released (9/27/06)
- Eliminated need for tlbinf32.dll to be present on computer
- Made 2da writing much faster

v1.5 (add-in) released (9/22/05)
- ThisWorkbook changed to ActiveWorkbook
- Distributed as .xla

http://www.starwarsknights.com/tools.php

Instructions
1. Unzip the .xla file to wherever you like. Open Excel. Choose Tools: Add-Ins.
http://img.photobucket.com/albums/v170/tk102/xla1.jpg
2. Browse to the .xla file.
http://img.photobucket.com/albums/v170/tk102/xla2.jpg
3. Make sure the new Add-In is checked and click OK.
http://img.photobucket.com/albums/v170/tk102/xla3.jpg
4. You can now Read 2DA and Write 2DA files using the File menu.
http://img.photobucket.com/albums/v170/tk102/xla4.jpg

Mav 04-22-2005 02:39 AM

WOW this is definetly going to help with .2da editing, awesome job tk!

RedHawke 04-22-2005 02:46 AM

Very, very nice tk! :thumbsup:

This will definately help when doing massive 2da edits. :D

General Kenobi 04-22-2005 09:49 AM

Ooh so sweet big T thanks man ! :elephant:

I love using Excel for stuff since I use it for most anything else table related.

I'm gonna play with this when I get home. :) Maybe this will aid me in going forward on a project I'm working on.

Achilles 04-22-2005 10:09 AM

Chainz.2da is gonna be lovin' you. Excellent work on this!

ChAiNz.2da 04-22-2005 10:17 AM

Quote:

Originally posted by Achilles
Chainz.2da is gonna be lovin' you. Excellent work on this!
:emodanc:
Ahh....yeah... it's all goooood :D

Bob Lion54 04-22-2005 10:34 AM

^^^^^^
Yea, but it was made AFTER the HUGE .2da conversion.

Great tool!!! I think "tk" should stands for "Tool Kreator."

Keiko 04-22-2005 10:58 AM

Nice Job Tk!:cool:

Darkkender 04-22-2005 12:06 PM

which version of MS excel will this be compatible with TK? Just a slight curiosity as I use an older version and some macros work and others don't. I know I can import them though.

shosey 04-22-2005 12:43 PM

sweet! I like it, I like it a lot!

Lorden Darkblade 04-22-2005 12:44 PM

Very very useful thing tk :D
Thanks! :p

SoNico717 04-22-2005 01:31 PM

Great Job TK102, this is really usefull.

Thanks for sharing this with us :).

tk102 04-22-2005 03:19 PM

Gee, I had no idea so many people would use this. I made it just to see if I could since I've been programming Excel macros lately. :p

Darkkender, I think it should work with Excel 97 and later.

The Write function, you'll notice, is significantly slower than KotOR Tool, so if anyone can come up with some optimizations to the macro code, feel free to post them.

Daiko701 04-22-2005 07:40 PM

I am recieving an error when trying to run the write function macro as follows:

Microsoft Visual Basic:
------------------------
Run-Time error '53':

File not found: TLBINF32



------------------------

I am using Microsoft office 2000 Premium (Excel) with SR-1. I can open the .2DA files but when I try to write them I recieve the error as mentioned above. My Sys Specs:

Win XP Home SP2
AMD Athalon 2200+ 1.8 GHz
512 MB DDR SDRAM
ATI 9550 128 bit 256 MB (Bios flashed to 9600 Pro 256 MB)
SB Audigy 2 LE 24 bit sound
All Latest updates for all.

I would love to be able to use this tool, yet I do not know why I am experiencing this. Any ideas, suggestions?


Edit*BTW great work on the tool, and thanks. Other than above it is superb.

Achilles 04-22-2005 07:46 PM

I'm getting it too (already sent my specs to Tk102), but I'm not too worried about it. Even though you get the error, the macro appears to be saving the changes. All's well that ends well I guess :D

Jeff 04-22-2005 07:49 PM

This is sweet TK! Good job, I love all the programs you make. Keep up the good work! :D

L33T-THX-1138 04-22-2005 09:24 PM

need help...
 
it seems easy enough to figure out but,i dunno where to get this "excel" from n e help would be much helpful thanks in advance

General Kenobi 04-22-2005 09:35 PM

Re: need help...
 
Quote:

Originally posted by L33T-THX-1138
it seems easy enough to figure out but,i dunno where to get this "excel" from n e help would be much helpful thanks in advance
Microsoft Excel (Usually contained within Microsoft Office) ;)

tk102 04-22-2005 11:16 PM

TLBINF32.dll is normally found in your C:\WINDOWS\SYSTEM32 or C:\WINNT\SYSTEM32 folder. Do a search for that file.

If you find it, try this

(from your taskbar)
Start: Run: regsvr32 tlbinf32.dll

If you're getting the error, I wouldn't expect the .2da file to be written correctly.

tk102 04-22-2005 11:38 PM

Here is a download link for tlbinf32.dll if you don't have it.

http://www.ezgoal.com/dll_files/tlbinf32.zip

Unzip the .dll to your System32 folder and do the regsvr32 command as mentioned in the previous post.

Daiko701 04-23-2005 04:03 AM

Thank you so much tk102, the tool works great. You provide better support than Microsoft lol. Beauty of a program you have made here. Now it should be easy as 1-2-3 to make all of the mods I use compatible (finally, whew).

Darkkender 04-23-2005 09:35 AM

Quote:

Originally posted by tk102
Darkkender, I think it should work with Excel 97 and later.

:elephant: :elephant: How did you know that was the version I used.:p

I personally like this for 2da's as I've started taking an interest in NWN modding or more in particular getting the hang of how they mod around some of the hardcoded elements. I'm starting to think with the proper usage of scripting we can write our own include files that provide the ability to use custom 2da files. Also I would be interested in figuring out how the game would recognize ".HAK" files and having them in the proper overide system. If we can do this it may take KOTOR I & II modding to a whole new level.

stoffe 04-23-2005 10:35 AM

Quote:

Originally posted by Darkkender
I'm starting to think with the proper usage of scripting we can write our own include files that provide the ability to use custom 2da files.

I doubt this is possible in KotOR beyond altering the 2DA files already used by some scripting functions. Unfortunately the Get2DAString() function in NWN NWScript is not present in the KotOR variant. NWScript has undergone a fair number of changes in the NWN --> KotOR transition.

Quote:

Originally posted by Darkkender

Also I would be interested in figuring out how the game would recognize ".HAK" files and having them in the proper overide system. If we can do this it may take KOTOR I & II modding to a whole new level.

Unless you are making your own modules, using hakpaks would be of limited use, since they need to be specified for each module that use the content within them.
The hakpak filename has to be set in the Mod_Hak field in the module.ifo file for all modules using it. They don't work on the global scope like the Override folder does.

Provided that the hakpak functionality still remains available in the KotOR engine, that is. I haven't tested it.

(Hakpaks are the preferred means in NWN of storing custom content (models, tilesets etc) associated with specific individual modules. They are essentially just ERF files with a .hak suffix placed in the "hak" folder.)

tk102 05-03-2005 02:40 AM

v1.1 released
 
v1.1

Made some small tweaks to the macro to get it to write appearance.2da without crashing. (Thanks for bringing that to my attention Achilles.) It's still takes my PC about 100 seconds to write the whole thing. :rolleyes:

Also added a little progress notification in the status bar of Excel during writing, and a Freeze Panes (for column and row headers) after a Read.

Xcom 05-03-2005 05:22 PM

Re: v1.1 released
 
Quote:

Originally posted by tk102
It's still takes my PC about 100 seconds to write the whole thing. :rolleyes:

I wonder if that's due to the fact that it's a macro, or because it's Visual Basic?
I don't have Excel on this rig, so I can't give it a spin, but I've been working on my own, automatic 2da merger, and it's pretty fast when writing (well, about the same speed as Fred's 2da editor), so I guess it's macro thing.

tk102 05-03-2005 07:03 PM

There's probably some tricky technique of creating a hash table in Visual Basic for Applications to determine if values have already been written, but I haven't figured it out yet. :)

Shimaon 05-03-2005 07:30 PM

Me love you long time.

This ought to be very useful until we get copy and paste for multiple rows in KT.

^^

Thanks TK!

tk102 05-04-2005 12:37 AM

v1.2 released
 
v1.2

Fixes a v1.1 bug regarding **** values that occurred if the first value in the 2da file was a ****. (Thanks Achilles)

@Shimaon: Your welcome, but um, no thanks. :)

Achilles 05-04-2005 12:53 AM

Thanks for fixing that! I just read and wrote appearance.2da again and everyone still has their weapons :mob:

tk102 05-04-2005 02:40 AM

v1.3
 
v1.3

Astrisks are expanded by Excel's Find function, which was resulting in bad writes if the first value wasn't "****".

A potential for bad writing exists if cells contain astrisks (other than "****" which is handled specially). See macro text for details.

tk102 08-15-2005 11:34 PM

v1.4 Released
 
v1.4 released

Fixed a bug that was causing "Object Variable Not Set" in the Write2da function.

General Kenobi 08-15-2005 11:37 PM

TK can you post up a linkie to your site??? I lost my favs in my 2000 to 2003 upgrade.

Thanks a million for this one I'm gonna experiment with it on a new mod i'm working on :D

:ben:
General Kenobi

tk102 08-16-2005 12:00 AM

I don't really have a site other than starwarsknights.com unless you count my KeyTweak site. :)

Langy 08-16-2005 04:20 PM

Quote:

v1.4 released (8/25/05)
Wow! It's a release from the future! That's absolutely amazing, man!

In all seriousness, this macro kicks major ass. KOTOR Tool is horrible for editing 2DAs in any major way, and being able to edit them in Excel is amazingly useful.

cry_of_paine 08-20-2005 01:31 AM

This is exactly what I was looking for. I did have to make one slight fix though. I put the routine into my personal.xls file, so that it's always available. So then the "ThisWorkbook" that you used to write the file gave me errors. I just changed that to "ActiveWorkbook" though, and it ran perfectly. I even gave it custom buttons on my toolbar to run it. You might think about doing all that and package it as an xla add-in (I'd tell you how if I could remember).

Edit tk102: Thanks for the fix and good idea about the .xla -- now I'll have to see how that works. :)

tk102 09-22-2005 06:29 PM

v1.5 Released (Excel Add-In)
 
v1.5 Released (Excel Add-In)

- Now uses ActiveWorkbook rather ThisWorkbook in macro (as per above)
- Distributed as an Excel Add-In (.xla) rather than a Module (.bas) file.

Instructions
1. Unzip the .xla file to wherever you like. Open Excel. Choose Tools: Add-Ins.
http://img.photobucket.com/albums/v170/tk102/xla1.jpg
2. Browse to the .xla file.
http://img.photobucket.com/albums/v170/tk102/xla2.jpg
3. Make sure the new Add-In is checked and click OK.
http://img.photobucket.com/albums/v170/tk102/xla3.jpg
4. You can now Read 2DA and Write 2DA files using the File menu.
http://img.photobucket.com/albums/v170/tk102/xla4.jpg

Fred Tetra 09-23-2005 12:34 AM

Quote:

Originally Posted by tk102
v1.5 Released (Excel Add-In)

- Now uses ActiveWorkbook rather ThisWorkbook in macro (as per above)
- Distributed as an Excel Add-In (.xla) rather than a Module (.bas) file.

Excellent work!!!

I was going to try setting it up as an XLA; thanks for saving me the time! :D

tk102 09-23-2005 09:19 AM

Ooh Fred. That's a bad pun. :tsk:

Darkkender 09-23-2005 02:27 PM

But a deserving Pun. :p

tk102 09-27-2006 04:30 PM

v1.6 released (9/27/06)
- Eliminated need for tlbinf32.dll to be present on computer
- Made 2da writing much faster


All times are GMT -4. The time now is 02:03 PM.

Powered by vBulletin®
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
LFNetwork, LLC ©2002-2011 - All rights reserved.