Array Object and an .xls file

[ffomega]

I want to streamline an application that relies heavily on global values and global strings, and I want all of my data to be stored with a single spreadsheet.

The spreadsheet will have 6 sheets (presumed to be z values).

I am trying to figure out how to use the array object to load the .xls file upon startup of the application, then, but way of arrow keys, navigate one row at a time through a selected spreadsheet.

I'll have a few counters and edit boxes to display the currently selected row in each box/counter. The list will be edited externally so there is no need to save data from within MMF2.

Can anyone provide me with an example using the Array object, some edit boxes and an external .xls file?

Thank you

[LB]

The array object can not load xls files. It is designed to load CNC Arrays (an array format from Click'n'Create) which is nothing like Microsoft Excel's xls files. To load those, you would have to read up on the format and use a binary object to manually read/save the data. It's quite troublesome to do. :\

[ffomega]

I was hoping to avoid another ini file...as I use those as save/load files.

[MuddyMole]

Create/Open the spreadsheet in Excel, and then save it in .xml spreadsheet format instead of .xls - then you can use my Array Editor tool to convert it to an MMF2 array (and back again, if need be).

http://www.create-games.com/download.asp?id=8360

[rubes]

MuddyMole's utility has been a godsend for me and arrays in mmf

[ffomega]

alright I'd love to use this program...except that I cannot get it to work. no matter what i do I still cannot get it to recognize the extensions. I have b253b...should I downgrade to b252? What am I doing wrong that it keeps giving me the "cannot find EasyXML.mfx" both extensions are placed in the \data\runtime\ folder and the extension folder

[EDIT] Okay I fixed the problem. Apparently in order to run this application, you need to download "msvcp71.dll".

[MuddyMole]

You have build 253? I believe the latest beta version is only 252.

You don't need EasyXML.mfx (you don't even need to have MMF2 installed) - the required extensions are automatically embedded into the exe somehow.

I'd guess you're probably missing some windows .dlls that it relies on.
Someone else reported that it required msvcp71.dll & msvcr71.dll so maybe check that those are present in either the same folder as the exe, or windows/system32, or Windows\SysWOW64.

Otherwise, I don't know what the problem is.

[ffomega]

I meant that I had build 2.52beta with the built in HWA sorry for the confusion, but I got the program to work by downloading that dll file.

If anyone needs a copy please PM me and I'll send you the link I'm not sure if it's legal to post external links in this forum