freelanceprogrammers.org Forum Index » Perl

View previous topic :: View next topic

hoo boy, dump to excel without module

huxjones Posted: Wed Sep 01, 2004 7:14 pm

Joined: 01 Sep 2004

Posts: 1

hoo boy, dump to excel without module

Hi all,
here is what I have already done, followed by what I need to do, and
I hope someone here can/will help..

At one point in my application, the user wants to be able to click a
link and have a dataset open in excel. Easy enough, I guess:

print "Content-type: application/vnd.ms-excel

";

#....in a while loop:

print @rows[0]," ";
print @rows[1]," ";
print "$easycomment ";
print @rows[13]," ";
print "$problemcomment ";
print @rows[14]," ";
print "$reqnumcomment ";
print @rows[2]," ";
print @rows[3]," ";
print @rows[4]," ";
print @rows[5]," ";
print "$manner ";
print @rows[6]," ";
print "$impressed ";
print "$general
";

etc, etc...This gives me all the data, the browser fires up excel as
expected, blah blah blah.

My users, being the deviant little rascals they are, have decided
this isn`t good enough - they want some data in worksheet 1, and
other data in worksheet 2.

Every description I have been able to find includes the use of
specific modules - which aren`t installed on our server and I`m not
allowed to install on our server. I guess I was hoping to be able to
embed a worksheet name in the data and have excel parse it - like the
qualifier.

Any ideas would be greatly appreciated.

thanks! hux

freelanceprogrammers.org Forum Index » Perl

All times are GMT
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Freelace Website Designer - Customer web design and software building.
China Wholesale - Electronics Products
Character Studio - Tutorials and Help