MicroSoft Ace Oledb Excel行计数C# [英] MicroSoft Ace Oledb Excel Row Count C#

问题描述

如何在使用dataapadter填充数据表之前获取excel工作表中的总行数我需要此来进行验证，基于此，我必须调用存储的过程并进行其他操作...

还有如何检查是否上传了一个空的excel工作表.....(在有标题字段(单行)和没有标题字段(根本没有行)的情况下)

感谢任何建议..

How to Get Total number of rows in excel sheet prior to Filling Datatable with dataapadter I need this for validation purpose, based on this I have to call stored porcedure and do other stuff...

Also how to check If an Empty excel sheet is uploaded.....(In both Cases With Header Fields(Single Row) and without Header Fields(No row at all.))

Any suggestion is appreciated..

推荐答案

从以下链接中查找两个查询的请求线索:
http://social.msdn.microsoft.com /Forums/zh-CN/vsto/thread/8e253c1b-2549-4bef-87bd-5940b02b8c36/ [ http://stackoverflow.com/questions/1715926/c-使用Excel软件包获取行数列 [ http://stackoverflow. com/questions/4356204/how-to-count-the-total-number-of-row-in-oledbconnection-in-c-net [ ^ ]
http://stackoverflow. com/questions/4356204/how-to-count-the-total-number-of-row-in-oledbconnection-in-c-net [ ^ ]
http://www.developerfusion.com/thread /45374/count-total-number-of-rows-of-data-in-excel/ [ http://social.msdn.microsoft.com/Forums/uk/innovateonoffice/thread/a4089c54-299c-486c-9e6e-70b36e59b9b5 [ http://csharpdotnetfreak.blogspot.com/2011/12/upload-and-read-excel-file-in-aspnet.html [

Freind for both of your query plead find resolution from following links:
http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/8e253c1b-2549-4bef-87bd-5940b02b8c36/[^]
http://stackoverflow.com/questions/1715926/c-getting-the-number-of-rows-columns-with-excelpackage[^]
http://stackoverflow.com/questions/4356204/how-to-count-the-total-number-of-row-in-oledbconnection-in-c-net[^]
http://stackoverflow.com/questions/4356204/how-to-count-the-total-number-of-row-in-oledbconnection-in-c-net[^]
http://www.developerfusion.com/thread/45374/count-total-number-of-rows-of-data-in-excel/[^]
http://social.msdn.microsoft.com/Forums/uk/innovateonoffice/thread/a4089c54-299c-486c-9e6e-70b36e59b9b5[^]
http://csharpdotnetfreak.blogspot.com/2011/12/upload-and-read-excel-file-in-aspnet.html[^]

Thanks,
Ambesha

这篇关于MicroSoft Ace Oledb Excel行计数C#的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！