Is it possible to manipulate excel spreadsheet by squeak
Locked
 
|
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 [hidden email] http://lists.squeakfoundation.org/mailman/listinfo/beginners |
Re: Is it possible to manipulate excel spreadsheet by squeak
|
|
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 <[hidden email]> 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 > [hidden email] > http://lists.squeakfoundation.org/mailman/listinfo/beginners > > Beginners mailing list [hidden email] http://lists.squeakfoundation.org/mailman/listinfo/beginners |
Re: Is it possible to manipulate excel spreadsheet by squeak
|
|
The new XML based format may be easier to parse / write using YAXO
On 9/6/07, David Mitchell <[hidden email]> 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 <[hidden email]> 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 > > [hidden email] > > http://lists.squeakfoundation.org/mailman/listinfo/beginners > > > > > _______________________________________________ > Beginners mailing list > [hidden email] > http://lists.squeakfoundation.org/mailman/listinfo/beginners > Beginners mailing list [hidden email] http://lists.squeakfoundation.org/mailman/listinfo/beginners |
Re: Is it possible to manipulate excel spreadsheet by squeak
|
|
> 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 <[hidden email]> 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 <[hidden email]> 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 >> > [hidden email] >> > http://lists.squeakfoundation.org/mailman/listinfo/beginners >> > >> > >> _______________________________________________ >> Beginners mailing list >> [hidden email] >> http://lists.squeakfoundation.org/mailman/listinfo/beginners >> > _______________________________________________ > Beginners mailing list > [hidden email] > http://lists.squeakfoundation.org/mailman/listinfo/beginners > _______________________________________________ Beginners mailing list [hidden email] http://lists.squeakfoundation.org/mailman/listinfo/beginners |
Re: Is it possible to manipulate excel spreadsheet by squeak
|
|
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1 Hi, Diego Gómez-Deck wrote a OpenOffice importer for Squeak some time ago (I don't have the link, but you can search about it). So a possible way could be OpenOffice importing of the excel files and then use the Diego code to open it in Squeak. Cheers, Offray [hidden email] 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 <[hidden email]> 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 <[hidden email]> 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 >>>> [hidden email] >>>> http://lists.squeakfoundation.org/mailman/listinfo/beginners >>>> >>>> >>> _______________________________________________ >>> Beginners mailing list >>> [hidden email] >>> http://lists.squeakfoundation.org/mailman/listinfo/beginners >>> >> _______________________________________________ >> Beginners mailing list >> [hidden email] >> http://lists.squeakfoundation.org/mailman/listinfo/beginners >> > > > _______________________________________________ > Beginners mailing list > [hidden email] > http://lists.squeakfoundation.org/mailman/listinfo/beginners > -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.1 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFG37GPpzl8tTvDAE8RAqb/AKDiQO4rKRRNidkdHYEJrthPh0+/MwCfVjo+ dVP14dxUR901/kJ0cyifjWU= =iwj+ -----END PGP SIGNATURE----- _______________________________________________ Beginners mailing list [hidden email] http://lists.squeakfoundation.org/mailman/listinfo/beginners |
|
|
In reply to this post by John Foster-3
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,
[hidden email] <[hidden email]> wrote: > The new XML based format may be easier to parse / write using YAXO _______________________________________________ Beginners mailing list [hidden email] http://lists.squeakfoundation.org/mailman/listinfo/beginners |
|
|
In reply to this post by Offray Vladimir Luna Cárdenas
Hi.
Here is a link for it (the home page, really): http://wiki.squeak.org/squeak/3624 It looks like the importer is mainly for documents - word related stuff. Although it is probably worth trying the calc import ( OpenOffice.org's version of Excel). And if it doesn't support that, it might be relatively easy to add support for it (at least the enough for what you need). -Chris On 9/6/07,
Offray Vladimir Luna Cardenas <[hidden email]> wrote: -----BEGIN PGP SIGNED MESSAGE----- _______________________________________________ Beginners mailing list [hidden email] http://lists.squeakfoundation.org/mailman/listinfo/beginners |
«
Return to Squeak - Beginners
|
1 view|%1 views
| Free forum by Nabble | Edit this page |