01-13-2011
Read microsoft excel in Unix
Hey guys,
Can we read a microsoft excel spreadsheet in Unix / linux. If so, what are the steps to be followed?
I know we can convert the excel workbook as a CSV and then read it in unix. Are there any other direct methods?
thanks
prasan81
5 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have the Ms Excel file(test.xls) in my UNIX box. I would like to read the excel file and create files for each column.
Please find an example.
My excel file like this data:
Num Data
1 a1
2 b2
3 c3
4 d4
5 e5
6 f6
7 h7
My output:
I want create 2 files(num.log and... (3 Replies)
Discussion started by: koti_rama
3 Replies
2. Shell Programming and Scripting
I would like to read data from excel sheet as a input to a shell script.
Myproblem is the excel sheet is in windows. How can I write a shell script to read data from that excel sheet?
How can I do that?. (4 Replies)
Discussion started by: vj8436
4 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I'm newbie in UNIX. I would like to ask how to read a file which in Microsoft word format? Inside the doc file is just a few sentences . "It is a text. Help me with it". and I would like to replace the the word of text to message.
I was trying with this
for i in `find . -type f -name... (8 Replies)
Discussion started by: tee
8 Replies
4. Shell Programming and Scripting
Hi
HOWTO create in UNIX a Microsoft Excel sheet (with data from Oracle). At the moment I am making CSV files (using SQL statemens with || ';'), but search for more advanced formatting. Don't wish to use Perl.
cheers (4 Replies)
Discussion started by: slashdotweenie
4 Replies
5. UNIX and Linux Applications
Hi,
I want the Perl script with versions 5.8.2 and 5.8.5 starting with
#!/usr/bin/perl
The Perl program should read the excel file or text file line by line and taking into an array and search in the UNIX directories for reference file of .jsp or .js or .xsl with path .The Object names... (2 Replies)
Discussion started by: pasam
2 Replies
LEARN ABOUT PHP
finfo_file
FINFO_FILE(3) 1 FINFO_FILE(3)
finfo_file - Return information about a file
Procedural style
SYNOPSIS
string finfo_file NULL NULL (resource $finfo, string $file_name, [int $options = FILEINFO_NONE], [resource $context])
DESCRIPTION
Object oriented style string finfo::file NULL NULL (string $file_name, [int $options = FILEINFO_NONE], [resource $context])
This function is used to get information about a file.
PARAMETERS
o $finfo
- Fileinfo resource returned by finfo_open(3).
o $file_name
- Name of a file to be checked.
o $options
- One or disjunction of more Fileinfo constants.
o $context
- For a description of contexts, refer to "Stream Functions".
RETURN VALUES
Returns a textual description of the contents of the $file_name argument, or FALSE if an error occurred.
EXAMPLES
Example #1
A finfo_file(3) example
<?php
$finfo = finfo_open(FILEINFO_MIME_TYPE); // return mime type ala mimetype extension
foreach (glob("*") as $filename) {
echo finfo_file($finfo, $filename) . "
";
}
finfo_close($finfo);
?>
The above example will output something similar to:
text/html
image/gif
application/vnd.ms-excel
SEE ALSO
finfo_buffer(3).
PHP Documentation Group FINFO_FILE(3)