how to convert .csv to .xlsx with LC without Excel installed?

[Matthias Rebbe | M-R-D]

Ah, now i understand what you meant.

The new .xlsx files  are not just .xml files. Prior to Excel 2007 they used to be just xml.
But with Excel 2007 and higher they are zip-archives (with .xlsx extension) now which contain a little bit more than just an xml file. They are now in the OpenOffice XML format (ECMA-376).

Regards,

MAtthias

Am 10.03.2014 um 16:12 schrieb Roger Eller <roger.e.eller at sealedair.com>:

> 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_150811 at 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.eller at 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_150811 at 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 at 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 at 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 at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode