Ronnie, The go-to Excel creation solution for 4D is Pluggers' XL Plugin: https://www.pluggers.nl/product/xl-plugin/
On Thu, 13 Aug 2020 at 03:16, Tarawerkz via 4D_Tech <[email protected]> wrote: > Hi, > > I would like to ask if anyone is aware of a plugin or utility that can > quickly turnaround an export function where data from a 4Dv17.2 database > (Windows Server) > gets written directly into different worksheets inside ONE Excel document > template? > > The 2nd challenge is to identify the row-ID for each record and store it > on other worksheets in the Excel template every time the same record is > referenced. > Say for example, the first worksheet is titled “General” and contains > customer records and the starting row for the first customer record is row > 5. Subsequent worksheets would bear a row-ID column such that reference to > the same customer record would now be populated with “5” as the row-ID. > How can we identify this row-ID whilst populating the spreadsheet with a 4D > data export on the fly? > > Any pointers would be greatly appreciated. Thanks. > > Regards, > Ronnie > Tarawerkz > > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > New Forum: https://discuss.4D.com > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** -- ************************************************* CatBase - Top Dog in Data Publishing tel: +44 (0) 207 118 7889 w: http://www.catbase.com skype: pat.bensky ************************************************* ********************************************************************** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
