Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

How to convert Excel Files to Xls?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to convert Excel Files to Xls?
# 1  
Old 07-31-2013
How to convert Excel Files to Xls?
Hi All,

I have created a BI Publisher report in Oracle apps R12.

It has generated the output with *.EXCEL file extension. I have a shell script to mail this output. in my shell script I have copied this file and saved as *.xls file.

But the R12 generated *.EXCEL file is not a real excel file, it is a mhtml file.
The size of this file is too big. So i have copied this file to .xls in shell script. But it is not reducing the file size ,still the size of the file is same as the EXCEL and it's too big.

Please advise me how to solve this.

Thanks in advance.

Regards,
P.Kalidoss
# 2  
Old 07-31-2013
I don't think you're going to make the file smaller by converting it. You may need a different strategy.

We need to see the layout of this html file to deal with it, in any case.
# 3  
Old 07-31-2013
Hi corona,

Thanks for your reply.I have read in oracle metalink, they have mentioned that open the EXCEL file and save it as *.xls the size will be reduced.

So, I have tried like that.But the file size is not getting reduced.

Please let me know that Is there any other way to reduce the file size.


Regards,
P.Kalidoss
# 4  
Old 07-31-2013
I'd bet they mean "open in MSEXCEL, and then save as *.xls". What did you open that file in?
# 5  
Old 08-01-2013
Yes Rudi.They asked to open in local and save as *.xls.
But here ,we are picking the file and save as .xls and send it via mail.

how can i open that file and save as .xls in shell script.?
# 6  
Old 08-05-2013
No way. You may compress it. HTML files usually have very good compression rates.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Convert Excel File (xls) to tab delimited text file on AIX

Hi i have a problem in my job i try to convert an excel file (xls extention) to text file (tab delimited), but no result with this comand cat xxx.xls > xxx.txt Do you have eny idea? PS: sorry for my english Thanks!! (4 Replies)
Discussion started by: frisso
4 Replies

2. Shell Programming and Scripting

Writing xml from excel sheet .xls using perl script

Hi all. I am working on the below requirement of generating .xml file from .xls file which i have , can someone please help me or in writing the perl script for the same: The xls file format is as below which has two columns and number of rows are not fixed: Fixlet Name ... (12 Replies)
Discussion started by: omkar.jadhav
12 Replies

3. Shell Programming and Scripting

How to convert Text data to xls?

Hi Team, I have created a script to output DB Query data to a text file. It displays output as follows for 2 different queries appended to same file. I want help to convert this data to xls format so that the output of first query is in 1 tab and the other in second tab. Please help. ... (14 Replies)
Discussion started by: srkmish
14 Replies

4. Shell Programming and Scripting

Perl script to Convert XLSX or XLS files to CSV file

Hi All, I've got in a situation where I need to convert .xlsx or .xls formatted files into simple text file or .csv file. I've found many options but doing this using PERL script is the best way I believe.I'm in AIX box. Perl code should have 2 params while running. i.e perl... (1 Reply)
Discussion started by: manab86
1 Replies

5. Shell Programming and Scripting

How to convert a xls file to csv?

Hi, My requirement is to convert the xls to csv file with utf-8 conversion. Is there any way please suggest me. Thanks, Raja (4 Replies)
Discussion started by: cnraja
4 Replies

6. UNIX and Linux Applications

Tool for Convert XLS into CSV in UNIX

Hi I wanted to convert some XLS files into CSV format in my UNIX box. Unix box is handling very important data which are related to data warehouse.It is fully optimized by installing minimum packages since server need more resources to handle reports generating. Just for convert XLS files... (6 Replies)
Discussion started by: luke_devon
6 Replies

7. Shell Programming and Scripting

how to convert .xls to .csv

Hi, I have problem..How to convert .xls file to .csv.. Plz help me for this problem.. (1 Reply)
Discussion started by: varma457
1 Replies

8. Shell Programming and Scripting

Shell convert xls to csv

Hi does anybody know how to convert xls to csv undex linux. I need only data (that is log from test, dont need any macro and so on) from xls. Any idea how to do that? Perl? shell? Could you give me any example? Thanks in advance for answer. Gracjan (4 Replies)
Discussion started by: Gracjan
4 Replies

9. Shell Programming and Scripting

Convert a csv file to an xls format

Hi, I have a file coming in xxx.txt(csv format) i do some work on it and i need to send out as a .xls format. Is there any way there is some code i can use in my script to convert this? I'm struggling on this. Thanks (11 Replies)
Discussion started by: Pablo_beezo
11 Replies
Login or Register to Ask a Question