[Newbies] Is it possible to manipulate excel spreadsheet by squeak

[Xinyu Liu]

Hi,

Thanks a lot. I think using XML instead of Excel is reasonable for me.
Those Excel files with complex VBA macros are terrible.

Best regards.
Yours,
-Liu

On 9/7/07, johnps11 at bigpond.com <johnps11 at bigpond.com> wrote:
>
> > The new XML based format may be easier to parse / write using YAXO
>
> As someone who has done this stuff (though not from Squeak), Good Luck
> with OOXML.  It's very fragile, and appears to break for no apparent
> reason.  I suggest you either use a library (as others have suggested) or
> use Oo.org as a conversion engine, and work with the XML in that format,
> then use OO.org again to write back to excel.  The degree of success you
> will get with any approach will be inversely related to the documents
> complexity - complex excel documents get very wierd with anything but
> Visual Basic (which is wierd to begin with).
>
> John
>
>
>
> >
> >
> > On 9/6/07, David Mitchell <david.mitchell at gmail.com> wrote:
> >> Nothing that directly reads/writes the file format. Mostly, I've seen
> >> CSV, clipboard, and discussion of XML.
> >>
> >> There is a .net bridge that you could use to VBA but that would
> >> require Excel to be running.
> >>
> >> The fastest route would be to find a C library and then call it.
> >>
> >> On 9/6/07, Xinyu Liu <liuxinyu95 at gmail.com> wrote:
> >> > Hi,
> >> >
> >> > Can I use squeak to create, write, and read excel spreadsheet?
> >> > Just like ParseExcel and WriteExcel module in PERL.
> >> >
> >> > Best regards.
> >> > Liu
> >> >
> >> > _______________________________________________
> >> > Beginners mailing list
> >> > Beginners at lists.squeakfoundation.org
> >> > http://lists.squeakfoundation.org/mailman/listinfo/beginners
> >> >
> >> >
> >> _______________________________________________
> >> Beginners mailing list
> >> Beginners at lists.squeakfoundation.org
> >> http://lists.squeakfoundation.org/mailman/listinfo/beginners
> >>
> > _______________________________________________
> > Beginners mailing list
> > Beginners at lists.squeakfoundation.org
> > http://lists.squeakfoundation.org/mailman/listinfo/beginners
> >
>
>
> _______________________________________________
> Beginners mailing list
> Beginners at lists.squeakfoundation.org
> http://lists.squeakfoundation.org/mailman/listinfo/beginners
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/beginners/attachments/20070907/3e973c44/attachment.htm