match the XLS file. If you know the exact cell you want information from it
is pretty easy to get at. For example, say you want cell F on row 2, then
you would use the following.
<cfset foo = queryName.F[2]>
-Matt
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> On Behalf Of Mickael
> Sent: Tuesday, July 06, 2004 9:21 AM
> To: CF-Talk
> Subject: Re: Manipulation Excel files
>
> Hi Matt,
>
> Will this plugin work with files that is not formatted nicely in rows and
> columns, can the tag read the file and determine cell positions?
> ----- Original Message -----
> From: Matt Liotta
> To: CF-Talk
> Sent: Monday, July 05, 2004 10:16 PM
> Subject: RE: Manipulation Excel files
>
>
> I have an open source CFX available at
> http://sourceforge.net/projects/openxcf named CFX_ExcelQuery that allows
> you
> to read and write XLS files as CF queries.
>
> -Matt
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> > On Behalf Of Mickael
> > Sent: Monday, July 05, 2004 10:54 AM
> > To: CF-Talk
> > Subject: Manipulation Excel files
> >
> > Hello All,
> >
> > I was wondering if someone could point me in the right direction. I
> need
> > to be able to extract certain information from cells an excel file,
> update
> > some cell, delete some rows in the file then import the file to my
> > database. Can anybody point me to a resource that explains how to do
> this
> > or if someone has some experience with this it would be greatly
> > appreciated.
> >
> > Thank you,
> >
> > Mike
> >
> >
> >
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
