[VW] Connecting to Excel from VW via COM- connect....

> Good morning,
>
> Happy new year to all.
>
> I may need to connect to MS excel from the VW to generate reports. I am looking at the examples provided with the "Com - Automation" parcels. It looks like I have to learn a lot of the Excel internals.
>
> Does anyone use com connect to manipulate the MS Excel? What do you think of it ? Can you share some idea or experiences how to do it better or what things to avoid...
>
> Any information on the subject is greatly appreciated.
>
> Regards,
>
> Mark Pirogovsky
> ____________________________________________________________
> Woman is 53 But Looks 25
> Mom reveals 1 simple wrinkle trick that has angered doctors...
> http://thirdpartyoffers.netzero.net/TGL3241/50e6e0ece591760eb29aest01vuc
> _______________________________________________
> vwnc mailing list
> [hidden email]
> http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

>
> Hi,
>
> Well I use the xml to read and write MS-Projet 2010 files. This is all
> pretty well documented by MS.
>
> For Excel I use COM which is less documented but comes with various
> examples seems to handle all kind of Excel versions and works fine to me.
>
> Interested however if anyone knows of a COM equivalent on OSX.
>
> @+Maarten,
>
> -----Original Message-----
> From: "Reinier van Oosten" <[hidden email]>
> Sent: Friday, 4 January, 2013 15:34
> To: "Mark Pirogovsky" <[hidden email]>
> Cc: "[hidden email]" <[hidden email]>
> Subject: Re: [vwnc] [VW] Connecting to Excel from VW via COM- connect....
>
> Hello Mark,
>
> A number of years ago I had a comparable problem. My solution (still
> working good) was to use the excel xml 2004. The process is quite simple:
> 1) Save the workbook as XML 2004.
> 2) Open it with the XMLParser.
> 3) Look up the parts you need and parse them as far as it's necessary.
>
> It is a quite simple XML structure. You can read well in with any good
> XML editor (personally I use Oxygen). A large part of the xml can be
> skipped. The interesting parts are the worksheets, the tables, the
> rows and the cells.
> Exporting is also well to do. The heading with all kinds of status
> information is not preserved, exempt when you do this in your program.
>
> Personally I use this for importing data and later to generate reports
> of my own. I do not modify existing excel workbooks.
>
> Hope this helps.
>
> Reinier van Oosten
>
> On 4 Jan 2013, at 3:02 PM, Mark Pirogovsky <[hidden email]>
> wrote:
>
> > Good morning,
> >
> > Happy new year to all.
> >
> > I may need to connect to MS excel from the VW to generate reports. I
> am looking at the examples provided with the "Com - Automation"
> parcels. It looks like I have to learn a lot of the Excel internals.
> >
> > Does anyone use com connect to manipulate the MS Excel? What do you
> think of it ? Can you share some idea or experiences how to do it
> better or what things to avoid...
> >
> > Any information on the subject is greatly appreciated.
> >
> > Regards,
> >
> > Mark Pirogovsky
> > ____________________________________________________________
> > Woman is 53 But Looks 25
> > Mom reveals 1 simple wrinkle trick that has angered doctors...
> > http://thirdpartyoffers.netzero.net/TGL3241/50e6e0ece591760eb29aest01vuc
> > _______________________________________________
> > vwnc mailing list
> > [hidden email]
> > http://lists.cs.uiuc.edu/mailman/listinfo/vwnc
>
>
> _______________________________________________
> vwnc mailing list
> [hidden email]
> http://lists.cs.uiuc.edu/mailman/listinfo/vwnc
>
>
>
> ____________________________________________________________