Programming......

[romero2005]

pahala pinthuraya balanna..

mata ona ihala tiyana last column eka pahala tiyana vidihata hada ganda.

e kiyanne ":" mark eken Left side eka Column name eka vidihatath ita adala value eka e kiyanne ":" right side eke tiyana valuwe eka corresponding column eke adala # eka idiriyen watenda....

Meka gana kalin ahuwa. but apahu ahanawa...kohomada karanne.

 

[smother]

use substring

 

[romero2005]

use substring

Thank u bro...9+

 

[Ayeshlive]

Language: PHP

<?php

$split_char = ':';
$data = array();
$data[123456] = array('12:5', '15:3', '17:6');
$data[654321] = array('12:5', '15:3', '17:6');
$data[963258] = array('12:5', '15:3', '17:6');
$data[785214] = array('12:5', '15:3', '17:6');

// Algo:

$new_data = array();
$headers = array();
foreach ($data as $key => $values) {
  $shadow = array();
  foreach ($values as $value) {
    $e = explode($split_char, $value);
    $shadow[$e[0]] = $e[1];
    $headers[$e[0]] = '';
  }
  $new_data[$key] = $shadow;
}

// Presentation:
print '<table>';
print   '<thead><th>#</th>';
foreach (array_keys($headers) as $header) {
  print '<th>' . $header . '</th>';
}
print '</thead>';
foreach ($new_data as $key => $values) {
  print '<tr>';
  print '<td>' . $key . '</td>';
  foreach (array_keys($headers) as $header) {
    if (isset($values[$header])) {
      print '<td>' . $values[$header] . '</td>';
    }
    else {
      print '<td></td>';
    }
  }
  print '</tr>';
}
?>

https://gist.github.com/Ayesh/9b45f963d182b0f30876

 

[romero2005]

Language: PHP

<?php

$split_char = ':';
$data = array();
$data[123456] = array('12:5', '15:3', '17:6');
$data[654321] = array('12:5', '15:3', '17:6');
$data[963258] = array('12:5', '15:3', '17:6');
$data[785214] = array('12:5', '15:3', '17:6');

// Algo:

$new_data = array();
$headers = array();
foreach ($data as $key => $values) {
  $shadow = array();
  foreach ($values as $value) {
    $e = explode($split_char, $value);
    $shadow[$e[0]] = $e[1];
    $headers[$e[0]] = '';
  }
  $new_data[$key] = $shadow;
}

// Presentation:
print '<table>';
print   '<thead><th>#</th>';
foreach (array_keys($headers) as $header) {
  print '<th>' . $header . '</th>';
}
print '</thead>';
foreach ($new_data as $key => $values) {
  print '<tr>';
  print '<td>' . $key . '</td>';
  foreach (array_keys($headers) as $header) {
    if (isset($values[$header])) {
      print '<td>' . $values[$header] . '</td>';
    }
    else {
      print '<td></td>';
    }
  }
  print '</tr>';
}
?>

https://gist.github.com/Ayesh/9b45f963d182b0f30876

Thank u machan..but all these values are in Excel sheet.So I need to import that excel sheet into the program and then again export that excel sheet with changes...is it possible.

9+ machan

 

[darkenmac]

Thank u machan..but all these values are in Excel sheet.So I need to import that excel sheet into the program and then again export that excel sheet with changes...is it possible.

9+ machan

MAcho use the POI library to write on excel if you are using java

 

[romero2005]

bump

thanks bro...9+