playMaker

Author Topic: How to read data from an Excel / CSV File  (Read 6425 times)

Alatriste

  • Full Member
  • ***
  • Posts: 193
How to read data from an Excel / CSV File
« 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!

4ppleseed

  • Full Member
  • ***
  • Posts: 226
Re: How to read data from an Excel / CSV File
« Reply #1 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

Alatriste

  • Full Member
  • ***
  • Posts: 193
Re: How to read data from an Excel / CSV File
« Reply #2 on: September 29, 2016, 03:50:45 AM »
Thanks a lot! That's exactly the kind of tool I was looking for!

Alatriste

  • Full Member
  • ***
  • Posts: 193
Re: How to read data from an Excel / CSV File
« Reply #3 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.

jeanfabre

  • Administrator
  • Hero Member
  • *****
  • Posts: 15500
  • Official Playmaker Support
Re: How to read data from an Excel / CSV File
« Reply #4 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

4ppleseed

  • Full Member
  • ***
  • Posts: 226
Re: How to read data from an Excel / CSV File
« Reply #5 on: October 26, 2016, 09:26:01 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?

jeanfabre

  • Administrator
  • Hero Member
  • *****
  • Posts: 15500
  • Official Playmaker Support
Re: How to read data from an Excel / CSV File
« Reply #6 on: November 02, 2016, 04:56:06 AM »
Hi,

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

Bye,

 Jean