I need someone to help me write an Excel page from a data base!!! - GoFuckYourself.com

DWB · 04-18-2007, 07:02 PM

Anyone up for a little job?

I need to pull the info from a mysql database and write it to an excel page. That page will automatically update as the site is updated.

I had a guy who was going to do this for me but he is MIA and I needed this like yesterday.

Anyone?

Tempest · 04-18-2007, 07:45 PM

What do you mean by an "excel page"?

sarettah · 04-18-2007, 07:49 PM

Quote:

Originally Posted by DirtyWhiteBoy

Anyone up for a little job?

I need to pull the info from a mysql database and write it to an excel page. That page will automatically update as the site is updated.

I had a guy who was going to do this for me but he is MIA and I needed this like yesterday.

Anyone?

There is a real quick and easy way to do this.

Write an html table with the data in it, save it with a file extension of .xls.

And that is really all there is to it. You can write formulas in. etc and when it is open in excel excel automaically turns it into an excel sheet.

I didn't believe it when someone showed me but it works.

DWB · 04-18-2007, 08:06 PM

Quote:

Originally Posted by Tempest

What do you mean by an "excel page"?

.xls page

brizzad · 04-18-2007, 08:15 PM

Quote:

Originally Posted by sarettah

There is a real quick and easy way to do this.

Write an html table with the data in it, save it with a file extension of .xls.

And that is really all there is to it. You can write formulas in. etc and when it is open in excel excel automaically turns it into an excel sheet.

I didn't believe it when someone showed me but it works.

Really? That's awesome. Do only the newer versions of excel utilize this feature?

sarettah · 04-18-2007, 08:22 PM

Quote:

Originally Posted by brizzad

Really? That's awesome. Do only the newer versions of excel utilize this feature?

I have no idea...lol. Know it works in 97 and 2000.

It came up when we were trying to get our server admin to install excel on the server so we could odbc to excel to write reports. He was very resistant, so we found a way around him.

It is a simple little trick but makes a lot of stuff easier to do once you play with it for a bit.

I haven't figured out how to do multiple page workbooks yet but the single page trick saves a lot of exporting and importing data when you need a quick little report.

I don't think it actually converts the data to an excel sheet. It keeps it in html but it allows you to navigate it and all that in excel.

DWB · 04-18-2007, 08:24 PM

Quote:

Originally Posted by sarettah

I have no idea...lol. Know it works in 97 and 2000.

It came up when we were trying to get our server admin to install excel on the server so we could odbc to excel to write reports. He was very resistant, so we found a way around him.

It is a simple little trick but makes a lot of stuff easier to do once you play with it for a bit.

I haven't figured out how to do multiple page workbooks yet but the single page trick saves a lot of exporting and importing data when you need a quick little report.

I don't think it actually converts the data to an excel sheet. It keeps it in html but it allows you to navigate it and all that in excel.

Hmmmmmm. Sounds interesting.

CaptainHowdy · 04-18-2007, 08:45 PM

If you're using PHPMyAdmin that's an easy task...

sarettah · 04-18-2007, 09:02 PM

Quote:

Originally Posted by CaptainHowdy

If you're using PHPMyAdmin that's an easy task...

I think he wants it embedded into the site update to automatically happen. I am not sure that you can do that with phpmyadmin. Not sure though because I have only used it a time or two.

Tempest · 04-18-2007, 09:08 PM

Looks like it would be easy to do with the pear excel write package with php. I'd help you out but it's looking like I'm not going to have any time today.

DWB · 04-19-2007, 07:10 AM

I've got someone looking it it now. Will let you guys know if he is not able to do it.

Thanks all!!!

CaptainHowdy · 04-19-2007, 07:16 AM

Quote:

Originally Posted by DirtyWhiteBoy

I've got someone looking it it now. Will let you guys know if he is not able to do it.

Thanks all!!!

I love you DWB!

[IMG]http://galleries.trannyhunt.com/***/tmpl/tgp/4/images/faces/05.jpg[/IMG]

04-18-2007, 07:02 PM	#1
DWB Registered User Industry Role: Join Date: Jul 2003 Location: Encrypted. Access denied. Posts: 31,779	I need someone to help me write an Excel page from a data base!!! Anyone up for a little job? I need to pull the info from a mysql database and write it to an excel page. That page will automatically update as the site is updated. I had a guy who was going to do this for me but he is MIA and I needed this like yesterday. Anyone?

04-18-2007, 08:45 PM	#8
CaptainHowdy Too lazy to set a custom title Industry Role: Join Date: Dec 2004 Location: Happy in the dark. Posts: 93,094	If you're using PHPMyAdmin that's an easy task... __________________ FLASH SALE INSANITY! deal with a 100% Trusted Seller Buy Traffic Spots on a High-Quality Network 1 Year or Lifetime — That’s Right, Until the Internet Explodes!

04-18-2007, 07:45 PM	#2
Tempest Too lazy to set a custom title Industry Role: Join Date: May 2004 Location: West Coast, Canada. Posts: 10,217	What do you mean by an "excel page"?

04-18-2007, 09:08 PM	#10
Tempest Too lazy to set a custom title Industry Role: Join Date: May 2004 Location: West Coast, Canada. Posts: 10,217	Looks like it would be easy to do with the pear excel write package with php. I'd help you out but it's looking like I'm not going to have any time today.

04-19-2007, 07:10 AM	#11
DWB Registered User Industry Role: Join Date: Jul 2003 Location: Encrypted. Access denied. Posts: 31,779	I've got someone looking it it now. Will let you guys know if he is not able to do it. Thanks all!!!