Import data from an Excel file?

Hello, I own Excel 2013 and I'd like to know if I can import data from a spreadsheet.

As an example I attached a screenshot of what I am thinking.

Save that file in CSV format and use Dynamic Array Object to load it into your Fusion app.

I found this little app, haven't tried it myself but it might come in handy http://www.create-games.com/download.asp?id=8360

You can export to CSV in Excel and import with the Ini+ Extension.

@Ran_TH and Vaxx: Thank you for your suggestions!

I am not sure if those plugins are compatible on Android.

Is there another solution? Standard XLS-files? CSV-files?

I can create XLS files using a VB script in my application. However, since it is android, the vb script won't work. Is the listview object compatibile. If you use a delimiter as a tab " " as save as a ascii file, you can save as extension .csv file.

I am not sure if the listview object is compatible though

Also, if you save the excel file as a CSV file and use the listview object, it should open up

Use the program posted above which allows you to save to an Array file, which of course is compatible with Android and iOS. I recently made a post asking about this, and I posted about what I found too. However, I think you should use Excel 2003/2007. I'm not sure if the latest versions work as you must create XML spreadsheets, but you can use Open Office.

Hi Fetito,
If exporting a CSV file from the Excel file is conceivable, it's probably the easiest and most stable solution. Now if you need to have only one file used both by Excel and the MMF's application, there are some options:

• The first, it's possible to read from and write to an Excel file using ODBC. It's not really easy, in addition the MS Excel ODBC driver supports just a rough base of SQL statements, but it's working.
• Since a while, Excel can work with XML file (not XLSX but XML), and having two XML extensions in MMF, this could be another option in some cases.
• Then finally using different extensions (to pack/unpack, process XML and so on), it should be possible to process XLSX file from MMF.

ouly

@ouly: thank you!

I want MMF 2.5 just to read the database file, I do not want to change its values. So, a CSV-file would be the most elegant solution? Do I have to take care about unicode, UTF-8 or something like that?

To give you more details: I want MMF ONLY to read values for enemies such as HPs, XPs, special attacks. MMF should read a value and assign it to an internal MMF variable. I do NOT want MMF to write into the CSV-file.

That way I can modify easyily the statistics for my game within Excel 2013.

For savegames I will use another MMF-extension, because I do not want it to end up in that CSV-file.

PS: Will that CSV file be compiled in the whole installation package in the end?

I remember there being a Com+ object in MMF2 Dev with an Excel example. It looks like this hasn't yet been ported to MMF2.5 otherwise you could do all of this with Com+