PC Review


Reply
Thread Tools Rate Thread

Create/Edit PocketExcel files in .NET CF C#

 
 
CottonTech
Guest
Posts: n/a
 
      27th Nov 2003
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
 
Reply With Quote
 
 
 
 
Maarten Struys, eMVP
Guest
Posts: n/a
 
      27th Nov 2003
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/



--
Regards,

Maarten Struys, eMVP
PTS Software bv

"CottonTech" <(E-Mail Removed)> wrote in message
news:06b601c3b49c$b3fac5c0$(E-Mail Removed)...
> 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



 
Reply With Quote
 
Igor Zhavrid
Guest
Posts: n/a
 
      27th Nov 2003

"CottonTech" <(E-Mail Removed)> wrote in message
news:06b601c3b49c$b3fac5c0$(E-Mail Removed)...
> 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.


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!


The example of custom buttons can be fined here
http://samples.gotdotnet.com/quickst...urebutton.aspx

> Thanks in advance

You are welcome



 
Reply With Quote
 
Peter Foot [MVP]
Guest
Posts: n/a
 
      27th Nov 2003
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

--
Peter Foot
Windows Embedded MVP
OpenNETCF.org Senior Advisor
www.inthehand.com | www.opennetcf.org

"Maarten Struys, eMVP" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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/
>
>
>
> --
> Regards,
>
> Maarten Struys, eMVP
> PTS Software bv
>
> "CottonTech" <(E-Mail Removed)> wrote in message
> news:06b601c3b49c$b3fac5c0$(E-Mail Removed)...
> > 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

>
>



 
Reply With Quote
 
Neil Cowburn [MVP]
Guest
Posts: n/a
 
      27th Nov 2003
Note that Chris Tacke is working on this problemette. See his blog at
http://blog.opennetcf.org/ctacke/Per...f-6631dc9a5721

--Neil

--
Neil Cowburn
Technologist
Microsoft Windows Embedded MVP
Content Master Ltd.

www.contentmaster.com | www.opennetcf.org


"Peter Foot [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
> --
> Peter Foot
> Windows Embedded MVP
> OpenNETCF.org Senior Advisor
> www.inthehand.com | www.opennetcf.org
>
> "Maarten Struys, eMVP" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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/
> >
> >
> >
> > --
> > Regards,
> >
> > Maarten Struys, eMVP
> > PTS Software bv
> >
> > "CottonTech" <(E-Mail Removed)> wrote in message
> > news:06b601c3b49c$b3fac5c0$(E-Mail Removed)...
> > > 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

> >
> >

>
>



 
Reply With Quote
 
cottontech
Guest
Posts: n/a
 
      27th Nov 2003
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.
>-----Original Message-----
>Note that Chris Tacke is working on this problemette. See

his blog at
>http://blog.opennetcf.org/ctacke/Per...aspx/2c52ddbb-

2d3c-40d9-aa0f-6631dc9a5721
>
>--Neil
>
>--
> Neil Cowburn
> Technologist
> Microsoft Windows Embedded MVP
> Content Master Ltd.
>
> www.contentmaster.com | www.opennetcf.org
>
>
>"Peter Foot [MVP]" <(E-Mail Removed)> wrote

in message
>news:(E-Mail Removed)...
>> 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
>>
>> --
>> Peter Foot
>> Windows Embedded MVP
>> OpenNETCF.org Senior Advisor
>> www.inthehand.com | www.opennetcf.org
>>
>> "Maarten Struys, eMVP" <(E-Mail Removed)>

wrote in message
>> news:(E-Mail Removed)...
>> > 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/
>> >
>> >
>> >
>> > --
>> > Regards,
>> >
>> > Maarten Struys, eMVP
>> > PTS Software bv
>> >
>> > "CottonTech" <(E-Mail Removed)>

wrote in message
>> > news:06b601c3b49c$b3fac5c0$(E-Mail Removed)...
>> > > 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
>> >
>> >

>>
>>

>
>
>.
>

 
Reply With Quote
 
MARCMC
Guest
Posts: n/a
 
      27th Nov 2003
http://www.gotdotnet.com/Community/M...ard/Thread.asp
x?id=160413
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data files or edit/create new email acount =?Utf-8?B?Y3JhaWc=?= Microsoft Outlook Installation 1 5th Aug 2007 05:40 AM
Re: Create and Edit Resource Files - Newbie Question RobinS Microsoft VB .NET 0 25th Jan 2007 11:31 PM
PocketExcel development tools...? Brian Underhill via DotNetMonster.com Microsoft Dot NET 0 16th Jan 2006 08:21 PM
help-edit copy and edit paste wont work, cant restore files in recycle bin either Neal Windows XP General 1 17th Oct 2004 03:20 PM
Word won't create or edit files =?Utf-8?B?TWFyeQ==?= Microsoft Word Document Management 2 2nd Sep 2004 12:52 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:12 PM.