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.
This is really needed in urgent basis ..
Please help !!
Thanks in Advance
Abhay
Please search the Splunk answer forum before asking a question that has already be answered.
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
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.