Steve: I wrote code to generate Excel-compatible documents using XML. The code works fine but the files that it creates get pretty large. I was able to insert formulas on the fly but couldn't create workbooks.
A couple of years ago, I looked around for a way to create more robust documents and started using the plugin from Pluggers. The plugin gives me a tremendous amount of control over the output and, like all of the other products from Pluggers, it was money well spent. -- Douglas von Roeder 949-336-2902 On Wed, Oct 19, 2016 at 5:06 PM, Steve Makohin <stevemako...@gmail.com> wrote: > 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 > ********************************************************************** > ********************************************************************** 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 **********************************************************************