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 < [email protected]> 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 <[email protected]>: > > > 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 < > > [email protected]> 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 > >> [email protected] > >> Please visit this url to subscribe, unsubscribe and manage your > >> subscription preferences: > >> http://lists.runrev.com/mailman/listinfo/use-livecode > >> > > _______________________________________________ > > use-livecode mailing list > > [email protected] > > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > > > > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
