Exporting to excel

[former_member437388]

Dears,

Please could you tell the solution or the verification of these situations ASAP:

1- what is the limit of excel worksheet to hold data and if exceed this number will create another worksheet.

2- I am exporting to excel data up to 50K via java application and using export function, but the downloaded excelsheet downloaded in more than one sheet and this is problem for the customer

3- The merged cells in the file, how can i remove as i make the alignments correctly but still there

Thanks in advance but i am in critical situation before moving to production :(.

[former_member226760 · Accepted solution]

Hi Alok,

What format of excel you are using right now?

If you have more data then to over come this situation I would suggest you to use below one:

IExportOptions opts = new ExportOptions();

opts.setExportFormatType(ReportExportFormat.recordToMSExcel2007);

For Excel row limit you can refer below link:

https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269...

-Kedar Kale

[former_member437388 · Accepted solution]

Hi Kedar,

Thanks for your reply

I am exactly using this logic

ExcelExportFormatOptions excelOption = new ExcelExportFormatOptions();

ExportOptions exportOptions = new ExportOptions();

exportOptions.setExportFormatType(ReportExportFormat.recordToMSExcel);

exportOptions.setFormatOptions(excelOption);

export(clientDoc, exportOptions, response, attachment, "application/vnd.ms-excel", "xls");

[former_member437388]

Hi Kedar

i dont find out this option although it should be there

and i am using com.crystaldecisions.sdk.occa.report.exportoptions.ReportExportFormat

what do u advise me ?

[former_member1267924]

I also faced the same exact issue. Is there any update from SAP?The run time libraries seem to be old and not rebuild with the class defined at https://help.sap.com/doc/javadocs_bip_40/4.0/en-US/ras/en/com/crystaldecisions/sdk/occa/report/expor.... The run time libraries need to be rebuilt with this class included.

[former_member226760]

Hi Alok,

I am able to find out for BO 4.0 RAS SDK. What BO version you are using?

Here is link for that class:

https://help.sap.com/doc/javadocs_bip_40/4.0/en-US/ras/en/com/crystaldecisions/sdk/occa/report/expor...

-Kedar

[former_member437388]

Could u please send me the lib including this option on talaat.mamdouh.fci@gmail.com

- but the question now what is the difference ?

is this option will let the data exported in only one sheet?

Thanks 🙂

[former_member226760]

Hi Alok,

I am able to see difference at below line:

exportOptions.setExportFormatType(ReportExportFormat.recordToMSExcel);

Instead of above line use below line and let me your observations:

exportOptions.setExportFormatType(ReportExportFormat.recordToMSExcel2007);

for more information please go through:

https://help.sap.com/doc/javadocs_bip_40/4.0/en-US/ras/en/com/crystaldecisions/sdk/occa/report/expor...

-Kedar

[former_member437388]

Hi Kedare,

i cant found this property you provided

is it related to particular version?

recordToMSExcel2007

I am using

import com.crystaldecisions.sdk.occa.report.exportoptions.ReportExportFormat;