Read and write Excel sheet

Question posted by: CF FAN (Member) on March 28th, 2008 05:32 AM

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?

Would you like to answer this question?
Sign up for a free account, or Login (if you're already a member).

acoder

Site Moderator

9,896 Posts

March 31st, 2008
03:21 PM
#2

Re: Read and write Excel sheet

You can use the POI library which comes with Coldfusion.

CF FAN

Member

51 Posts

April 8th, 2008
05:16 AM
#3

Re: Read and write Excel sheet

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

acoder

Site Moderator

9,896 Posts

April 8th, 2008
10:26 AM
#4

Re: Read and write Excel sheet

You're welcome. Glad it's working.

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

Haitashi

Member

72 Posts

April 10th, 2008
03:33 PM
#5

Re: Read and write Excel sheet

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

Site Moderator

9,896 Posts

April 11th, 2008
09:22 AM
#6

Re: Read and write Excel sheet

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

Not the answer you were looking for? Post your question . . .
170,099 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).

Top Coldfusion Forum Contributors