Re: Import from Excel file

Ferdinando, Export it to CSV in Excel and then import the text file. > On Apr 22, 2024, at 3:36 AM, stardata.info via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi all, > > I use 4D V19, i need to import data from some excell files without use a form > with a 4D View Pro area. > > Someone k

Re: Import from Excel

Hi Tim, Just tried the Tech Note using v16 without success. Apparently PHPExcel is deprecated. It’s successor is PHPSpreadsheet at: https://github.com/PHPOffice Could you possibly do a new edition of your Tech Note using PHPSpreadsheet and v16? Best regards, Jer

Re: Import from Excel

Pat, > Yes ... We wrote a procedure to import csv files. My point was that you can't > just use the basic 4D Import option to import such files. We don’t use 4D’s import, so I can’t comment on whether it works correctly or not. Chip, > >> the problem I have found with csv is that different sof

Re: Import from Excel

the problem I have found with csv is that different software creates different formats. sometimes, everything is quoted, sometimes only certain values are quoted, and similar to the problem of a tab delimited text file, if the text contains a equation mark(s) everything gets screwed. In my Txtu

Re: Import from Excel

Pat, As I understand it, in a cvs file, all string values should be enclosed inside “. This means that a CR is simply part of the cell’s string. If you open the exported file with a text editor, you should see the CR enclosed inside “. If it isn’t, the Excel export is not working correctly. If it

Re: Import from Excel

F.Y.I. I've posted a "Match regex" solution to process CSV (read and write). quotes, carriage returns, missing columns and other perks are handled. https://github.com/miyako/4d-component-csv in general, it is easier if you could use TSV instead of CSV, as the format is more compatible with the s

Re: Import from Excel

When exporting to csv from Excel, the cells that contain commas, double quotes and/or carriage returns will be wrapped by double quotes. The routine that is used to import csv file should be paying attention to the surrounding quotes and handling embedded returns. Any internal double quotes are

Re: Import from Excel

Keith - if you export from Excel to csv, you still have the problem with embedded Return characters. Pat On 7 March 2018 at 20:48, Keith Goebel via 4D_Tech <4d_tech@lists.4d.com> wrote: > Ferdinando , > If you convert the Excel file to csv, you shouldn't have any problems with > cells containin

RE: Import from Excel

Ferdinando , If you convert the Excel file to csv, you shouldn't have any problems with cells containing carriage returns/line feeds when you import into 4D. I assume 4D’s built-in import can handle csv files - I haven’t checked - we use special import and export code to handle csv so we don’t us

Re: Import from Excel

Thanks /Ferdinando/ Il 07/03/2018 18:15, Timothy Penner ha scritto: I am not sure if it still works, but there is this tech note available: Tech Note: PHPExcel Library with 4D v12 Published On: April 15, 2011 http://kb.4d.com/assetid=76312 -Tim PENNER Timothy Penner Senior Technical Servic

Re: Import from Excel

Another vote for Pluggers Excel plugin. https://www.pluggers.nl/product/xl-plugin/ You will not regret it for creating and reading excel files it is simply the best, just as you would expect from Pluggers. For my usage it has paid for itself over and

RE: Import from Excel

I am not sure if it still works, but there is this tech note available: Tech Note: PHPExcel Library with 4D v12 Published On: April 15, 2011 http://kb.4d.com/assetid=76312 -Tim PENNER ** 4D Internet Users Group (4D iNUG) FAQ:

Re: Import from Excel

If you are using Numbers on a Mac, there is no way to export to a tab delimited text file, only CSV. Many have complained, but Apple does not listen. The work around is to select the content to be exported in Numbers and copy it to the clipboard. Then past into a plain text TextEdit document. Th

Re: Import from Excel

No need to export. Save as a text file and you can import that Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmillerinformed-solutions

RE: Import from Excel

Hi Ferdinando, I second Pat Bensky's suggestions of Rob Laveaux's Pluggers EXCEL Plugin. http://www.pluggers.nl/product/xl-plugin There is a reasonable cost for this plugin, but it provides serious capabilities to work with Excel files. This is what we use exclusively. As well there are some fr

Re: Import from Excel

We use Pluggers Excel plugin - works really well for both importing and creating Excel documents: https://www.pluggers.nl/product/xl-plugin/ The problem with exporting form Excel to a text file is if any of the cells contain return or line feed characters, that will mess everything up as 4D will t

Re: Import from Excel

Hi Ferdinando, Export from Excel to text file (comma delimited, tab delimited). And then use the 4D import tool or write your own code (receive packet,…) HTH Koen > Op 7 mrt. 2018, om 11:06 heeft stardata.info via 4D_Tech > <4d_tech@lists.4d.com> het volgende geschreven: > > I use 4D V15 or