D2Excel Plus

This would be the forum for questions about how to work with mod making tools which can be a problem of its own.

Moderator: Paul Siramy

Post Reply
cjreek
Posts: 8
Joined: Tue Feb 19, 2019 9:17 pm

D2Excel Plus

Post by cjreek » Tue Feb 19, 2019 9:33 pm

Hi,

So after starting to mod again after a lot of years I couldn't really get Excel not to f**** up my d2 .txt files.
I used the commonly used D2Excel tool which worked, but I found it was missing a lot of quality of life features.
So I made my own D2Excel and called it D2Excel Plus (because I'm bad with names).

Image


Features
D2Excel Plus v0.91
================================================================================
(C) 2019 Cjreek

FEATURES:
--------------------------------------------------------------------------------
- Open a whole folder (workspace) with all your .txt files for easy access
- Drag&Drop files into the program to load them
- Edit multiple files at once (tabbed layout)
- Undo/Redo
- Multiselect/Multiedit
- Search functionality
- Fix the first X columns to keep track of the current row when scrolling to the right
- Alternating row colors for readability
- delete/append/insert and copy rows
- Handy shortcuts for editing:
* Delete = Empty cell
* Ctrl + Delete = Delete selected row
* Ctrl + + = Increment cell value by 1
* Ctrl + - = Decrement cell value by 1
* Escape = Cancel/Undo changes while editing a cell
* Ctrl + C = Copy cell contents to clipboard
* Ctrl + X = Copy cell contents to clipboard and empty selected cell (cut)
* Ctrl + V = Paste clipboard to selected cell
* Ctrl + Z = Undo
* Ctrl + Y = Redo

FILES:
--------------------------------------------------------------------------------
D2Excel Plus saves some settings in the following files:

- %appdata%\D2ExcelPlus\settings.ini

%appdata% (usually) refers to the following path:
C:\Users\<Username>\AppData\Roaming
with <Username> being the currently logged on windows user

Download

Download
Source Code

The code can be compiled with the current free community edition of Delphi without any 3rd party libraries.
Last edited by cjreek on Tue Feb 08, 2022 10:02 pm, edited 9 times in total.

jessedazebra
Junior Member
Paladin
Posts: 144
Joined: Sun Nov 11, 2012 9:46 am
Zimbabwe

Re: D2Excel Plus

Post by jessedazebra » Tue Feb 19, 2019 10:13 pm

Wow, this is a great replace for this hateful classic excel. Especially locking first column really helps. Source code would be appreciated as well, I'd edit some stuff for my liking only. Thanks. :)

cjreek
Posts: 8
Joined: Tue Feb 19, 2019 9:17 pm

Re: D2Excel Plus

Post by cjreek » Tue Feb 19, 2019 10:46 pm

jessedazebra wrote:
Tue Feb 19, 2019 10:13 pm
Wow, this is a great replace for this hateful classic excel. Especially locking first column really helps. Source code would be appreciated as well, I'd edit some stuff for my liking only. Thanks. :)
Thanks!
I'll probably release the code tomorrow then and after talking to someone in discord there are also some more features I am going to add in the near future (probably until the weekend).
A lot of multi select and math stuff.

jessedazebra
Junior Member
Paladin
Posts: 144
Joined: Sun Nov 11, 2012 9:46 am
Zimbabwe

Re: D2Excel Plus

Post by jessedazebra » Tue Feb 19, 2019 11:07 pm

Also, there's a suggestion: is it possible to update stringgrid live while dragging the scroll bar with left click? It updates as it should with mouse wheel, but when you use left click + drag stringgrid updates only when left click button is released.
Image

cjreek
Posts: 8
Joined: Tue Feb 19, 2019 9:17 pm

Re: D2Excel Plus

Post by cjreek » Tue Feb 19, 2019 11:16 pm

I've fixed the scrolling.
The download link (google drive) in the main post was updated.

jessedazebra
Junior Member
Paladin
Posts: 144
Joined: Sun Nov 11, 2012 9:46 am
Zimbabwe

Re: D2Excel Plus

Post by jessedazebra » Tue Feb 19, 2019 11:20 pm

Yeah, now it's working great. Thanks again.

User avatar
andsimo
Dark Alliance Beta Test
Crusader
Posts: 57
Joined: Fri Oct 06, 2006 3:38 pm
Contact:
Christmas Island

Re: D2Excel Plus

Post by andsimo » Wed Feb 20, 2019 6:04 am

great job, more comfortable than D2Excel
mods observer

fty
Posts: 8
Joined: Thu Aug 19, 2010 8:34 am

Re: D2Excel Plus

Post by fty » Wed Feb 20, 2019 5:13 pm

cjreek wrote:
Tue Feb 19, 2019 9:33 pm
So I made my own D2Excel and called it D2Excel Plus
Thanks! It's so cool that such talented people return to modding D2.

User avatar
mmpx222
Junior Member
Paladin
Posts: 154
Joined: Sat Apr 26, 2014 9:19 am
Korea South

Re: D2Excel Plus

Post by mmpx222 » Wed Feb 20, 2019 6:51 pm

cjreek wrote:
Tue Feb 19, 2019 9:33 pm
- Alternating row colors for readability
(...)
- Search functionality
You just won me over. Well, about 80%.

Does it support undo (Ctrl+Z) / redo ( Ctrl+Y)? How long is the undo/redo history?

Also, have you considered posting your project on GitHub?
D2TXT / D2INI - Python scripts for editing TXT files, or converting between TXT ↔ INI files

cjreek
Posts: 8
Joined: Tue Feb 19, 2019 9:17 pm

Re: D2Excel Plus

Post by cjreek » Wed Feb 20, 2019 7:59 pm

mmpx222 wrote:
Wed Feb 20, 2019 6:51 pm
Does it support undo (Ctrl+Z) / redo ( Ctrl+Y)? How long is the undo/redo history?
Not yet, but I'll probably add that feature in the future. Maybe until the weekend (can't promise anything though).
mmpx222 wrote:
Wed Feb 20, 2019 6:51 pm
Also, have you considered posting your project on GitHub?
https://github.com/Cjreek/D2ExcelPlus

cjreek
Posts: 8
Joined: Tue Feb 19, 2019 9:17 pm

Re: D2Excel Plus

Post by cjreek » Sun Feb 24, 2019 3:37 pm

I've just commited and uploaded a new version (0.91)!

For a list of changes read this:
https://github.com/Cjreek/D2ExcelPlus/b ... DME.md#091

I've updated the google drive download link in the original post.

User avatar
mmpx222
Junior Member
Paladin
Posts: 154
Joined: Sat Apr 26, 2014 9:19 am
Korea South

Re: D2Excel Plus

Post by mmpx222 » Mon Feb 25, 2019 4:34 am

cjreek wrote:
Sun Feb 24, 2019 3:37 pm
I've just commited and uploaded a new version (0.91)!

For a list of changes read this:
https://github.com/Cjreek/D2ExcelPlus/b ... DME.md#091

I've updated the google drive download link in the original post.
Awesome. BTW how long is the undo/redo history? AFJ Sheet Edit has only ~3 max undos, I believe, which is not a lot.

Also, why not use GitHub Releases to host the ZIP file(s)?
D2TXT / D2INI - Python scripts for editing TXT files, or converting between TXT ↔ INI files

cjreek
Posts: 8
Joined: Tue Feb 19, 2019 9:17 pm

Re: D2Excel Plus

Post by cjreek » Mon Feb 25, 2019 10:35 am

BTW how long is the undo/redo history?
Currently infinite. I'm not sure about usual undo/redo behaviour, but I'm clearing the redo stack as soon as you're making new changes to the file. Otherwise it gets weird. So if anyone wants to tell me whether the undo/redo function feels right or if there's anything wrong/strange with it, I'd be really glad.
Also, why not use GitHub Releases to host the ZIP file(s)?
I'm pretty much new to github so this didn't even occur to me :D.
I'll check this out later when I'm at home.

Lanboost
Posts: 12
Joined: Wed Aug 26, 2020 12:05 pm
United States of America

Re: D2Excel Plus

Post by Lanboost » Wed Sep 15, 2021 6:24 pm

Is the link broken or is it just me? I can't seem to download it because the page is just blank.

User avatar
Necrolis
Senior Admin
Throne
Posts: 9125
Joined: Sat Mar 25, 2006 1:22 pm
Location: The Land of the Dead
Contact:
South Africa

Hand-picked

Re: D2Excel Plus

