Last post Jun 27, 2014 01:54 AM by Ashim Chatterjee
Jun 26, 2014 06:01 AM|shilpa.gururao|LINK
In the system Excel file would be store. Through C#, I have to read it and render as XML. This xls/xlsx files will have huge data associated with it.
Reading cell by cell would affect the scalability and also performance. So please guide me to an optimaised approach.
Jun 26, 2014 10:08 PM|Kevin Shen - MSFT|LINK
I don't think it is a good way to read excel data one by one.
And ,I suggest that you can try to use some open source third party library.
You can use Epplus,you can refer to the link below:
Also ,you can try to use Excel Reader,please refer to the link below:
This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore,
Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you
completely understand the risk before retrieving any software from the Internet.
Jun 27, 2014 01:41 AM|shilpa.gururao|LINK
Thanks Kevin Shen. I agree with your statement
"I don't think it is a good way to read excel data one by one.".
How about OLEDB for using data reading? kindly share me your knowledge about OLEDB provider both pros and cons.
Jun 27, 2014 01:54 AM|Ashim Chatterjee|LINK
How about OLEDB for using data reading?
Not a good idea dear.Oledb datareader provides a way of reading a forward-only stream of data rows from a data source.This will effect the performance according to your scenario.Best option will be to use a third party library as already
suggested.But if you still insists to work on OLEDB , see below link as a reference: