" Live as if you were to die tomorrow. Learn as if you were to live forever.. "
 - Mahatma Gandhi

  1. Home
  2. PHP Programming Tips
  3. Linking Data Sheet To Predefined Crosstabs And Charts

Linking Data Sheet To Predefined Crosstabs And Charts

 

It is difficult to a render a chart in a XLS file while generating it from PHP. But its possible to link the data from a different XLS sheet and to refer it to your sheet through which you can perform calculation or even alter the charts dynamically.
To do so, please follow the steps:
 
Step I:
  1. Open a XLS file
  2. Provide some datas to the file in appropriate cells
  3. Save the file with XLS format (if you are using open office) with some name say file1.
 
Step II:
  1. Open the exising XLS file which has datas.
  2. Open a new XLS file
  3. Place the cell pointer in the cell where you want to feed the data and put equal (=) symbol denoting a reference
  4. Now move on to the existing file and place the cursor in the cell whose value must be referred to the new sheet.
  5. Now again come back to the new XLS, Whose formula bar will have the format
    ‘Path of the filename’#Sheetname.cellvalue of the referring file
  6. click the (tick) icon or press enter.
  7. Do the same for all the cells where you want to link with other sheets.
Step III: (To create chart)
  1. In the new XlS file, select the data range till where you want to generate the chart.
  2. Click the chart icon in the tool bar
  3. Now the chart will be generated for selected data range.
  4. Save and Close the file
 
Step IV :
  1.  
    1. Open the file1 XLS i.e., referring file
    2. Alter some data values in the cells .
    3. Save the file
 
Step V:
 
  1.  
    1. Now open the newly created XLS
    2. It will ask “ The linked document has some changes, Do you want to update it?
    3. Click Yes.
    4. Now one can see the values that has been modifed in file1 gets updated in this file and chart
      also gets modified according to the new set of values

We can perfom the same process by referring a URL.
Satheeskumar A , PHP Developer, Mindfire Solutions.
Related Tags: Charts, Crosstab, Linking Datasheets, PHP, XLS
Author : Satheeskumar A

Leave a Reply