Sponsored Content
Top Forums UNIX for Dummies Questions & Answers how to fill the name of the spread sheet as a cell's data Post 302392631 by thegeek on Friday 5th of February 2010 03:33:41 AM
Old 02-05-2010
how to fill the name of the spread sheet as a cell's data

In open office spreadsheet, i would like to fill a cell with the name of the spread sheet.


That is if the file name of spread sheet is, team.ods, then i have to fill a specific cell with that name 'team'. How to do that ?

I have more spread sheets to be created, so i want it to be done automatically. Also if i change the file name, it should change that cell value automatically.
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

how to read the data from an excel sheet and use those data as variable in the unix c

I have 3 columns in an excel sheet. c1 c2 c3 EIP_ACCOUNT SMALL_TS_01 select A.* from acc; All the above 3 col shoud be passed a variable in the unix code. 1.How to read an excel file 2.How to pass these data as variable to the unic script (1 Reply)
Discussion started by: Anne Grace
1 Replies

2. UNIX for Dummies Questions & Answers

Change the cell background in excel sheet using Perl

I need to change a cell in an excel sheet to different background color using perl. Please help regarding this. Thanks and Regards, Neelam G (1 Reply)
Discussion started by: gujrathinr
1 Replies

3. Shell Programming and Scripting

How to change cell background in excel sheet using perl

I need to change a cell in an excel sheet to different background color using perl.I tried SaveParse, but was unable to get it Please help regarding this. Thanks and Regards, Neelam G https://www.unix.com/images/misc/progress.gif (0 Replies)
Discussion started by: gujrathinr
0 Replies

4. UNIX for Dummies Questions & Answers

Validating XSL sheet data in Unix Data file

Dear All, Need your help. In my day to day activities I have to validate/search Excel Sheet data (eg.say Application No. 0066782345) data into the Unix environment file whether the same data is present in that file or not. There are hundreds of records coming in excel file and I am doing grep... (1 Reply)
Discussion started by: ravijunghare
1 Replies

5. Shell Programming and Scripting

Export into a single cell of excel sheet...

The awk is giving below output: SELECT divrel.child_org_idn org_main_idn NULL ( VARCHAR(200)) div_nam_2 NULL ( VARCHAR(200)) div_nam_3 NULL ( VARCHAR(200)) div_nam_4 NULL ( VARCHAR(200)) div_nam_5 NULL ( VARCHAR(200)) div_nam_6 NULL ( VARCHAR(200)) div_nam_7 ... (2 Replies)
Discussion started by: goutam_igate
2 Replies

6. Shell Programming and Scripting

[AWK] handeling data spread on multiple lines

Hello all, first off great forum. Now for my little problem. Using RHEL 5.4 and awk. Been doing code since a few month. So just starting. My problem is handeling data on multiple lines. { if ($1 != LASTKEY && h ~ /.*\/s_fr_/) { checkgecos( h, h ) h="" ... (2 Replies)
Discussion started by: maverick72
2 Replies

7. Shell Programming and Scripting

fill in last column of data

Hello, I am fairly new to awk, and I have the following problem. My file has missing data in the last column, and the program I am pre-processing this file for cannot interpret correctly shortened rows (it just wraps the data around). Is there a way to force awk to create the same... (6 Replies)
Discussion started by: timert34
6 Replies

8. Shell Programming and Scripting

Fill in missing Data

hello everyone, I have a task to input missing data into a file. example of my data below: Wed Feb 01 09:00:02 EST 2012,,,0.4,0.3,,0.3,,0.3,,0.5,,0.3,,,0.4,0.3, Wed Feb 01 09:00:11 EST 2012,,,,,,,0.2,,,,,,,,,, Wed Feb 01 09:00:22 EST... (23 Replies)
Discussion started by: Nolph
23 Replies

9. Shell Programming and Scripting

parsing log files in to a spread sheet

Hi Guyz, I need to extract only the data/time, uid , and the message at the last " invalid password format", to a spread sheet. this is one of the lines from a log file from which i need to extract them. i need this message to be clearly formatted in the spread sheet. can you please help me... (14 Replies)
Discussion started by: remo850
14 Replies

10. Shell Programming and Scripting

Summing up the data from different excel sheet into one excel sheet

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
thai/thcell.h(3)						      libthai							  thai/thcell.h(3)

NAME
thai/thcell.h - Thai string cell custering. SYNOPSIS
Data Structures struct thcell_t Thai char cell representation. Functions void th_init_cell (struct thcell_t *cell) Initialize a Thai cell. size_t th_next_cell (const thchar_t *s, size_t len, struct thcell_t *cell, int is_decomp_am) Get first cell from string. size_t th_prev_cell (const thchar_t *s, size_t pos, struct thcell_t *cell, int is_decomp_am) Get previous cell from string. size_t th_make_cells (const thchar_t *s, size_t len, struct thcell_t cells[], size_t *ncells, int is_decomp_am) Tokenize string into cells. Detailed Description Thai string cell custering. Function Documentation void th_init_cell (struct thcell_t *cell) Initialize a Thai cell. Parameters: cell : pointer to the cell to initialize Initializes values in the Thai cell struct. size_t th_make_cells (const thchar_t *s, size_tlen, struct thcell_tcells[], size_t *ncells, intis_decomp_am) Tokenize string into cells. Parameters: s : the string len : the length of string cells : the array of output cells buffer ncells : the address of integer storing the number of cells provided by the buffer, and to keep the number of resulting cells on return is_decomp_am : whether SARA AM is to be decomposed into NIKHANIT and SARA AA and to be in separate cells Returns: total characters consumed Tokenizes the string bounded by s and len into cells, and stores at most *ncells resulting cells in the cells buffer. On return, *ncells is also set to the total cells stored in cells[]. size_t th_next_cell (const thchar_t *s, size_tlen, struct thcell_t *cell, intis_decomp_am) Get first cell from string. Parameters: s : the string len : the length of string cell : the output buffer is_decomp_am : whether SARA AM is to be decomposed into NIKHANIT and SARA AA and to be in separate cells Returns: total chars consumed by the cell Gets first cell from the string bounded by s and len, and, if cell is not null, stores the cell data in it. size_t th_prev_cell (const thchar_t *s, size_tpos, struct thcell_t *cell, intis_decomp_am) Get previous cell from string. Parameters: s : the string pos : the position in string to get cell previous to cell : the output buffer is_decomp_am : whether SARA AM is to be decomposed into NIKHANIT and SARA AA and to be in separate cells Returns: total chars consumed by the cell Gets last cell from the string bounded by s and pos, and if cell is not null, stores the cell data in it. Author Generated automatically by Doxygen for libthai from the source code. Version 0.1.14 Tue Jun 17 2014 thai/thcell.h(3)
All times are GMT -4. The time now is 06:04 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy