cancel
Showing results for 
Search instead for 
Did you mean: 

Design Studio - Export to Excel function is not working properly.

0 Kudos

1017213.pngHi All,

I have an design studio application and using the script APPLICATION.export(ExportType.EXCEL_xlsx,CROSSTAB); to export it to excel. It is throwing a very strange error.

Does anyone know how to fix this error?

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hello all,

it has been solved by moving some scripts in the application which created this error. Seems like Design Studio can't handle any other functions while exporting.

Thank you anyway for your help.

Best Regards,

Peter Kepes

Answers (4)

Answers (4)

howsy
Explorer
0 Kudos

Dear Peter,

The good new is: Your coding is correct, the bad: this error is not easy to find out.

I know it sounds a little silly, but have you tried to "reset" the Datasource? So that it is back to its initial state? I was facing a lot of issues regarding blody datasources (the view is stored, even if the query itself may be changed in the meantime, so you can have a Keyfigure, which was removed recently, then you get such type of errors).

Another test you could do (for further investigation): Create a new Application, just with that datasource and that single command. Does that problem still occur?

Have you checked your query (source) within RSRT in the Backend?

Regards,
Chris

0 Kudos

Sometimes the error shows like this also:l-38fftmp.png

BR

Peter

0 Kudos

Hello Tammy,

Design Studio 1.6 SP06 Patch 02 is in use and actually I checked the SAP Note which says that it is related to:

"MissingResource for class com.sap.ip.bi.export.office.impl.excel2007.MsExcel2007Converter, key: MsExcel2007Converter_0001, locale: en"

But I haven't seen that error anywhere only just this error I shared.

Best Regards,

Peter

TammyPowlas
Active Contributor
0 Kudos

Hello Peter - there are 38 SAP Notes related to Export to Excel

That said this is the most recent note: https://launchpad.support.sap.com/#/notes/2533282 - please see if it applies; if it does not please share version/SP of Design Studio that you are using