PHP - Reading Data From Excel File In Php

Hi, this is my first time here.

i am trying to create an xls file from the data i get from mysql. here is the code i tried but i am not able to use it correctly.
Code: [Select]
ob_start();
include('config');
$datacat = mysql_query("SELECT *
FROM `leads`") or die(mysql_error());
$name = mysql_fetch_assoc($datacat);

$line1="Industry,Company Name,Officials Name,Job Title,Country,Direct Number Mobile Number,Switch Board Number,E-mail,Executive NamePitch Date,Call Back Date,Comments\t";
while($row = mysql_fetch_array($datacat, MYSQL_ASSOC)) {
$line2= $name['industry'].",".$name['company_name'].",".$name['officials_name'].",".$name['job_title'].",".$name['country'].",".$name['direct_number_mobile_number'].",".$name['switch_board_number'].",".$name['email'].",".$name['executive_name'].",".$name['pitch_date'].",".$name['call_back_date'].",".$name['comment']."\t"."\n";
}
$data="$line1\n$line2\n";
 
header("Content-type: application/x-msdownload");
header("Content-Disposition: attachment; filename=extraction.xls");
header("Pragma: no-cache");
header("Expires: 0");
print "$header\n$data";

i get my webpage title in the top of xls file and all the fields in xls file are separated by commas, whereas i want them to be in proper tables.

Help would be much appreciated.

Well, im a n00b for php, and what i need is a php script which will read data from .xml file and write it into .txt file. Can someone help me?
Example of .xml file :

<?xml version="1.0" encoding="utf-8"?>
<tv generator-info-name="NeTXMLTV/1.0.0.0" source-info-url="http://www.net-tv.hr/" source-info-name="NeT TV XMLTV" source-data-url="http://www.net-tv.hr/xmltv/net-pregled-programa-xmltv.xml">
  <programme channel="NeT TV" start="20110413063000 +0200" stop="20110413080000 +0200">
    <title lang="hr">JUTARNJI EXPRESS</title>
    <category lang="hr">glazbeno-informativni program</category>
    <desc lang="hr">Glazbeno informativna emisija sa servisnim informacijama i jutarnjim temperaturama, idealna za jutarnje buđenje uz toplu kavu ili čaj....</desc>
  </programme>
</tv>

I need the .txt file to look like this:
201104130630 - 201104130800
JUTARNJI EXPRESS
glazbeno-informativni program
Glazbeno informativna emisija sa servisnim informacijama i jutarnjim temperaturama, idealna za jutarnje buđenje uz toplu kavu ili čaj....

Can someone please help me? thanks

Hello again. I'm trying to load data from a Facebook Share Data XML file and then displaying them in a WordPress plugin. Here's my code so far:


// Fetch Share Count Data

function fb_button () {
$fbshareUrl = urlencode(get_permalink($post->ID));
$fbshareTitle = urlencode($post->post_title);
$fbLinkStats = simplexml_load_file('http://api.facebook.com/restserver.php?method=links.getStats&urls='.$shareUrl);

 $fb_params =
        '?u=' . $fbshareUrl .
        '&amp;t=' . $fbshareTitle .
        ''
        ;

// Vertical Facebook Button

       $fb_share = '
<div class="fsbsharer" id="fb">
<a href="http://www.facebook.com/sharer.php' . $fb_params . '"  class="facebookShare">

<span class="fb_share_size_Small fb_share_count_wrapper">
<span></span>

<span class="fb_share_count_nub_top "></span> 
<span class="fb_share_count  fb_share_count_top">


<div class="fb_share_count_inner">
'. $fbLinkStats->link_stat->total_count .'
</div>

</div>
<span style="cursor:pointer;" class="FBConnectButton FBConnectButton_Small"><span class="FBConnectButton_Text">Share</span></span>
</a>
</div>
';


       echo $fb_share;
    }


This code works for everything except the title and the share count. I can fix the title myself but the share count isn't working.

When I use this in plain HTML:
<?php echo $fbLinkStats->link_stat->total_count.''; ?>
it works fine, but when I combine it all into another function to echo, it no longer works properly.

Thanks.

Hello,
i am currently getting an Microsoft Excel formatted text file whose save type is .Txt from a URL.I used to open it and will change the save type  as excel file. Please suggest whether we can do this with php code.

currently my code is like this,
<? php
copy("http://www.faa.gov/airports/airport_safety/airportdata_5010/menu/emergencyplanexport.cfm?Region=&District=&State=&County=&City=LAS%20VEGAS&Use=&Certification=","./contactsexport.xls");
?>

where as the contactsexport.xls type is .Txt which i need it in .xls

Thanks in Advance.

Hello All,

Please excuse my lack of knowledge in advance, I'm a beginner but pick things up relatively quickly, and tend to do things by trial and error.

I would appreciate any help that anyone could offer with the following:

I would like to retrieve two pieces of data from a "text file" and use them to calculate a result from a function I have in javascript. An example of the javascript code is:

<script type="text/javascript">
function calculate() {
var drybulb = document.calc_form.drybulb.value;
var relhum = document.calc_form.relhum.value;
var answer = '';
if (drybulb !== '' && relhum !== '') {
answer = (0.567*drybulb*1) + (0.393 * (relhum*1/100 * 6.105 * Math.exp(17.27 * drybulb / (237.7 + drybulb*1)))) + 3.94;
}
document.calc_form.answer.value = answer;
return false;
}
</script>

Currently this is evaluated with entry from a simple html form, but I would like to have this performed "automatically".


The "text file" that I would like to access is here, not on my server:

http://www.bom.gov.au/fwo/IDV60901/IDV60901.94870.axf

I would like to extract the "air_temp" and "rel_hum" values under the [data] section for use in my function. I just need the "most recent" values (i.e. first), not all those contained in the file. This is a single record from that section (sorry for the mess this no doubt makes):

[data]
sort_order,wmo,name[80],history_product[80],local_date_time[80],local_date_time_full[80],aifstime_utc[80],air_temp,apparent_t,cloud[80],cloud_base_m,cloud_oktas,cloud_type[80],cloud_type_id,delta_t,dewpt,gust_kmh,gust_kt,lat,lon,press,press_msl,press_qnh,press_tend[80],rain_trace[80],rel_hum,sea_state[80],swell_dir_worded[80],swell_height,swell_period,vis_km[80],weather[80],wind_dir[80],wind_spd_kmh,wind_spd_kt
0,94870,"Moorabbin Airport","IDV60901","27/10:00pm","20120227220000","20120227110000",18.8,19.3,"Partly cloudy",510,3,"-",-9999,0.8,17.5,13,7,-38.0,145.1,1013.5,-9999.0,1013.5,"-","11.4",92,"-","-",-9999.0,-9999,"10","-","S",11,6



Would it be possible to obtain these values using PHP?, and if so any advice on how this could be done (noting my minimal knowledge) would be greatly appreciated.

Cheers.