XLS files

[Bibin]

I need to read from an XLS file for a quiz game.

I really want to be able to read it just like I would an array- specify the X Y of the cell and recieve the string data.

Is this possible?

[vortex2]

Not to my knowledge but you could save the .xls file as a .csv file and then load it into Associative Array or something...

[Horn]

I think it might be possable using activeX object,if you have ms-office installed.

[DavidN]

Can't the ODBC object do this? Not sure how well it works, though.

[neat_Kliker2]

"Can't the ODBC object do this? Not sure how well it works, though."
you need excel to be installed so the CSV odbc driver is added, or from what I remember there is a small free seperate download for the driver

[DavidN]

Yes, I just tried it and couldn't even get my head round it at all. I would probably suggest using a plainer format like CSV, as XLS files have a whole lot of additional data that you really don't need. You can even edit it in XLS and export it to CSV as needed if that's the problem.

[Bibin]

The problem is, I've been hired to make a game, and I need to read form XLS files. I'm not buying word/excel/office junk also.

Am I screwed?

[vortex2]

Why does it have to be XLS files? Why can't you just open them up in word and re-export them? It would take less then a minute...

You could even export as XML and then read it using my EasyXML extension..

If you have to use XLS files then you could hire someone to write an extension or something for you..

[neat_Kliker2]

and also can I say that although MMF2 is a great product and is very flexable, you cant do everything with it.... Dont agree to work on something you know cant be done

[Sphax]

XLS files have never be used for Games...