Other Usage

How to create a report in Excel format ( .xls)

abhayneilam
Contributor

Splunk generates five .csv files which I import to an excel sheet to make a complete workbook which contains five tabs, tab_one tab_two tab_three tab_four tab_five

I am importing each csv file to each tab:

file1.csv to tab_one
file2.csv to tab_two
file3.csv to tab_three
file4.csv to tab_four
file5.csv to tab_five

My requirement is to reduce this manual task, means, I want to directly generate an excel sheet from splunk which would contain all the five tabs along with the data corresponding to each tab..

please suggest !!

Thanks,
Abhay

Tags (2)
0 Karma

rafadvega
Path Finder

I think the only option is to use the api to get the results and create the .xls file. In python, it should be easy. If you have access to the api and want help to develop this, I can make an example.

0 Karma

mamta_sonilv
New Member

Kindly check the excel tutorial
I hope you can solve your problem
thanks a lot

0 Karma

Damien_Dallimor
Ultra Champion

I would check out OData for Splunk.

abhayneilam
Contributor

Hi,

I am not finding any way to do that...please help me with the correct procedure

Thanks
Abhay

0 Karma

bmacias84
Champion

Currently I don't believe this capacility currently exists in Splunk. If you have some programatic skills you could use the REST API then build your Xls workbook Or have Splunk build your csv then excel macro read the csv to the correct tab.

http://www.python-excel.org/

http://www.excel-vba-easy.com/

0 Karma
Get Updates on the Splunk Community!

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...

Splunkbase | Splunk Dashboard Examples App for SimpleXML End of Life

The Splunk Dashboard Examples App for SimpleXML will reach end of support on Dec 19, 2024, after which no new ...

Understanding Generative AI Techniques and Their Application in Cybersecurity

Watch On-Demand Artificial intelligence is the talk of the town nowadays, with industries of all kinds ...