如何在Excel中达到64k行限制 [英] How to get around 64k row limit in Excel

问题描述

我想允许用户在一个表上进行操作，该表可能有多达40万行，每行约200个字符，最大数据量为80MB.

I want to allow the user to operate on a table that might have as many as 400,000 rows, each of ~200 characters for a max total of 80MB of data.

首先，我正在考虑为用户提供一个.csv文件，以某种方式粘贴到电子表格中.

As a first approximation, I'm thinking to give the user a .csv file somehow to paste into a spreadsheet.

首先，尝试这种方法甚至具有实际意义吗? (例如，电子表格功能(仅一个功能)是否可以在合理的时间内(例如10秒)完成对所有这些行的操作?)

First of all, does it even make practical sense to try such a thing? (For example, could a spreadsheet function -- just one function -- operating on all those rows complete in a reasonable time, like 10 seconds?)

如果是这样，并且考虑到MS Excel似乎施加了64K行限制，那么在该巨型表上赋予用户电子表格功能的技术可能是什么?

If so, and given that MS Excel seems to impose a 64K row limit, what might be some of the techniques to give the user spreadsheet functionality on that giant table?

推荐答案

Excel 2003具有该限制. Excel 2010允许超过一百万行.

Excel 2003 has that limit. Excel 2010 allows more than a million rows.

确实，在处理大量数据(例如数据库)时使用更健壮的方法更有意义.

Really, it makes more sense to use something more robust when dealing with that much data, like a database.

这篇关于如何在Excel中达到64k行限制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！