All Apps and Add-ons

Problems with utf-8

gpburgett
Splunk Employee
Splunk Employee

I'm trying to export some data with Korean characters, but when I click to export I get a txt file with the following trace:

Unrecoverable error in the server.
Traceback (most recent call last):
  File "/Users/notgary/Splunk/Sites/XX_splunk/lib/python2.6/site-packages/cherrypy/_cpwsgi.py", line 163, in next
    chunk = self.iter_response.next()
  File "<string>", line 189, in generate_from_stream
  File "/Users/notgary/Splunk/Sites/XX_splunk/etc/apps/excel_export/bin/xlwt/Worksheet.py", line 1003, in write
    self.row(r).write(c, label, style)
  File "/Users/notgary/Splunk/Sites/XX_splunk/etc/apps/excel_export/bin/xlwt/Row.py", line 231, in write
    StrCell(self.__idx, col, style_index, self.__parent_wb.add_str(label))
  File "/Users/notgary/Splunk/Sites/XX_splunk/etc/apps/excel_export/bin/xlwt/Row.py", line 150, in insert_cell
    raise Exception(msg)
Exception: Attempt to overwrite cell: sheetname=u'splunk_results' rowx=0 colx=0

Everything works fine when everything is English. I'm going to keep trying, but please let me know if you have any ideas about what might be going wrong. Thanks.

1 Solution

araitz
Splunk Employee
Splunk Employee

This was just a lame error on my part. In appserver/controllers/excel.py, this:

186         # write the header
187         for field in fieldNames:
188             result_sheet.write(0,i,field)
189         i = i + 1

should be this (notice the indent):

186         # write the header
187         for field in fieldNames:
188             result_sheet.write(0,i,field)
189             i = i + 1

The fixed version is available on Splunkbase right now (version 1.1.1). You can also just make the above change (add 4 spaces on line 189) and then restart Splunk to get the same result.

View solution in original post

0 Karma

araitz
Splunk Employee
Splunk Employee

This was just a lame error on my part. In appserver/controllers/excel.py, this:

186         # write the header
187         for field in fieldNames:
188             result_sheet.write(0,i,field)
189         i = i + 1

should be this (notice the indent):

186         # write the header
187         for field in fieldNames:
188             result_sheet.write(0,i,field)
189             i = i + 1

The fixed version is available on Splunkbase right now (version 1.1.1). You can also just make the above change (add 4 spaces on line 189) and then restart Splunk to get the same result.

0 Karma

araitz
Splunk Employee
Splunk Employee

I made a few more tweaks in 1.2 which is available today.

0 Karma

araitz
Splunk Employee
Splunk Employee

EDIT: see answer below, my initial suspicions were off.

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Why Splunk Customers Should Attend Cisco Live 2026 Las Vegas

Why Splunk Customers Should Attend Cisco Live 2026 Las Vegas     Cisco Live 2026 is almost here, and this ...

What Is the Name of the USB Key Inserted by Bob Smith? (BOTS Hint, Not the Answer)

Hello Splunkers,   So you searched, “what is the name of the usb key inserted by bob smith?”  Not gonna lie… ...

Automating Threat Operations and Threat Hunting with Recorded Future

    Automating Threat Operations and Threat Hunting with Recorded Future June 29, 2026 | Register   Is your ...