On Dec 12, 2019, at 2:00 PM, Kirk wrote: > (Environment: All Windows, 4D server/client 16R4) > > Just curious if anyone has found a way to automatically transform Excel > documents to text-tab delimited documents? > > The issue I am attempting to solved: We have several system which produce > document that need to be imported into a 4D application. Some of these > systems produce Excel documents. To standardize I would like to > automatically transform these Excel docs into a Text-Tab delimited doc. This > would need to be logic triggered by 4D. (e.g. 4D identifies the doc as Excel > and "does something" to transform to text-tab before import.) > > Any thoughts? > > Thanks in advance for the consideration and help!
Get Rob’s Excel plugin. You can read and write Excel files with a crazy level of detail. Once you have it, you’ll find so many uses for it. It is worth the €600,00 for the cross platform license. https://www.pluggers.nl/product/xl-plugin/ Another option is the wonderful world of php and using one of the Excel file reader libraries. (But it could take you a while to get it into a shape where it works with 4D. Not all php libraries are drop-in-and-work with 4D. You may have to tweeks some of the files.) https://github.com/nuovo/spreadsheet-reader Or you could try one of the online services that will do this for you and try to build an automated way to interact with the website and make it happen. Also challenging. https://www.zamzar.com/convert/xlsx-to-txt/ Tim ***************************************** Tim Nevels Innovative Solutions 785-749-3444 [email protected] ***************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
