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: 37
Reputation: 449

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
52
S
26
G
108
Posts: 1,605
Reputation: 61,131

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
I don't check the forums much anymore, but I will receive an email for PMs.

"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,418
Reputation: 4,830


Return to How do I....?

Who is online

Users browsing this forum: No registered users and 28 guests