Broken XLSX Because Of "vertical Tab" Ascii Character In A Cell #234

Home » Code Ascii Tabulation Excel » Broken XLSX Because Of "vertical Tab" Ascii Character In A Cell #234

Maybe your like

Skip to content Dismiss alert {{ message }} / exceljs Public
  • Notifications You must be signed in to change notification settings
  • Fork 2k
  • Star 15.1k
  • Code
  • Issues 647
  • Pull requests 137
  • Discussions
  • Actions
  • Projects
  • Security
  • Insights
Additional navigation options Broken XLSX because of "vertical tab" ascii character in a cell #234New issueNew issueClosedClosedBroken XLSX because of "vertical tab" ascii character in a cell#234@apydo

Description

@apydoapydoopened on Nov 30, 2016

Excel reports a broken xlsx file if there is an ascii code 0x0B or decimal 11 in a cell. It's also known as VT or "Vertical Tab". Excel consider this character as illegal in xml and the xlsx is broken if it's inside xml found in sharedStrings.xml file.

Is there any function that escapes illegal characters in a string before it's assigned to the cell ?

Metadata

Metadata

Assignees

No one assigned

Labels

No labelsNo labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions

You can’t perform that action at this time.

Tag » Code Ascii Tabulation Excel