03-23-2010
There should be some perl module for it. Similar stuff has been asked before - use the search engine of the forum please. Maybe use "perl excel".
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
How can we export a file in unix with certain number of columns to an excel sheet.
It's very useful in time saving...... (3 Replies)
Discussion started by: bishweshwar
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. 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
4. Shell Programming and Scripting
Hi,
Would anyone be able to tell me how to check the number of rows in an excel sheet on unix box, please?
Cheers,
Girish. (2 Replies)
Discussion started by: girish1428
2 Replies
5. Shell Programming and Scripting
Hi,
Is there a way to find the count of number of rows of a.txt please? Where a.txt is as follows:
/usr/bin/uuencode /tmp/a.csv a.csv > /tmp/a.txt
#a.csv is a comma separated variable file
Cheers,
Girish. (7 Replies)
Discussion started by: girish1428
7 Replies
6. Shell Programming and Scripting
I have an Excel 2007 excel sheet on windows machine and using
Spreadsheet::XLSX I had written a script to read the excel sheet and was successful.
My requirement is I need to generate another excel sheet from the old excel 2007 sheet on unix machine.
Now is it possible to read the excel... (2 Replies)
Discussion started by: giridhar276
2 Replies
7. Shell Programming and Scripting
Hi folks,
I have a requirement in perl to print all the hyperlink from the spreadsheet(xlsx).
Spreadsheet contains few lines of hyperlink data (pic attached).
P.S. Hyperlink is behind the data and not visible in excel sheet directly.
Now using perl script I need to copy the hyperlinks in... (3 Replies)
Discussion started by: scriptscript
3 Replies
8. UNIX for Dummies Questions & Answers
Hi,
i have some data in a temporary file in Unix (the data is taken from the result of an SQL query). Now i want to dump that data into an excel sheet. How to do that. Someone please advise. Thanks
Regards,
Vinit (3 Replies)
Discussion started by: vinit raj
3 Replies
9. UNIX for Dummies Questions & Answers
hi,
i wanted to add unix data to be updated to the excel sheet. (3 Replies)
Discussion started by: rupesh.bombale
3 Replies
10. Shell Programming and Scripting
Hi Folks,
Can you please advise for any script in unix such that for example , i have 3 different excel sheet at the location /ppt/gfr/exc so the name s of the excel sheet are
1excel.xslx
2excel.xslx
3excel.xslx
now in these 3 different excel sheet there is lot of data for example each... (3 Replies)
Discussion started by: punpun66
3 Replies
LEARN ABOUT REDHAT
xmtablistreplacepositions
XmTabListReplacePositions(library call) XmTabListReplacePositions(library call)
NAME
XmTabListReplacePositions -- A convenience function that creates a new tab list with replacement tabs
SYNOPSIS
#include <Xm/Xm.h>
XmTabList XmTabListReplacePositions(
XmTabList oldlist,
Cardinal *position_list,
XmTab *tabs,
Cardinal tab_count);
DESCRIPTION
XmTabListReplacePositions creates a new tab list that contains the contents of oldlist, but with the tabs at the positions in position_list
replaced with copies of the corresponding tabs in tabs. A warning message is displayed if a specified position is invalid; for example, if
the value is a number greater than the number of tabs in the tab list.
This function deallocates the original tab list after extracting the required information. It is the caller's responsibility to free the
tabs in tabs by using the XmTabFree function.
oldlist Specifies the tab list. The function deallocates the tab list after extracting the required information.
position_list
Specifies an array of positions of the tabs to be replaced. The position of the first tab is 0 (zero), the position of the second
tab is 1, and so on.
tabs Specifies an array of the replacement tabs.
tab_count Specifies the number of elements in position_list and tabs.
RETURN
If tabs, oldlist, or position_list is NULL, or tab_count is 0 (zero), returns oldlist. Otherwise, this function returns the new tab list.
The function allocates space to hold the returned tab list. The application is responsible for managing the allocated space. The applica-
tion can recover the allocated space by calling XmTabListFree.
RELATED
XmTabList(3).
XmTabListReplacePositions(library call)