Last post Sep 16, 2015 11:23 PM by Weibo Zhang
Sep 16, 2015 12:59 PM|sreekanth.jonna|LINK
i want to find the last row in a uploaded excel without using the Interop. Excel reference..by using Interop reference it is easy but i want to know if there is anyway to find without using interop.excel reference.
Thanks in Advance
Sep 16, 2015 05:56 PM|BillKrat|LINK
You can do it with Microsoft OpenXml SDK 2.5 ->
Sep 16, 2015 11:23 PM|Weibo Zhang|LINK
You could first save the uploaded excel to a temp path and then read the excel file last row with the OLEDB or OpenXml to achieve it. For more things, please take a look at the following links.
If you want to read the uploaded excel file without saving to disk, you could refer to the following article.
I hope it’s useful to you.