Excel何时在workbook.xml(或其他xml)文件中用单引号引起来的图纸名称? [英] When does Excel surround sheet names with single quotes in workbook.xml (or other xml) files?

问题描述

我有一个在Excel中打开的.xlsx文件.但是，如果我在workbook.xml的已定义名称"字段中删除工作表名称(不包含空格)周围的单引号，则Excel将通过删除该已定义名称来修复文件.

I have an .xlsx file that opens in Excel. However, if I remove the single quotes around the sheet name (which does not contain spaces) in the defined names field in workbook.xml, Excel repairs the file by removing that defined name.

任何人都可以告诉条件我们何时必须用单引号将工作表名称括起来?

Can anyone tell the criteria when do we have to surround the sheetname with single quotes?

文件在这里: https://www.dropbox.com/sh/eziv9jlbpsppw83/AACwurdX_aOhdK4RFR? 0

00007113-ENGLISH_original.xlsx-在Mac Excel 2011中打开

00007113-ENGLISH_original.xlsx - Opens in Mac Excel 2011

00007113-ENGLISH_exported.xlsx-无法打开(修复"对话框)

00007113-ENGLISH_exported.xlsx - Does not open (Repair dialog)

推荐答案

似乎没有一般性描述.

There seems not to be a general description.

但是我可以告诉您，为什么Excel用引用'RC2ACQuotas'!$A$1:$Q$213中的引号将工作表名称RC2ACQuotas括起来.这是因为RC2也是R1C1表示法中的单元格引用.这意味着R ow C olumn 2 =此行列2.

But I can tell you why Excel surrounds the sheet name RC2ACQuotas with quotes in the reference 'RC2ACQuotas'!$A$1:$Q$213. It is because RC2 also is a cell reference in R1C1 notation. It means RowColumn2 = this row column 2.

这似乎不是必然的，因为Excel用引号将工作表名称A123引起来，而A123Test则没有.但是以R1C1表示法以单元格引用开头的工作表名称将始终被包围.

This seems not to be consequent since Excel surrounds a sheet name A123 with quotes but A123Test not. But sheet names starting with a cell reference in R1C1 notation will always be surrounded.

这篇关于Excel何时在workbook.xml(或其他xml)文件中用单引号引起来的图纸名称?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！