Re: Create Excel file with macro?

["Kronin555" <webforumsuser@xxxxxxxxxxxxxx>]

You can do that using Apache POI.

 Here's a code sample:
 POIFSFileSystem fs = new POIFSFileSystem(new 
FileInputStream(templateFilename));
 HSSFWorkbook wb = new HSSFWorkbook(fs);
 HSSFSheet sheet = wb.getSheet("Sheet Name");
 sheet.setColumnHidden((short) 5, true); 

 I'm using the most recent version of POI. The one included with ColdFusion may 
or may not have this functionality, I don't know.