Hi Steve, I wrote some method that create an xlsx file that insert also a picture inside that a can share if you want. It Works fine with Number, Open Office and LIbreOffice, but I got some problems between the different versions of EXCEL. The problems depend on difference in the use of attributes that should be tested in excel. Unfortunately there is not a lot of documentation in how they have to use in Excel. That’s the reason because if I have a complex excel file I still use the 4D TAGS. Excel wrote for me the correct file and I don’t need to debug it for all version of Excel. Actually the method can create a simple catalog in an Excel file with text and 1 picture for each row.
Andrea > Il giorno 20 ott 2016, alle ore 02:06, Steve Makohin <[email protected]> > ha scritto: > > 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:[email protected]] 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 >> <[email protected]> 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:[email protected] > ********************************************************************** ********************************************************************** 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:[email protected] **********************************************************************
