04-02-2009
If you need it automated, maybe using a VBA script in Excel would be easier?
10 More Discussions You Might Find Interesting
1. HP-UX
Hi,
How can i create an excel sheet in Unix?
Actually i need the data from the tables into the excel sheet.
Please let me know.
Regards,
Puspendu (4 Replies)
Discussion started by: puspendu
4 Replies
2. 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
3. UNIX for Advanced & Expert Users
Hi, My client uploads an Excel file on to Unix server by using web application with more than 20 columns and more than 60000 records in it. I have to check the data in each cell when the file arrived. Is is possible to check the data in cells by running unix script? or Is there any way to convert... (2 Replies)
Discussion started by: sireeshp
2 Replies
4. Shell Programming and Scripting
Hi,
I am trying to find a way to read an excel work book with multiple worksheets.
And write each worksheet into a new excel file using perl. My environment is Unix.
For example: I have an excel workbook TEST.xls and it has Sheet1, Sheet2, Sheet3 worksheets. I would like to create... (2 Replies)
Discussion started by: sandeep78
2 Replies
5. Shell Programming and Scripting
Hi,
I am using Solaris 8. My script outputs 4 .csv files. Currently I am SFTPing the files and creating a new excel file with the 4 files as sheets.
Can anyone suggest ways to do this in UNIX ?
Thanks,
David. (2 Replies)
Discussion started by: libin4u2000
2 Replies
6. UNIX for Dummies Questions & Answers
Hi all,
I am faced with a rather unusual problem regarding interaction between NT and UNIX. I am using an ETL (Extract-Transform-Load) tool on unix that has the capability to read .xls files. So, when I FTP an excel (.xls) file from a windows server to unix and attempt to read it with this... (3 Replies)
Discussion started by: ucode_2482
3 Replies
7. UNIX and Linux Applications
Hi,
I want to differentiate between a MS Word and Excel file in Unix (not by extension). The condition which we are currently checking for is the pattern "\320\317\021\340" within first 40 bytes of the file. However this format is same in all MS Office files. Can somebody tell me any special... (4 Replies)
Discussion started by: phatak_rajan
4 Replies
8. Shell Programming and Scripting
Hi All
I need to put 5 different files from Unix box in 5 different tabs in a single excel. For this, I need to code only using Unix.
Kindly help me on this.
---------- Post updated at 07:23 AM ---------- Previous update was at 06:24 AM ----------
Hi All
I need to put 5 different... (2 Replies)
Discussion started by: misssrinivasan
2 Replies
9. Shell Programming and Scripting
Dear all,
I have a complex data file shown below,,,,,
A_ABCD_13208 0 0 4.16735 141044 902449 1293900 168919
C_ABCD_13208 0 0 4.16735 141044 902449 1293900 168919
A_ABCDEF715 52410.9 18598.2 10611 10754.7 122535 252426 36631.4
C_DBCDI_1353 0... (19 Replies)
Discussion started by: AAWT
19 Replies
10. Shell Programming and Scripting
All,
I have an excel sheet Excel1.xls that has some entries.
I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls
These may be in different workbooks. They are totally independent made by 2 different users.
I have placed them in a... (1 Reply)
Discussion started by: Anamika08
1 Replies
LEARN ABOUT HPUX
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)