query? specifically, I'm looking for a way to create pivot tables from sql
data
-----Original Message-----
From: Matt Liotta [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 06, 2004 7:10 AM
To: CF-Talk
Subject: RE: Manipulation Excel files
The tag will turn an XLS file into a CF query that has columns and rows to
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]
