Playmaker Forum

PlayMaker Help & Tips => PlayMaker Help => Topic started by: Alatriste on September 28, 2016, 09:54:41 AM

Title: How to read data from an Excel / CSV File
Post by: Alatriste on September 28, 2016, 09:54:41 AM

Hi guys,

I want to start my next Playmaker project and I think I'd need to work with some tables to handle big chunks of text, to play under different situations. I was thinking to do it in a excel table and then... somehow, read it from Playmaker.

I was looking in the forum and I was reading about hash tables and that kind of things, but not sure if it's what I need/want.

Any ideas about how to do it?

Thanks!

Title: Re: How to read data from an Excel / CSV File
Post by: 4ppleseed on September 28, 2016, 10:06:16 AM

This Asset does what you're after (with Google Spreadsheets) and has built in Playmaker Support:

https://www.assetstore.unity3d.com/en/#!/content/11818 (https://www.assetstore.unity3d.com/en/#!/content/11818)

Title: Re: How to read data from an Excel / CSV File
Post by: Alatriste on September 29, 2016, 03:50:45 AM

Thanks a lot! That's exactly the kind of tool I was looking for!

Title: Re: How to read data from an Excel / CSV File
Post by: Alatriste on October 26, 2016, 06:14:31 AM

Just an update on this as I saw today the following tweet from Jean Fabre:

New Csv Support for @HutongGames #PlayMakerEcosystem via DataMaker thanks to @Frozax parser https://www.frozax.com/blog/2015/08/csharp-csv-reader-unity/ … with Csv to Xml action

I'll have to investigate how to use it.

Title: Re: How to read data from an Excel / CSV File
Post by: jeanfabre on October 26, 2016, 09:24:15 AM

Hi,

 Wrapping up a small sample to show how, it's simple. you use ReadCsv Action, give it a reference ( like ArrayMaker), and then you can get fields by index, or by header key.

Bye,

 Jean

Title: Re: How to read data from an Excel / CSV File
Post by: 4ppleseed on October 26, 2016, 09:26:01 AM

Quote from: jeanfabre on October 26, 2016, 09:24:15 AM

Hi,

 Wrapping up a small sample to show how, it's simple. you use ReadCsv Action, give it a reference ( like ArrayMaker), and then you can get fields by index, or by header key.

Bye,

 Jean

Without the Datamaker package installed?

Title: Re: How to read data from an Excel / CSV File
Post by: jeanfabre on November 02, 2016, 04:56:06 AM

Hi,

It's the same basically, DataMaker comprise Csv feature.

Bye,

 Jean