1. Skip to Menu
  2. Skip to Content
  3. Skip to Footer>

Expert Sessions!

BEx- Export to Excel – Results in xls file with huge size (i.e. 50 MB)

Tuesday, 31 July 2012 13:56

Written by Prakash Palani

Print E-mail

Reason : First of all, “Export to Excel” will not create xls file, rather it will create an XML file in the background (though the download file will be with .xls extension). As you may be aware, XML is a markup language, hence each cell in such type of files is defined by a character set called TAG. This basically contains the format of each cell (i.e. font, size, color etc.,), hence resulting in large number of characters / cell. That is the reason when you download the query result using “Export to Excel”, it results in xls file with huge file size.

Workaround / Solution: According to SAP (OSS Note : 1178857), “Export To Excel” function is not designed for the export of mass data and should not be used for this. BW provides other options for this, such as the open hub, workbooks (using pre-calculation server), BO WebI, etc.,

{fcomment} {flike}
Share
BEx- Export to Excel – Results in xls file with huge size (i.e. 50 MB)