Excel的出口数百空列在CSV出口 [英] Excel exporting hundreds of empty columns on CSV export

问题描述

在我开始，我用Excel为Mac 2011年我在与一个特定的Excel US preadsheet一个问题。当我出口任何活动工作表CSV（窗口CSV格式），其出口〜200空白列在7或8填充柱一起。我已经在过去类似的问题，发现一个网站，说要解决这个问题是要找到所有空格字符，并用空格代替它们的方式。这个工作在过去，任何空白柱不再出口。这似乎并不符合这一特定的工作簿的情况下。

Before I begin, I'm using Excel for Mac 2011. I'm having a problem with a particular Excel spreadsheet. When I export any of the active worksheets to CSV (windows CSV format), it exports ~200 blank columns along with the 7 or 8 populated columns. I've had a similar issue in the past, and found a site that said the way to fix it was to find all blank characters, and replace them with a space. This worked in the past, and any blank columns were not export anymore. This doesn't seem to be the case with this particular workbook.

有谁知道如何解决这个问题？是否有一个特定的宏，我可以用它来摆脱这些空白列，或者可能是苹果脚本的？任何帮助将大大AP preciated。

Does anyone know how to resolve this? Is there a particular macro that I can use to get rid of these blank columns, or perhaps an Apple Script? Any help would be greatly appreciated.

推荐答案

我记得这个问题与旧Excel中，即使是在Windows。

I can remember this problem with older Excel, even on Windows.

的问题是，Excel中认为这些列的工作簿的一部分。
我相信，有一种方法来选择你想要什么以及告诉Excel中的界限，但我不记得了。

The problem is that Excel thinks these columns are part of the workbook. I am sure there was a way to select just what you wanted and tell Excel the bounds, but I cannot remember.

如果你进入页面模式，你可以看到什么的Excel认为是你的数据。我想，你可以在这里解决。

If you go into page mode you can see what Excel thinks is your data. I think you can fix it here.

简单的解决方法是选择列数据的权利，选择扩展到右侧和删除列。

The easy solution is to select the column to the right of your data, extend the selection to the right and delete the columns.

这篇关于Excel的出口数百空列在CSV出口的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！