将XML导入Excel 2013 - 文件大小限制? [英] Import XML to Excel 2013 - file size limits?
问题描述
我尝试导入一个> 300MB的XML文件,它失败,只有几千行!
是否有最大的处理时间或文件大小?
10MB部分中相同类型的数据运行良好。访问在10MB部分上占用更长时间,并将其分割成不同的表格,因此,保持Excel(完全删除XML冗余的电子表格中的文本可能只有10%的大小)是完美的。 / p>
我当然可以设置任何(Linux)服务器解决方案,更好!只需编写一个XQuery脚本就会让我感到沮丧,因为它运行速度很慢,并不值得的工作只是做这个简单的转换,可以自动化。
来自: https://support.office.com/en-us/article/Excel-specifications-and-limits-ca36e2dc-1f09-4620-b726-67c00b05040f 适用于Excel 2016,Excel 2013。
功能最大限制
工作表和工作簿规范限制
打开工作簿受可用内存和系统资源限制
工作单大小1,048,576行16,384列
列宽255个字符
行高409点
页面中断1,026水平和垂直
单元格可以包含32,767个字符的
总数
页眉或页脚中的字符255
工作簿中的表格受可用内存限制(默认为1张)
工作簿中的颜色1600万色(32位,完全访问
至24位色谱)
工作簿中的命名视图受可用内存限制
唯一的单元格格式/单元格样式64,000
填充样式256
线条重量和样式256
唯一字体类型1,024全球字体可供使用;
512每个工作簿
工作簿中的数字格式200到250之间,取决于您已安装的
版本的
工作簿中的名称受可用内存限制
工作簿中的Windows受可用内存限制
工作表中的超链接66,530超链接
窗口中的窗格4
链接页面受可用内存限制
方案受可用内存限制;摘要报告
仅显示前251个场景
更改场景中的单元格32
Solver 200中的可调整单元格
自定义函数受可用内存限制
缩放范围10%到400%
报告受可用内存限制
以一种排序对引用64进行排序;无限制使用
顺序排序
撤销级别100
数据表单中的字段32
工作簿参数每个工作簿的255个参数
过滤器中显示的项目
drop-下拉列表10,000
可以选择的不连续单元格
2,147,483,648个单元格
最大内存存储空间
和数据模型的文件大小
工作簿32位环境受2 GB的虚拟地址空间
,由Excel共享,
工作簿和在同一进程中运行的加载项。
数据模型的地址空间份额可能会运行
达500 - 700兆字节(MB),但如果加载其他数据模型和加载项,则可能会更少
。
64位环境对文件
大小没有强制限制。工作簿大小仅受可用的
内存和系统资源的限制。
计算规格和限制
数字精度15位数
最小允许负数-2.2251E-308
最小允许正数2.2251E-308
最大允许正数数字9.99999999999999E + 307
最大允许负数-9.99999999999999E + 307
最大允许正数
通过公式1.7976931348623158e + 308
最大允许负数
通过公式-1.7976931348623158e + 308
公式内容长度8,192个字符
公式的内部长度16,384字节
迭代32,767
工作表数组受可用内存限制
所选范围2,048
函数中的参数255
嵌套级别的函数64
用户定义的函数类别255
数量可用的工作表
功能341
操作数堆栈的大小1,024
跨工作表依赖64,000工作表可以参考其他工作表
跨工作表数组公式
依赖受限于可用内存
区域依赖关系受可用内存限制
每个工作表的区域依赖性受可用内存限制
依赖于单个单元40个可以依赖于单个单元格的公式
链接单元格内容长度
从封闭的工作簿32,767
最早允许的
计算日期1900年1月1日(1904年1月1日,如果1904日期使用
系统)
最新允许的日期
计算9999年12月31日
可以输入
的最大金额9999:59:59
Ch
链接到工作表的图表受可用内存限制
工作表由图表255
一个图表中的数据系列255
数据系列中的数据点
用于2-D图表受可用内存限制
数据系列中的数据点
3-D图表受可用内存限制
所有数据系列的数据点
在一个图表中受可用内存限制
数据透视表和数据透视图报告规范和限制
数据透视表报告表受限于可用内存
每个字段的唯一项目1,048,576
中的行或列字段数据透视表报告受可用内存限制
数据透视表中的报表过滤器
报表256(可能受到备忘录的限制ry)
数据透视表
报表中的值字段256
中计算的项目公式数据透视表报表受可用内存限制
数据透视图
报表中的报表过滤器256(可能受可用内存限制)
PivotChart中的值字段
报告256
中的计算公式PivotChart报告受可用内存限制
的数据透视表数据透视表项目32,767
关系的长度
数据透视表字符串32,767
过滤器
中显示的项目下拉列表10,000
$共享的工作簿规范和限制 可以同时打开和共享
共享工作簿的用户256
共享工作簿中的个人视图受限于我mory
更改历史记录的日期为
维护32,767(默认为30天)
可以合并的工作簿
一次限制可用内存
可以是在共享工作簿中突出显示
32,767
用于识别更改时由不同用户更改
的颜色
突出显示打开32(每个用户由单独的颜色标识;
当前用户所做的更改突出显示为
,带有海军蓝色)
共享工作簿中的Excel表0(零)
I tried to import a >300MB XML file and it fails though just a few thousand rows!
Is there a maximum processing time or file size?
The same kind of data in 10MB portion works well. Access takes even longer on a 10MB portion and splits it in different tables that don't make sense, so it would be perfect to stay with Excel (with XML redundancy removed the text in the spreadsheet may only be 10% the size).
I am able to set up any (Linux) server solution too of course, even better! Just writing a XQuery script frustrated me since it runs slow and wasn't worth the work just to do this simple conversion that could be automated.
解决方案 From: https://support.office.com/en-us/article/Excel-specifications-and-limits-ca36e2dc-1f09-4620-b726-67c00b05040f Applies to Excel 2016, Excel 2013.
Feature Maximum limit
Worksheet and workbook specifications and limits
Open workbooks Limited by available memory and system resources
Worksheet size 1,048,576 rows by 16,384 columns
Column width 255 characters
Row height 409 points
Page breaks 1,026 horizontal and vertical
Total number of characters
that a cell can contain 32,767 characters
Characters in a header or footer 255
Sheets in a workbook Limited by available memory (default is 1 sheet)
Colors in a workbook 16 million colors (32 bit with full access
to 24 bit color spectrum)
Named views in a workbook Limited by available memory
Unique cell formats/cell styles 64,000
Fill styles 256
Line weight and styles 256
Unique font types 1,024 global fonts available for use;
512 per workbook
Number formats in a workbook Between 200 and 250, depending on the language
version of Excel that you have installed
Names in a workbook Limited by available memory
Windows in a workbook Limited by available memory
Hyperlinks in a worksheet 66,530 hyperlinks
Panes in a window 4
Linked sheets Limited by available memory
Scenarios Limited by available memory; a summary report
shows only the first 251 scenarios
Changing cells in a scenario 32
Adjustable cells in Solver 200
Custom functions Limited by available memory
Zoom range 10 percent to 400 percent
Reports Limited by available memory
Sort references 64 in a single sort; unlimited when using
sequential sorts
Undo levels 100
Fields in a data form 32
Workbook parameters 255 parameters per workbook
Items displayed in filter
drop-down lists 10,000
Noncontiguous cells
that can be selected 2,147,483,648 cells
Maximum limits of memory storage
and file size for Data Model
workbooks 32-bit environment is subject to 2 gigabytes (GB)
of virtual address space, shared by Excel, the
workbook, and add-ins that run in the same process.
A data model’s share of the address space might run
up to 500 – 700 megabytes (MB), but could be less
if other data models and add-ins are loaded.
64-bit environment imposes no hard limits on file
size. Workbook size is limited only by available
memory and system resources.
Calculation specifications and limits
Number precision 15 digits
Smallest allowed negative number -2.2251E-308
Smallest allowed positive number 2.2251E-308
Largest allowed positive number 9.99999999999999E+307
Largest allowed negative number -9.99999999999999E+307
Largest allowed positive number
via formula 1.7976931348623158e+308
Largest allowed negative number
via formula -1.7976931348623158e+308
Length of formula contents 8,192 characters
Internal length of formula 16,384 bytes
Iterations 32,767
Worksheet arrays Limited by available memory
Selected ranges 2,048
Arguments in a function 255
Nested levels of functions 64
User defined function categories 255
Number of available worksheet
functions 341
Size of the operand stack 1,024
Cross-worksheet dependency 64,000 worksheets that can refer to other sheets
Cross-worksheet array formula
dependency Limited by available memory
Area dependency Limited by available memory
Area dependency per worksheet Limited by available memory
Dependency on a single cell 4 billion formulas that can depend on a single cell
Linked cell content length
from closed workbooks 32,767
Earliest date allowed for
calculation January 1, 1900 (January 1, 1904, if 1904 date
system is used)
Latest date allowed for
calculation December 31, 9999
Largest amount of time that
can be entered 9999:59:59
Charting specifications and limits
Charts linked to a worksheet Limited by available memory
Worksheets referred to by a chart 255
Data series in one chart 255
Data points in a data series
for 2-D charts Limited by available memory
Data points in a data series
for 3-D charts Limited by available memory
Data points for all data series
in one chart Limited by available memory
PivotTable and PivotChart report specifications and limits
PivotTable reports on a sheet Limited by available memory
Unique items per field 1,048,576
Row or column fields in a
PivotTable report Limited by available memory
Report filters in a PivotTable
report 256 (may be limited by available memory)
Value fields in a PivotTable
report 256
Calculated item formulas in a
PivotTable report Limited by available memory
Report filters in a PivotChart
report 256 (may be limited by available memory)
Value fields in a PivotChart
report 256
Calculated item formulas in a
PivotChart report Limited by available memory
Length of the MDX name for a
PivotTable item 32,767
Length for a relational
PivotTable string 32,767
Items displayed in filter
drop-down lists 10,000
Shared workbook specifications and limits
Users who can open and share a
shared workbook at the same time 256
Personal views in a shared workbook Limited by available memory
Days that change history is
maintained 32,767 (default is 30 days)
Workbooks that can be merged
at one time Limited by available memory
Cells that can be highlighted
in a shared workbook 32,767
Colors used to identify changes
made by different users when change
highlighting is turned on 32 (each user is identified by a separate color;
changes made by the current user are highlighted
with navy blue)
Excel tables in a shared workbook 0 (zero)
这篇关于将XML导入Excel 2013 - 文件大小限制?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!