icon/x Created with Sketch.

Splunk Cookie Policy

We use our own and third-party cookies to provide you with a great online experience. We also use these cookies to improve our products and services, support our marketing campaigns, and advertise to you on our website and other websites. Some cookies may continue to collect information after you have left our website. Learn more (including how to update your settings) here.
Accept Cookie Policy

Accept License Agreements

This app is provided by a third party and your right to use the app is in accordance with the license provided by that third-party licensor. Splunk is not responsible for any third-party apps and does not provide any warranty or support. If you have any questions, complaints or claims with respect to this app, please contact the licensor directly.

Thank You

Downloading Excel input/output and send as mail commands - TA-XLS
SHA256 checksum (excel-inputoutput-and-send-as-mail-commands-ta-xls_02.zip) aefe91cabce409de781ba1fa4ead737201f036b6275c7201fc16b3d2143e80f4 SHA256 checksum (excel-inputoutput-and-send-as-mail-commands-ta-xls_01.tgz) f35b7f0ab2532552c89987a69ddfb72340069b97ec3786ec4875a33a612eafec
To install your download
For instructions specific to your download, click the Details tab after closing this window.

Flag As Inappropriate

Excel input/output and send as mail commands - TA-XLS

Overview
Details
Contains commands to generate/export Excel sheets.

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
Jan. 13, 2016

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
July 23, 2014

Initial version still lacking formatting templates for the generated excel sheets and non final interface. Really crude but seems to work ok.

87
Installs
889
Downloads
Share Subscribe LOGIN TO DOWNLOAD

Subscribe Share

AppInspect Tooling

Splunk AppInspect evaluates Splunk apps against a set of Splunk-defined criteria to assess the validity and security of an app package and components.

Are you a developer?

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 and add-ons from Splunk, our partners and our community. Find an app or add-on for most any data source and user need, or simply create your own with help from our developer portal.

Follow Us:
© 2005-2019 Splunk Inc. All rights reserved.
Splunk®, Splunk>®, Listen to Your Data®, The Engine for Machine Data®, Hunk®, Splunk Cloud™, Splunk Light™, SPL™ and Splunk MINT™ are trademarks and registered trademarks of Splunk Inc. in the United States and other countries. All other brand names, product names, or trademarks belong to their respective owners.