How to convert Excel Files to Xls?

Shell Programming and Scripting
1

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

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

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

I'd bet they mean "open in MSEXCEL, and then save as *.xls". What did you open that file in?

5

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

No way. You may compress it. HTML files usually have very good compression rates.