使用自动化导出到Excel时的列限制(312)? [英] Column limit (312) when exporting to Excel using automation?
问题描述
大家好。
我有一个非常简单的应用程序,可以向Excel导出一个数据表。我到目前为止从未意识到,但是当我尝试导出超过312列时,我收到以下错误消息:
I have a very simple application that exports to Excel a table of data. I had never realized up to now, but when I try to export more than 312 columns I get the following error message:
"无法导出到Microsoft.Office.Interop.Excel超过312列!"
"Cannot export to Microsoft.Office.Interop.Excel more than 312 columns!"
我在网上搜索并搜索过某人,解释这是否真的是一个限制(对于更改,错误信息非常明显: - /),或者如果我做错了什么......但是可以发现任何事情。
I have searched and searched in the web for somebody explaining if this is really a limitation (for a change, the error message is pretty obvious :-/), or if I am doing something wrong... but can´t find anything.
我真的很感激对此有所了解。我正在链接到Microsoft Excel 12.0对象库,但方式(Excel 2007)。
I would really appreciate some insight into this. I am linking to Microsoft Excel 12.0 Object Library, but the way (Excel 2007).
提前致谢。
推荐答案
你好,
您能提供有关错误情况的更多详细信息吗?
据我所知,Excel可以存储超过312列,在自动化过程中,您可以无限制地访问所有在资格中暴露的单元格。
As i know Excel can handel more then 312 columns, and in automation process you can access to all the cells exposed on the worsheets with no limitation.
您已经说过要连接到Excel 12 OL,您使用的是VSTO自动化 或通过托管/非托管的Atl / COM ?
You've said that you're linking to Excel 12 OL, are you using VSTO automation or Atl/COM via managed/unmanaged ?
这篇关于使用自动化导出到Excel时的列限制(312)?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!