Create/Edit PocketExcel files in .NET CF C#

  • Thread starter Thread starter CottonTech
  • Start date Start date
C

CottonTech

I am porting a mobile data aquisition application from eVB
to C#.Net HOW can I open and read the contents of an XLS
file (PXL once copied to PPC device). This is crucial,
there are hints that I can use a COM wrapper using pinvoke
and some DLL's but no examples anywhere. Any thoughts?
Also any idea when SP2 is out? I need colored buttons!
Thanks in advance
 
SP2 is currently in beta and is expected to be released before the end of
this year.

To use COM components from within the .NET CF it is worth taking a look at
CFCOM from Odyssey Software
(http://www.odysseysoftware.com/cfcom_main.html).

Peter Foot posted this link a while ago which might be of use to you to open
/ read PXL files:

There's no easy way but Pocket Excel is based on a format called Binary
Interchange File Format (BIFF) which is documented on the web - you'd need
to get down and dirty to read or write such a file from code.
http://chicago.sourceforge.net/devel/docs/excel/pkt/
 
CottonTech said:
I am porting a mobile data aquisition application from eVB
to C#.Net HOW can I open and read the contents of an XLS
file (PXL once copied to PPC device). This is crucial,
there are hints that I can use a COM wrapper using pinvoke
and some DLL's but no examples anywhere.
Click to expand...

As far as I know Pocket Excel doesen't support COM. See MSDN for details.
You should better use CSV format.
Also any idea when SP2 is out? I need colored buttons!
Click to expand...

The example of custom buttons can be fined here
http://samples.gotdotnet.com/quickstart/CompactFramework/doc/picturebutton.aspx
Thanks in advance
Click to expand...
You are welcome
 
Note that COM is not a solution as Pocket Excel has no COM automation model
unlike its bigger desktop equivalent. The only solution is to read and write
the pxl files directly which is no piece of cake.

Peter
 
Excellent insight, I will be stalking Chris's postings
forthwith. I have handled byte offset file structures
before but time is of the essence
Thanks for your comments.
 
Back
Top