问题描述
我有一个在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 R
owC
olumn2
= 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)文件中用单引号引起来的图纸名称?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!