Reading one EXCEL(.xls) file and writing to other EXCEL(.xls) file

vijay mishra · 04-23-2012, 07:10 AM

hello sir/hi friends

I am trying to write each cell of a .xls (EXCEL) file in other .xls(EXCEL) file.

The EXCEL file i am reading contains both ENGLISH and ARABIC datas.

While inserting ARABIC in EXCEL file it gets changed to SPECIAL CHARACTERS.
How should i proceed.

please help me out

vijay mishra · 04-23-2012, 07:50 AM

hello sir/hi friends I am writing a PERL Program and working on Linux.. I am reading a .xls(EXCEL) file and Writing to other .xls(EXCEL). My EXCEL file contains both ENGLISH and ARABIC data. ENGLISH is written successfully , but each ARABIC data is inserted as special characters in EXCEL file. please guide......

schneidz · 04-23-2012, 08:18 AM

i think you need arabic language support for open office:
http://www.openoffice.org/ar/

if you are using microsoft excel then you are in the wrong forum.

colucix · 04-23-2012, 09:31 AM

@vijay mishra: I have merged the two strictly related threads of yours. Please, keep discussion about the same topic in one place. Thank you.

schneidz · 04-23-2012, 02:55 PM

Quote:

Originally Posted by vijay mishra

hello sir/hi friends I am writing a PERL Program and working on Linux.. I am reading a .xls(EXCEL) file and Writing to other .xls(EXCEL). My EXCEL file contains both ENGLISH and ARABIC data. ENGLISH is written successfully , but each ARABIC data is inserted as special characters in EXCEL file. please guide......

maybe if you post the code you got so far somebody would be able to correct it ?

Tinkster · 04-23-2012, 03:21 PM

I can't see any mention of Linux, or Linux related tools in this
thread so far, so I'm moving it to GENERAL ... if this is NOT OK
please explain by which means you're copying your excel sheets,
and use the report button to have it moved to more suitable forum,
e.g.: Linux-Software (if you use openOffice), or Programming ...

AnanthaP · 04-23-2012, 07:53 PM

Arabic characters ARE special characters.

The cells containing the Arabic characters should have the appropriate font and character.

So when you copy the data cell by cell, be sure to copy the format also.

I presume most scripting languages will have the format.

Destination.sheet.cell(row.column).format=<Appropriate>

As others say, for further help, please tell us which OS platform and excel version you use.

OK