AXForum  
Вернуться   AXForum > Microsoft Dynamics AX > DAX Blogs
All
Забыли пароль?
Зарегистрироваться Правила Справка Пользователи Сообщения за день Поиск Все разделы прочитаны

 
 
Опции темы Поиск в этой теме Опции просмотра
Старый 23.11.2015, 13:11   #1  
Blog bot is offline
Blog bot
Участник
 
25,459 / 846 (79) +++++++
Регистрация: 28.10.2006
emeadaxsupport: Limitations of the Export to Excel functionality in AX 2012
Источник: http://blogs.msdn.com/b/axsupport/ar...n-ax-2012.aspx
==============

Exporting data to Excel files is a very useful feature in AX 2012. It allows an easy way to export data from list pages into XLSX files.

When using this feature, some limitations need to be considered, as detailed below.

1. Excel has stricter limitations than data in a database, as mentioned in the following article: https://support.office.com/en-us/art...6-67C00B05040F
Two hard limits are particularly relevant for AX, the maximum number of rows, 1,048,576, and the maximum number of columns, 16,384.
List pages exceeding these limitations will not be exported to XLSX.

2. In addition to the limitations of the output file format, AX 2012 is also bounded by the memory available to the AX Client process, AX32.exe, which is between 2GB and 4GB depending on the operating system.
The current implementation of AX 2012 requires all data to be cached in memory before the export in order to enable some business scenarios such as Remote Desktop connections.

The consequence of this implementation is that the maximum amount of data that can be exported to XLSX depends on the number of columns, the size of the values in each cell and the number of rows. Because of that variability we have never issued any guidance on the maximum number of rows supported.

To conclude, although the XLSX file format supports up to 1,048,576 rows, AX 2012 might only be able to export a smaller number depending on the actual contents.

In order to overcome this limitation, custom solutions based on the OpenXML SDK can be developed to write table data without caching it in memory. More information about the OpenXML SDK is available here: https://msdn.microsoft.com/en-us/lib.../bb448854.aspx




Источник: http://blogs.msdn.com/b/axsupport/ar...n-ax-2012.aspx
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
 

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
emeadaxsupport: Country specific update to support SEPA export formats for remittance journal in Promissory Notes and Bill of Exchange in Microsoft Dynamics AX 2012 R2 is available Blog bot DAX Blogs 0 04.02.2014 22:11
axsa: Microsoft Dynamics AX 2012 Data Import/Export Framework standalone version for AX 2012 R2 without installing full CU7 Blog bot DAX Blogs 0 04.12.2013 04:13
emeadaxsupport: AX for Retail 2012 R2: Run-down on Log Files Blog bot DAX Blogs 0 21.06.2013 08:11
emeadaxsupport: Final Microsoft Dynamics AX 2012 R2 Content Available! Blog bot DAX Blogs 0 04.12.2012 06:12
Опции темы Поиск в этой теме
Поиск в этой теме:

Расширенный поиск
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.
Быстрый переход

Рейтинг@Mail.ru
Часовой пояс GMT +3, время: 10:33.
Powered by vBulletin® v3.8.5. Перевод: zCarot
Контактная информация, Реклама.