I've got some code that uses the JExcelAPI for converting queries to
Excel spreadsheets.
It's got some support for formulas, so theoretically you could "wow"
the people you need to send it to by not only having the sums there,
but having them update if they change the numbers in the various
columns.
Here's an example of its use:
var workbook = variables.workbook;
var sheet = workbook.createSheet("Test Sheet");
var results = "";
sheet.addFormula(evaluateat="row",columnname="Net",formula="sum(amt[currentrow])-((sum(amt[currentrow])
* 5) / 100)");
sheet.setQuery(runQuery("SELECT *,'' as overhead FROM
creadittransactions LIMIT 19","myDSN"));
workbook.writeXLSFile("./test.xls");
results = sheet.getQuery();
debug(results);
Dunno if an approach like that would be easier or harder, but, well,
it's yours for the asking.
--
Permanence, perseverance and persistence in spite of all obstacle s,
discouragement s, and impossibilities: It is this, that in all things
distinguishes the strong soul from the weak.
Thomas Carlyle
On Thu, Jul 16, 2009 at 5:57 AM, Seamus
Campbell<[email protected]> wrote:
>
> I have a database (access at the moment) for members of an organisation. The
> members are scattered throughout (mostly in one state) Australia (with a
> couple in the US) They all are one of three language groups.
>
> I need to export an excel spreadsheet with a count of members from each
> language group per town, region, state, country plus total count .
> Then another excel spreadsheet with the count per language group for the end
> of each financial year. (plus total here as well)
>
> I am just at my wits end trying to work this out. I have to have it ready in
> the next few days.
>
> Can anyone help - I think I'd need to forward the relevant tables and the
> spreadsheets to show the format needed.
> I'm willing to pay for someone to help me with this. (I presume that it's
> only 1-2 hours work for someone who knows what they are doing)
>
> Many thanks
> Seamus
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324692
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
