Click here to Skip to main content
15,887,596 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,
i have been trying to write the data in to excel using the openXML and i am getting the row to write data in to it by using:

Dim lobjRefRow As Row = mobjActiveSheetData.Elements(Of Row).Where(Function(r) r.RowIndex.Value = puintRowIndex).FirstOrDefault()


this particular code is taking 7.5 minutes for writing 500 objects.Can i write it better because i observed the same code taking 4 minutes in another machine and all the prerequisites were same and infrastructure was same.How can i improve this piece of cdoe better? please suggest

What I have tried:

haven't tried anything as i am not getting any solution
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900