Performance Issue with OPENXML SDK to read & write--Need Urgent Help!!! RRS feed

  • Question

  • Hi All,

    Acording to my client requirement,we are replacing ASPOSE  technology by OPENXML SDK to read and write Excel 2007 (.xlsm macro-enabled file),and in fact we are able to accomplish the job using openxml sdk.

    However the problem starts when we compare the execution time,if the data is too large(reprting data for eg 18k) to be read or written,ASPOSE is too fast in compariosn to OPEN XML SDK.

    We take the following approach given in the below link and it works perfectly but the real issue is excution time it takes is too much,during wich we loose the trasaction time out.

    If OPENXML SDK enables us to deliver result in lesser time than ASPOSE,only then the OPENXML SDK is accepted ;otherwise ,our effort  given for finding and writing open xml sdk code is in vain.

    Basically we have are taking entire huge data in dataset and write using any of the above technology.

    Any help to improve permance in terms coding will be highly appreacited.

    Need urgent Help!!!!

    Monday, November 5, 2012 6:25 AM


All replies