Hi Andrea, Thank you for your reply.
You describe what I've been doing as my "rolled my own" solution. I was wondering if someone else had come to a simpler or more elegant solution. -Steve -----Original Message----- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Andrea Angeli Sent: Tuesday, October 18, 2016 11:52 AM To: 4D iNug Technical Subject: Re: How do you populate an Excel spreadsheet using 4D? 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 **********************************************************************