Creating xlsx micro to write in translated tag text to it's neighbot tag

Topics: Developer Forum, User Forum
Jul 4, 2014 at 7:13 AM
I have application where user enters Arabic text, I perform transliteration to English.

Now I want to use same for xlsx file data.

consider User registration form in excel in Arabic. I can do transliteration of each cell, but now I want to place transliteration text to it's neighborhood cell. So that those who can not read Arabic, can understand from English transliteration.

I want to use Macros, so that as and when user enters, it should instantly translated to English transliteration.

transliteration part I did in PHP, Just I want to embed it with xlsx macro.

Here is code snippet, but here cell position is not considered
$Arabic = new I18N_Arabic('Transliteration');
$xlsx = new SimpleXLSX('test.xlsx');
$result = array();
$result = $xlsx->rows();
// $result=implode(",",$result[0]);
$i = 0;
foreach ($result[$i] as $term) {
    array_push($result, $Arabic->ar2en($term));     
    echo $Arabic->ar2en($term);
    $i++;
}


Coordinator
Jul 4, 2014 at 8:06 AM
It isn't PHPExcel that you're using, it's SimpleXLSX, which is a completely different library
Jul 4, 2014 at 10:16 AM
Edited Jul 4, 2014 at 10:25 AM
Yes Mark, thanks for reply and SO and here.

I wanted to show what I have tried that's why I added simpleXLSX code. But I guess it is not going to help me.

I want to know whether is it possible using PHPExcel?

like using Macros, so that when user types or enters Arabic text, it's transliteration should appear in it's right most tag.

Transliteration part I have created in PHP.

Thanks for your time.