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

[Roger Eller]

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
>