Excel input/output and send as mail commands - TA-XLS
Overview
Details
You can convert a csv file to a xls for mailing reports as well as a command to convert a worksheet in a Excel file to a csv for using with inputcsv.
Also allows to send fairly nice emails with attachments.
(For security reasons the files need to reside in $SPLUNK/var/run/splunk and be owned by the user in which splunk runs.)
New in Version 0.2:
| outputxls filename.xls
Waits till the output is finished and then writes the Excel document.
Optional:
| outputxls filename.xls "sender@email.com" "recipient@email.com" "subject of the mail" "body of the mail" "smpt hostname"
directly mails the generated Excel document with the parameters.
It is utf-8 safe.
[outputxls-command]
syntax = | outputxls filename.xls
shortdesc = generate excelsheet
description = this command will take the search results and write them into a excelsheet where the name is specified as parameter
usage = public
example1 = | outputxls myfile.xls
comment1 =
example2 = | outputxls myfile.xls "sender" "receiver" "subject" "bodyText" "smtpHost"
comment2 = generates .xls file and sends it with the specified parameters via email. (wrapps sendfile command).
related =
tags =
[xls2csv-command]
syntax = | xls2csv excelfile.xls numOfWorksheet commaseparated.csv
shortdesc = read excel file and output the specified worksheet to a csv file
description = this command will take a filename to a excel file residing in /var/run/splunk, select the sheet in the workbook specified and write it into a splunk-readable csv file
usage = public
example1 = | xls2csv test.xls 0 firstsheet.csv
comment1 = export the first sheet in the file to a csv (zero based enumeration)
related =
tags =
[csv2xls-command]
syntax = | csv2xls commaseparated.csv excelfile.xls
shortdesc = read csv file and output the table to a excel file
description = this command will take a filename to a csv file residing in /var/run/splunk and write it into a Excel file
usage = public
example1 = | csv2xls sheet.csv sheet.xls
comment1 = export the table in the file to a Excelfile
related =
tags =
[sendfile-command]
syntax = | sendfile "sender" "receiver" "subject" "bodyText" "attachment" "smtpHost"
shortdesc = send file via email
description = this command will take the file "attachment" which can only be residing in /var/run/splunk and send it via email using sender, receiver, subject via the smtpHost, usually localhost
usage = public
example1 = | sendfile "me@company.com" "you@company.com" "Your report" "See your requested report attached below..." "excelfile.xls" "localhost"
comment1 =
related =
tags =
Release Notes
Version 0.2.2
Version 0.2.1
Version 0.2.1 - python 2-3 readyness and updated libraries. No xlsx support yet sorry.
Version 0.2
New in Version 0.2:
| outputxls filename.xls
Waits till the output is finished and then writes the Excel document.
Optional:
| outputxls filename.xls "sender@email.com" "recipient@email.com" "subject of the mail" "body of the mail" "smpt hostname"
It is utf-8 safe.
Version 0.1
Initial version still lacking formatting templates for the generated excel sheets and non final interface. Really crude but seems to work ok.