Yes, that is why I said it gets you half way there. :) Your subject implies that you are starting from a CSV file, so I would expect that you could read the data into LC with Richards function, then export as XML. Rename the file with a .xlsx extension, and see what Excel thinks of it.
~Roger On Mon, Mar 10, 2014 at 11:00 AM, Matthias Rebbe | M-R-D < matthias_livecode_150...@m-r-d.de> wrote: > Thanks Roger, > > i already knew this article. This article is a "must read" for everyone > who exports data to a .csv file. > > I need to create a real .xlsx file, not a .csv which can be imported into > Excel. > > I have numeric fields with numbers with leading zeros. These numbers would > loose their leading zeros if imported as .csv into Excel. > > Regards, > > Matthias Rebbe > > > > Am 10.03.2014 um 15:23 schrieb Roger Eller <roger.e.el...@sealedair.com>: > > > Hi Matthias, > > > > This will get you half way there, thanks to Richard Gaskin and Alex > > Tweedly. I use this function to bring in CSV files all the time. Works > > great! > > > > http://www.fourthworld.com/embassy/articles/csv-must-die.html > > > > ~Roger > > > > > > On Mon, Mar 10, 2014 at 9:44 AM, Matthias Rebbe | M-R-D < > > matthias_livecode_150...@m-r-d.de> wrote: > > > >> Hi, > >> > >> i know there is Zryip´s really excellent Excel Library for Livecode. > >> But for some reason i need to convert a .csv file to .xlsx with > Livecode on > >> a machine where no Excel is installed or will be installed. > >> > >> Does anyone have already done this with Livecode and would like to > share > >> her/his > >> solution? > >> > >> Regards, > >> > >> Matthias Rebbe > >> > >> > >> > >> > >> _______________________________________________ > >> use-livecode mailing list > >> use-livecode@lists.runrev.com > >> Please visit this url to subscribe, unsubscribe and manage your > >> subscription preferences: > >> http://lists.runrev.com/mailman/listinfo/use-livecode > >> > > _______________________________________________ > > use-livecode mailing list > > use-livecode@lists.runrev.com > > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
