Splunk Search

Want to create five tabs in excel

abhayneilam
Contributor

I have five excels which get generated through SPLUNK, Now I want to generated one more excel file which would contain five tabs, each ta
b will contain the content of corresponding excel.

  1. if it is possible in perl scripting, kindly let me know how to do it and how to call this script in splunk.
  2. if it is possible through SPLUNK, then please let me know how to do this ..

This is really needed in urgent basis ..
Please help !!

Thanks in Advance
Abhay

Tags (5)
0 Karma

yannK
Splunk Employee
Splunk Employee

Please search the Splunk answer forum before asking a question that has already be answered.

yannK
Splunk Employee
Splunk Employee

As far as I remember Splunk can only export csv files, not excel files.
see http://docs.splunk.com/Documentation/Splunk/5.0/SearchReference/Outputcsv

So if you need multi tabs excel documents, you have to generate each tab as a csv, then merge then manually, or write a script to do it.

Microsoft excel forums have plenty of them
https://sites.google.com/a/madrocketscientist.com/jerrybeaucaires-excelassistant/merge-functions/csv...

Even paid programs exists http://bulkfilemerger.com/index1

Ayn
Legend

If you're dealing with such urgent matters it might be a good idea to contact Splunk directly and have support or professional services help you out. On this site people volunteer to answer questions.

Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...