Skip to Content

Exporting to excel

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 :(.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    Dec 10, 2018 at 07:18 AM

    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-269d656771c3#ID0EBABAAA=Newer_versions

    -Kedar Kale
    Add comment
    10|10000 characters needed characters exceeded

    • 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");

  • Dec 10, 2018 at 08:12 AM

    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/exportoptions/ReportExportFormat.html

    -Kedar

    Add comment
    10|10000 characters needed characters exceeded

    • 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;

  • Dec 10, 2018 at 09:31 AM

    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/exportoptions/ReportExportFormat.html

    -Kedar

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 10, 2018 at 11:08 AM

    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 ?


    cr.jpg (23.0 kB)
    Add comment
    10|10000 characters needed characters exceeded