https://community.sap.com/t5/application-development-and-automation-discussions/sap-bds-excel-performance-issue/m-p/622835#M25995 <P>Hello Experts,</P> <P></P> <P>I have implemented a program which generates complex excel with around 190 Columns and over 2500 Rows. I have used same concepts implemented in the <A href="https://github.com/jenizar/SAP_ECC_BDS_FORM_MS_EXCEL">SAP_ECC_BDS_FORM_MS_EXCEL</A>. However, data is written into the excel sheet line by line and this is taking very long time to complete. Is there any way that I can improve the performance?</P> <P>Also, this locks out all the Excel Workbooks that are open from editing. Until the program execution is complete, I will not be able to work on other Excel Workbooks.</P> <P>Please let me know how I can overcome these issues.</P> <P></P> <P>Thanks in advance for your support!</P> <P>Regards,<BR />Kiran Kerudi</P> Mon, 02 Apr 2018 05:49:18 GMT kirankerudi 2018-04-02T05:49:18Z https://community.sap.com/t5/application-development-and-automation-discussions/sap-bds-excel-performance-issue/m-p/622835#M25995 <P>Hello Experts,</P> <P></P> <P>I have implemented a program which generates complex excel with around 190 Columns and over 2500 Rows. I have used same concepts implemented in the <A href="https://github.com/jenizar/SAP_ECC_BDS_FORM_MS_EXCEL">SAP_ECC_BDS_FORM_MS_EXCEL</A>. However, data is written into the excel sheet line by line and this is taking very long time to complete. Is there any way that I can improve the performance?</P> <P>Also, this locks out all the Excel Workbooks that are open from editing. Until the program execution is complete, I will not be able to work on other Excel Workbooks.</P> <P>Please let me know how I can overcome these issues.</P> <P></P> <P>Thanks in advance for your support!</P> <P>Regards,<BR />Kiran Kerudi</P> Mon, 02 Apr 2018 05:49:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sap-bds-excel-performance-issue/m-p/622835#M25995 kirankerudi 2018-04-02T05:49:18Z