Pocket Excel API

[eh1]

Does anyone know where I can find an API for Pocket Excel on Pocket PC? I want to be able to call a set of functions within a pocket pc ce application to create and manipulate Pocket Excel spreadsheets.

I've searched all over and can't find it. Thanks!

[Peter Foot]

There is no API for Pocket Excel. There is some sketchy documentation on the file format (which is a variant of Binary Interchange File Format or BIFF) if you google for that. But it would be a hard slog to write code to parse and manipulate the files from scratch. Chris Tacke MVP has been working on a .NET Compact Framework library to read and modify pocket excel files but it is far from complete and not ready to be released yet. You can find more details on his blog:-
http://blog.opennetcf.org/ctacke/

[Kowalski]

well actually there exists a SDK called POOM sdk which stands for pocket office object model which can be downloaded here http://www.microsoft.com/downloads/details.aspx?FamilyID=78d1a8b7-d606-45b2-9cdc-58bf5a578338&displaylang=en

[Janak Parekh]

well actually there exists a SDK called POOM sdk
Correct me if I'm wrong, but POOM doesn't actually let you directly use Excel mathematical functions from within a third-party app -- rather, it's a data access model for Pocket Outlook information.

--janak

[Kowalski]

Correct me if I'm wrong, but POOM doesn't actually let you directly use Excel mathematical functions from within a third-party app -- rather, it's a data access model for Pocket Outlook information.
i read some manuals and it turns out that you are right. :roll:

[eh1]

Looks like the library porject would be like something I could use.
Oh well. Thanks for the help guys.