How to make/save an excel file with no data visualization?

[Jvan]

Namely, I have a JSON and I want to save its data (rows) in an excel file without showing it previously.

[bobonwhidbey]

Do you need a XLS file? I think it's a lot easier to work with a tStringlist and then just output a CSV file which, of course, is easily read by Excel.  For example:

Code: Pascal  [Select][+][-]

1. Var SL : Tstringlist;
2. begin
3.   SL := tstringlist.create;
4.   for i := 0 to 10
5.     SL.Add('Line,'+inttostr(i)+',Col C');  
6.   SL.SavetoFile('MyFile.csv');
7.   SL.Free;
8. end;

[TRon]

As stated by bobonwhidbey, for more details see https://support.microsoft.com/en-us/office/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba

[lainz]

Check the wiki there is an excel exporter.