减少Excel的文件大小 [英] Reduce the file size of Excel

问题描述

我正在 excel application并提供一个菜单给用户在该excel应用程序（Excel工作簿）中添加新的工作表。

I'm working in an excel application and providing a menu to the user to add a new worksheet in that excel application (Excel Workbook).

一旦用户点击确定按钮，工作表将被添加我正在使用一个模板添加这个工作表（模板中有很多格式和公式）

The worksheet will be added once the user clicks the "OK" button and I'm using a template to add this worksheet (The template has lot of formatting and formulas in it)

让我们说文件大小在添加工作表后是10 MB如果工作簿被保存。然后我关闭Excel应用程序并重新打开并保存文件，然后文件大小减少到8 MB。

Lets say the file size is 10 MB after adding a worksheet if the workbook is saved. Then I close the Excel application and reopen it and save the file then the file size is getting reduced to 8 MB.

有谁能让我知道什么可能是相同？

Can anybody let me know what could be the reason for the same?

推荐答案

未使用的格式化是Excel中文件膨胀的最常见原因：最近，表格上的使用范围大于您的想法 - Excel维护每个单元格从A1到最低，最远的单元格，您编辑并且需要大量的记忆。

Unused formatting is the most common cause of 'file bloat' in Excel: a close second is that the 'used range' on a sheet is larger than you think - Excel maintains metadata about every cell on a sheet from A1 to the lowest, furthest cell you've ever edited and that takes a lot of memory.

但是在新的工作表中的used range被保存为单元格A1到具有数据的最后一个单元格。

But the 'used range' in a new worksheet is saved as cell A1 to the last cell with data in it.

提示：查看工作表中垂直和水平的滚动条中的滑块：他们看起来好像只能滚动五十行还是列吗？或者如果鼠标靠近他们，它们是几条滚动数百行的小灰色短划线？当滑块移动距离相等时，它是自己的长度，它在可用页面空间中完成一个向下翻页（或侧翻）空格或页面集（Excel中的或使用范围）越大，它们越小。

A hint: take a look at the sliders in the scroll bars for your worksheet, vertical and horizontal: are they chunky grey blocks that look as if they'll only scroll fifty rows or columns? Or are they little grey dashes that scroll hundreds of rows if the mouse goes near them? When a slider bar moves a distance equal it's own length, it completes one 'page down' (or page sideways) in the available page space; the larger the space or page set (or used range in Excel), the smaller they will be.

我建议去呕吐（必须是一个更好的词语，放气，取消，变形，）你的工作簿。以前有很多第三方工具，但Excel 2003以上版本有一个内置的工作簿重建工具：只需点击保存和另存为...一个网页。然后退出Excel，重新打开Excel，并使用打开打开html工作簿（尽管是一个HTML文件，它将具有一个Excel图标），并再次另存为...一个xls文件。再次关闭Excel，并查看文件大小。

I'd suggest de-bloating (There's got to be a better word! Deflating? Detumescing? Deforming?) your workbook. There used to be lots of third-party tools for this but Excel 2003 onwards has a built-in workbook rebuilder: just click 'Save' and 'Save As...' a web page. Then exit Excel, reopen Excel, and use 'Open' to open the html workbook (despite being an HTML file, it'll have an Excel icon), and 'Save As...' an xls file again. Close Excel again, and have a look at the file size.

这篇关于减少Excel的文件大小的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！