Hallo Steve,
I used 4D HTML Tag using xlsx file or old excel xml file and it work fine.
You can build your own graphic in an excel document, save it in xml. Open the 
file withe a text editor like text wrangler replace the cell values with 4D 
HTML TAG. You can 4DTEXT and the powerful 4DLOOP if you have table with array 
and 4DIF for any condition you have. Write your method open your template file 
fill all your variables and arrays that are in the file then use the command 
“PROCESS 4D TAGS”, save all in the new document and that’s it!
I used also a method that write the file directly in xlsx, but it is more 
complex because you have to know all the xml structure and attribute values.

Andrea


> Il giorno 18 ott 2016, alle ore 06:35, Steve Makohin <stevemako...@gmail.com> 
> ha scritto:
> 
> Does anyone know how to populate a formatted Excel spreadsheet using 4D, and
> do so under 4D's control? My preferred method is to have 4D replace "tags"
> in the spreadsheet with its own values. I'd also prefer if someone already
> has the code to do this. I'll be coding in v14.
> 
> I've written a sophisticated Excel spreadsheet generator for another client,
> but I'm wondering if there's an easier, simple way to go about this when the
> spreadsheet is of a known, fixed format.
> 
> -Steve
> 
> **********************************************************************
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **********************************************************************

**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**********************************************************************

Reply via email to