LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > General
User Name
Password
General This forum is for non-technical general discussion which can include both Linux and non-Linux topics. Have fun!

Notices

Reply
 
Search this Thread
Old 04-23-2012, 07:10 AM   #1
vijay mishra
LQ Newbie
 
Registered: Apr 2012
Posts: 3

Rep: Reputation: Disabled
Reading one EXCEL(.xls) file and writing to other EXCEL(.xls) file


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
 
Old 04-23-2012, 07:50 AM   #2
vijay mishra
LQ Newbie
 
Registered: Apr 2012
Posts: 3

Original Poster
Rep: Reputation: Disabled
How to copy Arabic data from excel fiel to another excel file in PERL?

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......
 
Old 04-23-2012, 08:18 AM   #3
schneidz
Senior Member
 
Registered: May 2005
Location: boston, usa
Distribution: fc-15/ fc-20-live-usb/ aix
Posts: 4,010

Rep: Reputation: 624Reputation: 624Reputation: 624Reputation: 624Reputation: 624Reputation: 624
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.
 
Old 04-23-2012, 09:31 AM   #4
colucix
Moderator
 
Registered: Sep 2003
Location: Bologna
Distribution: CentOS 6.5 OpenSuSE 12.3
Posts: 10,503

Rep: Reputation: 1957Reputation: 1957Reputation: 1957Reputation: 1957Reputation: 1957Reputation: 1957Reputation: 1957Reputation: 1957Reputation: 1957Reputation: 1957Reputation: 1957
@vijay mishra: I have merged the two strictly related threads of yours. Please, keep discussion about the same topic in one place. Thank you.
 
Old 04-23-2012, 02:55 PM   #5
schneidz
Senior Member
 
Registered: May 2005
Location: boston, usa
Distribution: fc-15/ fc-20-live-usb/ aix
Posts: 4,010

Rep: Reputation: 624Reputation: 624Reputation: 624Reputation: 624Reputation: 624Reputation: 624
Quote:
Originally Posted by vijay mishra View Post
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 ?
 
Old 04-23-2012, 03:21 PM   #6
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,978
Blog Entries: 11

Rep: Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879
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 ...
 
Old 04-23-2012, 07:53 PM   #7
AnanthaP
Member
 
Registered: Jul 2004
Location: Chennai, India
Distribution: UBUNTU 5.10 since Jul-18,2006 on Intel 820 DC
Posts: 630

Rep: Reputation: 138Reputation: 138
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert from XML in excel format to Excel XLS file CPAN module Perseus Programming 9 10-14-2011 12:39 PM
.xls file corrupted recovery salimshahzad Linux - Newbie 1 05-29-2010 07:31 AM
how to use xls file in perl scirpt bharatbsharma Programming 2 06-10-2008 02:57 PM
Opening xls Excel Docs on Linux ddrfreak Mandriva 2 12-13-2004 11:09 PM
Just read DOC and XLS file formats! SmallTalker Linux - Software 5 09-23-2004 06:12 AM


All times are GMT -5. The time now is 07:11 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration