How to upload a excel sheet and to read its data row by row in asp.net?

For read Excel: NPOI excelpackage Save file upload Uploading Files Using the File Field Control Uploading Files in ASP. NET 2.0 FileUpload. SaveAs Method.

Although it's probably not the answer you're looking for, I found the following component very easy to work with on a recent project when recently asked to do a fairly complex excel import. aspose.com/categories/.net-components/as... It allows some really neat functionality such as named ranges, lookups etc in both import and export mode. It could be worth looking into if you want an out of the box solution to do the heavy lifting for you.

On the flip side of the same project I was asked to replicate this functionality with an access import/export and ended up writing some functions using the ADOX libraries, these can be used with excel in a similar way, so if you're after something similar it would be worth looking into this. support.microsoft.com/kb/303814 In a nutshell, both of these methods allow you to end up with a sensible C# object, such as a datatable, which you can then use to fiddling about with the data as you please.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions