Hi,
I have a question about using C to write excel file.
There is a way to write into a sheet into a file excel, like this:
FILE * File;
pMyFile = fopen("test.xls", "w+");
fprintf(File, "\n\n"); /* go to the row 2 of the column A*/
fprintf(File, "%s", "Hi pippo!"); /* write... (7 Replies)
Hi,
There is this requirement to create multiple work sheets in an MS Excel file through UNIX.
We normally can create one work sheet in unix by either tab or comma delimiting and appending .xls or .csv to the file name, but can we create multiple work sheets.
Regards,
Puspendu (1 Reply)
Hi,
I have generated an excel sheet using a shell script. i have converted the output text file to an excel and got the desired output. However, in a particular column in the excel the values of the numbers start with 0.
e.g. 078393343, 00342442, etc.
But, in the resulting excel I get as... (2 Replies)
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)
Hi,
I need your help in sedning sql queries output to different excel sheets.
My requirement is like this:
Query1: Select name from table1 where status = 'Complete'
Query2: Select name from table1 where status = 'Failed'
Query3: Select name from table1 where status = 'Ignored'
... (4 Replies)
Hi
I need to modify an excel file in perl and for which I installed perl in
Linux
1. Open a existing excel file
2. delete an unwanted Sheet called "summary"
3. and i want to insert some data into range of cells ( B1:B11)
4. Remove unwanted value called "Sum" repeated in the... (1 Reply)
Hi UNIX Gods!
Is it possible to merge two cells in .csv file using unix commands?
Imagine that this is my present csv file opened via excel:
Gate Reports| |
fatal alerts | 200 |
is is possible to make it look like this using unix?
Gate Reports |
fatal... (1 Reply)
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)
I have requirement to write two CSV files to one single excel with multiple sheets.
Data present in the two files should sit in excel as different sheets.
How can we achieve this using shell script?
1.csv 2. csv
1,2,3,4 5,6,7,8
XXXXX YYYYY
Res.excel
1.csv data... (1 Reply)
Dear all,
I have a large dictionary database which has the following structure
source word=target word
e.g.
book=livre
Since the database is very large in spite of all the care taken, it so happens that at times the source word is repeated
e.g.
book=livre
book=tome
Since I want to... (7 Replies)
Discussion started by: gimley
7 Replies
LEARN ABOUT OSF1
ldiv
abs(3) Library Functions Manual abs(3)delim $$NAME
abs, div, labs, ldiv - Computes absolute value and division of integers
LIBRARY
Standard C Library (libc.a)
SYNOPSIS
#include <stdlib.h>
int abs (
int i );
long labs (
long i );
div_t div (
int numerator ,
int denominator);
ldiv_t ldiv (
long numerator,
long denominator);
PARAMETERS
For abs(), specifies some integer. For labs(), specifies some long integer. For div(), specifies some integer. For ldiv(), specifies
some long integer. For div(), specifies some integer. For ldiv(), specifies some long integer.
DESCRIPTION
The abs() function returns the absolute value of its integer operand.
The div() function computes the quotient and remainder of the division of the numerator numerator by the denominator denominator. If the
division is inexact, the sign of the resulting quotient is that of the algebraic quotient, and the magnitude of the resulting quotient is
the largest integer less than the magnitude of the algebraic quotient. If the result cannot be represented (for example, if the denominator
is 0), the behavior is undefined. The div() function returns a value of type div_t, comprising both the quotient and the remainder.
The labs() and ldiv() functions perform the same functions as abs() and div() respectively, but accept long integers rather than integers
as parameters. The ldiv() function returns a value of type ldiv_t, comprising both the quotient and the remainder.
NOTES
The abs(), labs(), div(), and ldiv() functions are supported for multithreaded applications.
A two's-complement integer can hold a negative number whose absolute value is too large for the integer to hold. When given this largest
negative value, the abs() function returns the same value. Full use
RETURN VALUES
The abs() function and labs() function return the absolute value of their arguments.
The div() function returns a value of type div_t and the ldiv() function returns a value of type ldiv_t.
RELATED INFORMATION
Functions: floor(3) delim off delim off
abs(3)