将excel保存为xml时保留空单元格 [英] preserve empty cells when saving excel as xml

问题描述

我有一个Excel文档，其中某些单元格为空 当我将Excel保存为xml Spreadcheet时，我得到的行仅包含有数据的单元格，并且空单元格消失了(随后的单元格获得了一个index属性来指示其真实位置) 有没有一种方法可以将excel保存为xml，并显示空单元格以节省空间? 我在该xml上运行xsl，即使它为空，也需要准确知道一个单元格的值

I have an excel document where some of the cells are empty When i save the excel as xml spreadcheet i get the row with only the cells that have data and and the empty cells disapear (and the following cell gets an index attribute to indicate his true position) Is there a way to save the excel in xml and have the empty cells apear insted of saving space ? I am running xsl on that xml and need to know the value of a cell exactly even if its empty

推荐答案

从您的问题尚不清楚，您是否在谈论内部内部或外部外部的空单元格>数据.如果您要谈论的是数据区域之外的空单元，那么您将无能为力，因为它实际上是无限数量的单元.如果要具有更多的单元格或行，则始终可以在导入后简单地填充单元格.

From your question it is not clear if you are talking about empty cells within the data or cell outside the data. If you are talking about empty cells outside of the data area than there is not much you can do since it is effectively an infinite number of cells. You could always simply pad the cells after importing if you want to have more cells or rows.

这篇关于将excel保存为xml时保留空单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！