Read and write Excel sheet

[CF FAN]

Hi
Is it possible to read an Excel file using coldfusion then wrile that content to another excel sheet with different format?Is any one can help me?

[acoder]

You can use the POI library which comes with Coldfusion.

[CF FAN]

K thanksss....... .......working fine

[acoder]

You're welcome. Glad it's working.

Can you post some of your sample working code for the benefit of others?

[Haitashi]

Oh, yes, please do post examples. I'm trying to accomplish pretty much the same thing. Only, I'm trying to output the results of a query in to an excel file. I believe what you're doing can shed some light into what I'm trying to do.

[acoder]

You may find this cfc wrapper useful. Look for the updated version that fixes some bugs.