Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Script to generate text file from excel file
Top Forums UNIX for Dummies Questions & Answers Script to generate text file from excel file Post 302161364 by jyoung on Thursday 24th of January 2008 09:32:04 AM
Old 01-24-2008
Here is a link to Active State web site that has examples of how you can extract cells from an Excel spreadsheet.
ActivePerl 5.8 - Online Docs : Using OLE with Perl

This is a windows solution and you would have to use Active State perl. I believe if you do a search of this forum you should find other solutions that will work with unix and/or linux. Good luck.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

KSH - help needed for creating a script to generate xml file from text file

Dear Members, I have a table in Oracle DB and one of its column name is INFO which has data in text format which we need to fetch in a script and create an xml file of a new table from the input. The contents of a single cell of INFO column is like: Area:app - aam Clean Up Criteria:... (0 Replies)
Discussion started by: Yoodit
0 Replies

2. Shell Programming and Scripting

a shell script to generate an excel sheet from a text file..

hi, i have a text file that looks like this! i want to generate an excel sheet out of it, removing all the junk data except the addresses that look like . Arrow Electrical Services Rotating Machinery, Electrical Contracting & Mining Specialists Onsite maintenance, breakdown... (8 Replies)
Discussion started by: vemkiran
8 Replies

3. Shell Programming and Scripting

How to convert excel file to csv file or text file?

Hi all, I need to find a way to convert excel file into csv or a text file in linux command. The reason is I have hundreds of files to convert. Another complication is the I need to delete the first 5 lines of the excel file before conversion. so for instance input.xls description of... (6 Replies)
Discussion started by: johnkim0806
6 Replies

4. Shell Programming and Scripting

Need help on inserting data from text file to excel using shell script

Hi, Please help me on this. I want to insert data from text file to excel using shell script nawk -v r=4 -v c=4 -v val=$a -F, 'BEGIN{OFS=","}; NR != r; NR == r {$c = val; print}' "file.csv" I used above one to insert $a value in 4th row, 4th column in an excel file.csv and it... (3 Replies)
Discussion started by: suman.frnz
3 Replies

5. Shell Programming and Scripting

How to write text file data to excel using UNIX shell script?

Hi All, I have the requirement in unix shell script. I want to write the "ls -ltr" command out put to excel file as below. Input :text file data : drwxr-xr-x 5 root root 4096 Oct 2 12:26 drwxr-xr-x 2 apx aim 4096 Nov 29 18:40 drwxr-xr-x 5 root root 4096 Oct 2 12:26 drwxr-xr-x... (10 Replies)
Discussion started by: Balasankar
10 Replies

6. Shell Programming and Scripting

Shell Script for copying text file to Excel Sheet

Hi, I want to write a program to copy a log file to Excel sheet. Excel sheet has four columns MethodName , Code , Description, Details and Time. I want to pick these info from text file and put it in excel sheet. here is how the text file looks - 04.17.2014 08:06:12,697... (1 Reply)
Discussion started by: hershey
1 Replies

7. Shell Programming and Scripting

Need to convert delimited text file in UNIX to an Excel file

Dear Users , Need to convert delimited text files in UNix server to an Excel file and move the excel file to Windows environment. Am trying to automate the whole process. Can anyone share the ideas,if they have done similar ones before...Thanks -Meera (1 Reply)
Discussion started by: meerakrish
1 Replies

8. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies

9. Shell Programming and Scripting

Need help to write a shell script to convert text file to excel file.

Hi Everyone, I want your help to write a script which will take text file as input and on the basis of delimiter ":"script will create excel sheet. Example input: IpAdress:InstanceName:Port:ServerName 10.255.255.1:abc:2232:xyz_abc Output should be an excel sheet like below: Column... (8 Replies)
Discussion started by: akabhinav18
8 Replies

10. 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

LEARN ABOUT REDHAT

qfilepreview

QFilePreview(3qt)														 QFilePreview(3qt)

NAME

       QFilePreview - File previewing in QFileDialog

SYNOPSIS

       #include <qfiledialog.h>

   Public Members
       QFilePreview ()
       virtual void previewUrl ( const QUrl & url ) = 0

DESCRIPTION

       The QFilePreview class provides file previewing in QFileDialog.

       This class is an abstract base class which is used to implement widgets that can display a preview of a file in a QFileDialog.

       You must derive the preview widget from both QWidget and from this class. Then you must reimplement this class's previewUrl() function,
       which is called by the file dialog if the preview of a file (specified as a URL) should be shown.

       See also QFileDialog::setPreviewMode(), QFileDialog::setContentsPreview(), QFileDialog::setInfoPreview(),
       QFileDialog::setInfoPreviewEnabled(), QFileDialog::setContentsPreviewEnabled().

       For an example of a preview widget see qt/examples/qdir/qdir.cpp.

       See also Miscellaneous Classes.

MEMBER FUNCTION DOCUMENTATION

QFilePreview::QFilePreview ()
       Constructs the QFilePreview.

void QFilePreview::previewUrl ( const QUrl & url ) [pure virtual]
       This function is called by QFileDialog if a preview for the url should be shown. Reimplement this function to provide file previewing.

SEE ALSO

       http://doc.trolltech.com/qfilepreview.html http://www.trolltech.com/faq/tech.html

COPYRIGHT

       Copyright 1992-2001 Trolltech AS, http://www.trolltech.com.  See the license file included in the distribution for a complete license
       statement.

AUTHOR

       Generated automatically from the source code.

BUGS

       If you find a bug in Qt, please report it as described in http://doc.trolltech.com/bughowto.html.  Good bug reports help us to help you.
       Thank you.

       The definitive Qt documentation is provided in HTML format; it is located at $QTDIR/doc/html and can be read using Qt Assistant or with a
       web browser. This man page is provided as a convenience for those users who prefer man pages, although this format is not officially
       supported by Trolltech.

       If you find errors in this manual page, please report them to qt-bugs@trolltech.com.  Please include the name of the manual page
       (qfilepreview.3qt) and the Qt version (3.1.1).

Trolltech AS							  9 December 2002						 QFilePreview(3qt)
All times are GMT -4. The time now is 03:52 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy