Hollywood and Excel

Discuss any general programming issues here
Post Reply
ArtBlink
Posts: 435
Joined: Mon Nov 01, 2010 11:37 am
Location: Albert - France
Contact:

Hollywood and Excel

Post by ArtBlink » Sat Feb 17, 2018 10:08 am

Hello,

I make software with hollywood for my job, but i must converts hollywood data for use in microsoft excel.

Is it possible?

Thanks

SamuraiCrow
Posts: 159
Joined: Fri May 15, 2015 5:15 pm
Location: Ft. Collins, Colorado USA

Re: Hollywood and Excel

Post by SamuraiCrow » Sat Feb 17, 2018 11:28 am

Export to a csv file in Hollywood or better yet, look up Office Open XML format family and export to Excel's own format. The hard part is the formula cells which use their own format. Importing XML is aided by the XML Parser plugin so reading data from Excel is possible.

Note:
Excel format is zip compressed XML so you might need the Zip plugin to read and write the XML document.

ArtBlink
Posts: 435
Joined: Mon Nov 01, 2010 11:37 am
Location: Albert - France
Contact:

Re: Hollywood and Excel

Post by ArtBlink » Sat Feb 17, 2018 11:36 am

Excellent, i test it, no formula just data ;-)

Post Reply