General This forum is for non-technical general discussion which can include both Linux and non-Linux topics. Have fun!
NOTE: All new threads will be moderated. Political threads will not be approved. |
Notices |
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Are you new to LinuxQuestions.org? Visit the following links:
Site Howto |
Site FAQ |
Sitemap |
Register Now
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
|
 |
04-23-2012, 07:10 AM
|
#1
|
LQ Newbie
Registered: Apr 2012
Posts: 3
Rep: 
|
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
|
|
|
04-23-2012, 07:50 AM
|
#2
|
LQ Newbie
Registered: Apr 2012
Posts: 3
Original Poster
Rep: 
|
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......
|
|
|
04-23-2012, 08:18 AM
|
#3
|
LQ Guru
Registered: May 2005
Location: boston, usa
Distribution: fedora-35
Posts: 5,330
|
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.
|
|
|
04-23-2012, 09:31 AM
|
#4
|
LQ Guru
Registered: Sep 2003
Location: Bologna
Distribution: CentOS 6.5 OpenSuSE 12.3
Posts: 10,509
|
@vijay mishra: I have merged the two strictly related threads of yours. Please, keep discussion about the same topic in one place. Thank you.
|
|
|
04-23-2012, 02:55 PM
|
#5
|
LQ Guru
Registered: May 2005
Location: boston, usa
Distribution: fedora-35
Posts: 5,330
|
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 ?
|
|
|
04-23-2012, 03:21 PM
|
#6
|
Moderator
Registered: Apr 2002
Location: earth
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
|
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 ...
|
|
|
04-23-2012, 07:53 PM
|
#7
|
Member
Registered: Jul 2004
Location: Chennai, India
Posts: 952
|
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
|
|
|
All times are GMT -5. The time now is 12:17 AM.
|
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.
|
Latest Threads
LQ News
|
|