Reading Variables from Excel?

Post » Wed Jan 05, 2011 3:33 pm

Basically just the topic-- is it possible to make Oblivion read a excel file, and update variables accordingly?

What I'm thinking is something like:
If ( GetGameLoaded )   Set Variable1 to ReadExcelLine 1 Column 2   Set Variable2 to ReadExcelLine 2 Column 8EndIf


Kind of thing, where I can ask it to read specific Columns/Line combinations.
User avatar
Andrea P
 
Posts: 3400
Joined: Mon Feb 12, 2007 7:45 am

Post » Wed Jan 05, 2011 1:36 pm

Not from Excel files as far as I know, but you can use the function http://cs.elderscrolls.com/constwiki/index.php/RunBatchScript to read and execute script from a text file (an .ini, basically), and use the text file to store your variables. Not quite as pretty, but it does give you a way to set variables from outside the plugin and game.
User avatar
Margarita Diaz
 
Posts: 3511
Joined: Sun Aug 12, 2007 2:01 pm

Post » Wed Jan 05, 2011 7:54 pm

Thanks for the response :) I know about RBS already-- as you say it's not ovelry pretty (and can get a little confusing), hence my curiosity; thanks again, however :)

Hmm, an idea just struck me: Diablo 2 uses .txt files which can be read as Tabbed Deliminated(?) in Excel-- maybe I can utilise the same, getting both effects :)
User avatar
Carlos Vazquez
 
Posts: 3407
Joined: Sat Aug 25, 2007 10:19 am

Post » Wed Jan 05, 2011 8:59 am

You could use Pluggy's INI file commands.

INI files are divided in sections, which are composed of key-value pairs, making them pretty much a 2-dimentional array, like a spreadsheet. (the file, itself. could be considered a third dimension).

It should be easy to use Excel VB for exporting the data to an INI file, if you already have a spreadsheet.
User avatar
Tessa Mullins
 
Posts: 3354
Joined: Mon Oct 22, 2007 5:17 am

Post » Wed Jan 05, 2011 1:41 pm

I am not familiar with those commands, but it sounds potentially useful :)

Are there any known issues/major problems with Pluggy? From what I recall, it seemed to be OK (if memory serves, Kurtee's Stats bars used it), but I've not looked into it, really.
User avatar
Yvonne Gruening
 
Posts: 3503
Joined: Mon Apr 23, 2007 7:31 pm

Post » Wed Jan 05, 2011 8:29 am

Pluggy is fine. It used to have problems with its HUD functions, but I could not tell it they have been fixed or not. I don't use those functions and I've never had any problem with Pluggy.

There is a http://cs.elderscrolls.com/constwiki/index.php/Saving_OBSE_arrays_into_Pluggy_INI_files
User avatar
Prue
 
Posts: 3425
Joined: Sun Feb 11, 2007 4:27 am

Post » Wed Jan 05, 2011 9:25 am

It used to have problems with its HUD functions, but I could not tell it they have been fixed or not.

In a sense yes and in a sense no. HUD functionality still causes crashes for some users, however v125 and above allow users to turn it off. Of course, reading an ini/text file doesn't require HUDs, so it shouldn't be an issue.
User avatar
Luis Longoria
 
Posts: 3323
Joined: Fri Sep 07, 2007 1:21 am

Post » Thu Jan 06, 2011 12:24 am

Thank-you guys, that sounds much-more user-friendly than the current files I've been using :D
User avatar
Georgia Fullalove
 
Posts: 3390
Joined: Mon Nov 06, 2006 11:48 pm


Return to IV - Oblivion