You are missing the point. You want to rename the file - somefile.txt -> somefile.xls
That is all you need to do. Excel will do the rest when a user opens it.
You are missing the point. You want to rename the file - somefile.txt -> somefile.xls
That is all you need to do. Excel will do the rest when a user opens it.
Jim,
That's not a good idea, if you rename a .txt or .csv file to an .xls file, Excel doesn't use the field separators and places every line in one column.
Regards
Last edited by Franklin52; 11-21-2008 at 08:33 AM..
Here is a sample data file.
I can then turn it into a csv file. Excel can naturally read a csv file. There will be no data formatting, but the data will be placed across the rows and columns - in this case, four columns of 4 rows of data. Below is the awk command to parse and create the csv file.
The following csv will be opened by Excel nicely - putting into four columns and four rows. The user can keep in csv format, or save into xls format.
If the file is renamed to an xls fil extension, Excel will load the data, but will put it into only one column of four rows.
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)
Hi Folks,
I have written a perl script that reads data from excel sheet(.xls) using Spreadsheet::ParseExcel module. But the problem is this module doesn't work for excel sheets with extension .xlsx.
I have gone through Spreadsheet::XLSX module with which we can read from .xlsx file directly.... (1 Reply)
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)
Hi All,
I have a java program running in AIX machine which gives me the output in form of .CSV but my clients wants output in the form of .xls
When I gave the command mv <filename.csv> <filename.xls>
The contents of this .xls file is not exactly in seprate columns as in CSV, the contents... (1 Reply)
Hi,
i don't know anything about PERL. Can anyone help me providing PERL scripts for
1. converting XLS to CSV (and vice-versa)
2. converting DOC/RTF to TXT
Thanks much
Prvn (1 Reply)
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)