[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 =
Version 0.2.1 - python 2-3 readyness and updated libraries. No xlsx support yet sorry.
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.
Initial version still lacking formatting templates for the generated excel sheets and non final interface. Really crude but seems to work ok.
As a Splunkbase app developer, you will have access to all Splunk development resources and receive a 10GB license to build an app that will help solve use cases for customers all over the world. Splunkbase has 1000+ apps from Splunk, our partners and our community. Find an app for most any data source and user need, or simply create your own with help from our developer portal.