Excel 在 CSV 导出时导出数百个空列 [英] Excel exporting hundreds of empty columns on CSV export

问题描述

在开始之前，我使用的是 Excel for Mac 2011.我在使用特定的 Excel 电子表格时遇到了问题.当我将任何活动工作表导出为 CSV(Windows 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.

有谁知道如何解决这个问题?是否有一个特定的宏可以用来摆脱这些空白列，或者 Apple 脚本?任何帮助将不胜感激.

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屋！