08-17-2013
Except for the perl EXCEL module (which I don't know by heart) I'm not aware of any possibility to modify spread sheet with unix tools, What you can do is create text file in csv- format and import those into the sheets.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
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. Shell Programming and Scripting
Hi all
I have a shell script that uses a stored proc to generate output from some tables and send the same in an e-mail using mailx command. Now I need to convert the output to excel format and send e-mail. How can I achieve this. Please help me in this regard, as it's very urgent and I have been... (5 Replies)
Discussion started by: sanbabu
5 Replies
3. Shell Programming and Scripting
Hi,
I have an excel sheet which has 100000 records. All these records are having 3 columns each with the last column as "Y" or "N". I would like to filter those records which has the value "Y". Can you please let me know how to proceed with that?
Thanks in advance.
-Sri
----------... (8 Replies)
Discussion started by: bhanusri83
8 Replies
4. 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
5. Shell Programming and Scripting
Hi folks,
I am working on assignment that captures all the records(2 columns one column contains names and other contain date of birth) from excel sheet stored in a directory and checks for current date and month.
If it matches current date and month then the matched records are printed as... (1 Reply)
Discussion started by: giridhar276
1 Replies
6. Programming
guys i have data in excel sheet , how do i convert that data to database table (2 Replies)
Discussion started by: Gl@)!aTor
2 Replies
7. Shell Programming and Scripting
Hi All, Firstly I will like to wish A Happy New Year to all.
Now my issue is
I have one csv file say(data.csv) and one excel file say(result.xls)
The result.xls contains two sheet name Sheet1 and Sheet2, Now What I am trying to do is to First I want to delete that data of Sheet2 if present any,... (6 Replies)
Discussion started by: adisky123
6 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. Shell Programming and Scripting
Hello,
I have the following data format in a log file :
a : x1
b : x2
c : x3
d : x4
--------
a : x5
b : x6
c : x7
d : x8
so the same fields ( a ,b ,c,d) repeated many times in the same log file but with different "x" values (x5,x6,x7,x8).
I need a script to save this data in an... (6 Replies)
Discussion started by: mm00123
6 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 DEBIAN
mactime-sleuthkit
MACTIME(1) General Commands Manual MACTIME(1)
NAME
mactime - Create an ASCII time line of file activity
SYNOPSIS
mactime [-b body ] [-g group file ] [-p password file ] [-i (day|hour) index file ] [-dhmVy] [-z TIME_ZONE ] [DATE_RANGE]
DESCRIPTION
mactime creates an ASCII time line of file activity based on the body file specified by '-b' or from STDIN. The time line is written to
STDOUT. The body file must be in the time machine format that is created by 'ils -m', 'fls -m', or the mac-robber tool.
ARGUMENTS
-b body
Specify the location of a body file. This file must be generated by a tool such as 'fls -m' or 'ils -m'. The 'mac-robber' and
'grave-robber' tools can also be used to generate the file.
-g group file
Specify the location of the group file. mactime will display the group name instead of the GID if this is given.
-p password file
Specify the location of the passwd file. mactime will display the user name instead of the UID of this is given.
-i day|hour index file
Specify the location of an index file to write to. The first argument specifies the granularity, either an hourly summary or daily.
If the '-d' flag is given, then the summary will be separated by a ',' to import into a spread sheet.
-d Display timeline and index files in comma delimited format. This is used to import the data into a spread sheet for presentations
or graphs.
-h Display header info about the session including time range, input source, and passwd or group files.
-V Display version to STDOUT.
-m The month is given as a number instead of name.
-y The date range is given with the year first.
-z TIME_ZONE
The timezone from where the data was collected. The name of this argument is system dependent (examples include EST5EDT, GMT+1).
DATE_RANGE
The range of dates to make the time line for. The standard format is yyyy-mm-dd for a starting date and no ending date. For an end-
ing date, use yyyy-mm-dd..yyyy-mm-dd.
LICENSE
The changes from mactime in TCT and mac-daddy are distributed under the Common Public License, found in the cpl1.0.txt file in the The
Sleuth Kit licenses directory.
HISTORY
A version of mactime first appeared in The Coroner's Toolkit (TCT) (Dan Farmer) and later mac-daddy (Rob Lee).
AUTHOR
Brian Carrier <carrier at sleuthkit dot org>
Send documentation updates to <doc-updates at sleuthkit dot org>
MACTIME(1)