Page 1 of 1
OFFICE Interaction
Posted: Mon Jul 27, 2020 8:02 pm
by ArtBlink
Hello,
Can is it possible to extract hollywood table in Excel format?
Thanks
Re: OFFICE Interaction
Posted: Tue Jul 28, 2020 7:17 pm
by SamuraiCrow
CSV format can be imported by many spreadsheets including Excel. The only thing that would trip it up is if the value for one key is another table.
A table is just a value for every key and sometimes tables can be nested as I pointed out above. Probably the best format to represent it as would be a JSon file and view it from there. If that's the case it would be better imported into a database like Access instead of Excel.
JSon file exporting and importing has been promised in the next version of Hollywood already.
Re: OFFICE Interaction
Posted: Tue Jul 28, 2020 9:51 pm
by Bugala
And before Hollywoods new version is available, you can try Clydes JSON parser for Hollywood:
viewtopic.php?f=7&t=2240&p=12328&hilit=json#p12328
I am actually planning on trying it soon myself too.