macromedia.coldfusion.advanced_techniques
[Top] [All Lists]

Create Excel file with macro?

Subject: Create Excel file with macro?
From: "JulioP." <webforumsuser@xxxxxxxxxxxxxx>
Date: Mon, 28 Jul 2008 15:55:11 +0000 (UTC)
Newsgroups: macromedia.coldfusion.advanced_techniques

I'm working on a project where we have to create a lot of reports. Our 
accountant loves the fact that we can export to Excel so she can then use the 
data and do her own calculations, formatting, etc. Now she's asking if when we 
export to Excel, if certain columns can be hidden so people will just see the 
summary when they open the Excel file, but they can unhide the other columns if 
they want to get all the details. I've seen accounting software that export to 
Excel and hide columns, but they do it using macros. Is this even possible when 
exporting from ColdFusion or should we just create two sets of Excel files, 
some with the summaries and some with all the details?
 Thanks!


<Prev in Thread] Current Thread [Next in Thread>