how to fill the name of the spread sheet as a cell's data

10 More Discussions You Might Find Interesting

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

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

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

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

5. 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="" ...

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

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

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

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

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

LEARN ABOUT DEBIAN

xls2csv

xls2csv(1)						      General Commands Manual							xls2csv(1)

NAME

       xls2csv - reads MS-Excel file and puts its content as comma-separated data on standard output

SYNOPSIS

       xls2csv [-xlV] [-f  format ] [-b  string ] [-s  charset ] [-d  charset ] [-q  number ] [-c  char] files

DESCRIPTION

       xls2csv	reads  MS-Excel  spreadsheet  and  dumps  its content as comma-separated values to stdout. Numbers are printed without delimiters,
       strings are enclosed in the double quotes. Double-quotes inside string are doubled.

OPTIONS

       -x      print unknown Unicode chars as xNNNN, rather than as question marks

       -l      list known charsets and exit successfully

       -cchar  cell separator char. By default - comma.

       -bstring
	       sheet break string. This string (by default - formfeed) would be output at the end of each workbook page. This  string  is  printed
	       after page starting at start of line, but no linefeed would be automatically added at the end of string. Include newline at the ent
	       of sheet separator if you want it to appear on separate line by itself

       -gnumber number of decimal digits in the numbers. By default maximal double precision (system-dependent macro DBL_DIG) is used.

       -qnumber
	       set quote mode. In quote mode 0 cell contents is never quoted.  In quote mode 1 only strings which contain spaces, double quotes or
	       commas are quoted.  In quote mode 2 (default) all cells with type string are quoted.  In quote mode 3 all cells are quoted.

       -dcharset`
	       -  specifies  destination  charset  name.  Charset file has format described in CHARACTER SETS section of catdoc(1) manual page. By
	       default, current locale charset would be used if langinfo support was enabled at the compile time.

       -scharset
	       - specifies source charset. Typically, Excel files have CODE PAGE record, which denotes input charset, but for some reason you  may
	       wish to override it.

       -fformat
	       - specifies date/time format to use for output of all Excel date and time  values.  If this option is not specified, format, speci-
	       fied in the spreadsheet is used. On POSIX system any format, allowed by strftime(3) can be used as value of this option. Under  MS-
	       DOS xls2csv implements limited set of strftime formats, namely m, d, y, Y, b, l, p, H, M, S.

       -V      outputs version number

FILES

       ${HOME}/.catdocrc, catdoc charset files and substitution map files (see catdoc(1) manual page for details,

SEE ALSO

       cat(1), catdoc(1), strings(1), utf8(7), unicode(7)

AUTHOR

       V.B.Wagner <vitus@45.free.net>, based on biffview by David Rysdam

MS-Word reader							  Version 0.94.4							xls2csv(1)

UNIX for Dummies Questions & Answers