How do I put an excel spread sheet in

Get help using Construct 2

Post » Thu Jun 09, 2016 12:21 pm

I have a lot of info I would like to put into an array from a spreadsheet but not sure how to.

I have tried Rex's plug ins but can't get them to work it just downloads as a 7z file.

Any help would be great, cheers.
B
5
S
1
Posts: 35
Reputation: 445

Post » Thu Jun 09, 2016 9:18 pm

Try looking up "parsing", and see if there are any examples.

A method I've used before is as follows:

Export the spreadsheet as a .csv
Import it as a project file and read the contents with AJAX (or alternatively load it from disk via nw.JS)
Parse the values you need by using the tokenat expression, using newline and commas as your token separators
(You may also want to use the replace() system expression to take out all the quotations marks in your file if you have them).
Mistakes were made.
B
49
S
24
G
107
Posts: 1,581
Reputation: 60,303

Post » Sat Jun 11, 2016 12:04 am

I have a Java program that parses all of our spreadsheets from csv files into a nice Json file.
But "parsing" is the short answer.
https://www.ravenheart.ca/home
Company name changed to avoid Facebook-type shenanigans

"Someone once told me I bite off more than I can chew...

I told them I would rather choke on greatness than nibble on mediocrity."
B
22
S
6
G
1
Posts: 1,414
Reputation: 4,822


Return to How do I....?

Who is online

Users browsing this forum: davidbox, Mayfly and 6 guests