Post by Necrolis » Thu Sep 16, 2021 11:12 am

Lanboost wrote:
Wed Sep 15, 2021 6:24 pm
Is the link broken or is it just me? I can't seem to download it because the page is just blank.
Both links are working. For Google Drive downloads there is a button top right to download the folder you are viewing.
Image
Netiquette, Do you USE it?!?! | Nefarius' Fixed TXT Files | Terms Of Service
Blackened | Day of Death | D2GFEx
"What was yours is mine. Your land, your people, and now your life." - Lim-Dul, the Necromancer
Judgement is Final, Death is Eternal

User avatar
Grimalken
Posts: 3
Joined: Wed Oct 06, 2021 11:32 pm

Re: D2Excel Plus

Post by Grimalken » Sat Oct 09, 2021 5:41 pm

I'm new here, and know a lot of you guys have been doing this for years. I downloaded the program. It runs fine. To see if I'm doing this correctly I tested it. I opened "weapons.txt" in my [C:\Program Files (x86)\Diablo II Resurrected\Data\global\excel] directory. I changed the Hunter's Bow "2handmindam" to 5 and "2handmaxdam" to 10. Saved, closed d2excel Plus, ran the game, and the gambled for the bow and it is still 2-6 damage. Am I doing something wrong?

Oh I was also following this video, and did use CascView to copy over Global, HD and Local

Oh, I am only playing offline characters. The weapons.txt / bin are in the "C:\Program Files (x86)\Diablo II Resurrected\Data\global\excel" directory. I made sure the launcher ran with the "–direct –txt" additional command line. Just edited the file again, the text file was modified because it has the current time, but after starting the game, which should have updated the bin file, the bin file has same time stamp as all the other bin files.

User avatar
Grimalken
Posts: 3
Joined: Wed Oct 06, 2021 11:32 pm

Re: D2Excel Plus

Post by Grimalken » Sun Oct 10, 2021 3:43 am

Okay, i figured out was what going on. Or, I mean a friend figured it out for me. He looked at my Battelnet launcher, and the command line i was using, and commented that my dashes looked odd. He was correct. You see, earlier I was reading a internet blog of someone describing what to do, and I just highlighted his "–direct –txt." He was using an oddball font, so when I pasted this into the launcher it didn't recognize the dash that he used with his font.

If it looks like a duck, and quacks like a duck... it still might not be a duck. :oops:

cjreek
Posts: 8
Joined: Tue Feb 19, 2019 9:17 pm

Re: D2Excel Plus

Post by cjreek » Tue Feb 08, 2022 10:08 pm

I just released a small update (0.92):

- Fixed overwriting too many cells when pasting (i.e. 2 cells where copied, 3 where pasted)
- Fixed not being able to open multiple files with the same file name
- Locking/unlocking columns now preserves the selection and cursor position instead of jumping to the top left

I also made a release on github, instead of linking to my google drive.
If anyone has some ideas or suggestions for improvements or bugs to report I'd gladly try to include them in the next version.
I've found new motivation after D2R so I might develop this tool some more.

Download 0.92: https://github.com/Cjreek/D2ExcelPlus/r ... ag/D2EP092

d2dad
Posts: 5
Joined: Wed Jan 13, 2021 4:04 am
United States of America

Re: D2Excel Plus

Post by d2dad » Wed Mar 23, 2022 9:13 pm

Hey cjreek,

Thanks for the awesome work on creating this tool! I have been using it for a while and absolutely love it. I might be missing something here, but I need to add tons of rows to some files and right-clicking and selecting "Append" takes for ever for hundreds of rows. Would it be possible to add a new hotkey like ctrl+A so I can quickly add my rows wherever I'd like? Thanks!!

Nevermind. Right-clicking the number cell + "A" accomplishes what I want :)

pastuh
Posts: 1
Joined: Sat Jun 04, 2022 10:52 pm
Lithuania

Re: D2Excel Plus

Post by pastuh » Sun Jun 05, 2022 12:25 pm

cjreek wrote:
Tue Feb 08, 2022 10:08 pm
If anyone has some ideas or suggestions for improvements or bugs to report I'd gladly try to include them in the next version.
Hi,
Added some feature requests in github. If you have time, please update.
Thanks a lot :!:

Post Reply

Return to “Tools”