Topic
  • 11 replies
  • Latest Post - ‏2015-06-25T08:03:08Z by JyotiYadav@24
SystemAdmin
SystemAdmin
7615 Posts

Pinned topic Export to Excel in 8.0.1

‏2012-12-04T00:55:14Z |
Hi. I am looking out for details on export to excel to be used in 8 / 8.0.1. Kindly help
Updated on 2013-02-16T16:05:12Z at 2013-02-16T16:05:12Z by kolban
  • kolban
    kolban
    3316 Posts

    Re: Export to Excel in 8.0.1

    ‏2012-12-04T03:13:36Z  
    Ive recently been thinking in this area myself. Can you elaborate on what content you would like to be in the Excel spreadsheet?

    Neil
  • SystemAdmin
    SystemAdmin
    7615 Posts

    Re: Export to Excel in 8.0.1

    ‏2012-12-04T07:04:16Z  
    • kolban
    • ‏2012-12-04T03:13:36Z
    Ive recently been thinking in this area myself. Can you elaborate on what content you would like to be in the Excel spreadsheet?

    Neil
    Same Problem As she Mentioned Above

    Hello,

    I have Implemented the similar method in 8.0.1 for exporting data to excel which i have implemented in 7.5 but its showing error.

    its taking null -table date

    I have followed WIKI Method of export to excel

    http://bpmwiki.blueworkslive.com/display/commwiki/Coach+Table+Excel+Export+Example

    var table;
    try {
    table = document.getElementById(tableId);
    var a = table.innerHTML;
    //replace existing commas with semi-colons.
    a = a.replace(/,/g, "");

    There the table data is getting NULL when i keep any alert(a);

    Please Help me out

    Thanks and Regards
  • SystemAdmin
    SystemAdmin
    7615 Posts

    Re: Export to Excel in 8.0.1

    ‏2012-12-06T12:16:29Z  
    • kolban
    • ‏2012-12-04T03:13:36Z
    Ive recently been thinking in this area myself. Can you elaborate on what content you would like to be in the Excel spreadsheet?

    Neil
    Hi,
    We have a search screen for application business data( varying from 10 - 15 fields).
    The search results need to be downloaded (selected or all)into an excel.
  • SystemAdmin
    SystemAdmin
    7615 Posts

    Re: Export to Excel in 8.0.1

    ‏2012-12-06T13:20:28Z  
    Hi,
    We have a search screen for application business data( varying from 10 - 15 fields).
    The search results need to be downloaded (selected or all)into an excel.
    Can we use Apache POI to export the data from Coaches etc and generate a excel file? Its a Java API that is generally used for this purpose.

    Ashish
  • kolban
    kolban
    3316 Posts

    Re: Export to Excel in 8.0.1

    ‏2013-01-25T04:29:29Z  
    Can we use Apache POI to export the data from Coaches etc and generate a excel file? Its a Java API that is generally used for this purpose.

    Ashish
    A new sample Integration Service has been produced which writes an Excel spreadsheet from a list of Business Objects. See:

    http://bpmwiki.blueworkslive.com/display/samples/Write+Excel

    Neil
  • SystemAdmin
    SystemAdmin
    7615 Posts

    Re: Export to Excel in 8.0.1

    ‏2013-01-25T05:28:36Z  
    • kolban
    • ‏2013-01-25T04:29:29Z
    A new sample Integration Service has been produced which writes an Excel spreadsheet from a list of Business Objects. See:

    http://bpmwiki.blueworkslive.com/display/samples/Write+Excel

    Neil
    Neil, I dont see the integration service with the wiki link.

    Ashish
  • kolban
    kolban
    3316 Posts

    Re: Export to Excel in 8.0.1

    ‏2013-01-25T16:01:47Z  
    Neil, I dont see the integration service with the wiki link.

    Ashish
    Hi Ashish,
    Sorry for the delay, the toolkit that contains the Integration Service is now available for download.

    Neil
  • SystemAdmin
    SystemAdmin
    7615 Posts

    Re: Export to Excel in 8.0.1

    ‏2013-01-25T16:13:26Z  
    • kolban
    • ‏2013-01-25T16:01:47Z
    Hi Ashish,
    Sorry for the delay, the toolkit that contains the Integration Service is now available for download.

    Neil
    Thanks Neil. Awesome!
  • FlournoyHenry
    FlournoyHenry
    96 Posts

    Re: Export to Excel in 8.0.1

    ‏2013-02-14T14:32:29Z  
    • kolban
    • ‏2013-01-25T04:29:29Z
    A new sample Integration Service has been produced which writes an Excel spreadsheet from a list of Business Objects. See:

    http://bpmwiki.blueworkslive.com/display/samples/Write+Excel

    Neil
    That link is not working for me????

    Flournoy Henry BP3 Global, Inc. www.bp-3.com
  • kolban
    kolban
    3316 Posts

    Re: Export to Excel in 8.0.1

    ‏2013-02-16T16:05:12Z  
    That link is not working for me????

    Flournoy Henry BP3 Global, Inc. www.bp-3.com
    Maybe there was an outage? I just tried it and it seems to work as of date/time of posting.

    Neil
  • JyotiYadav@24
    JyotiYadav@24
    5 Posts

    Re: Export to Excel in 8.0.1

    ‏2015-06-25T08:03:08Z  

    Hi Neil , 

    Neither of the links to download / Write excel are available.

    Can you please provide the link. I am stuck at download part due to unavailability of downloadHelper,war file.

     

    PFA for snapshot at my end. 

    Attachments