如何检查excel文件长度 [英] how to check the excel file length

问题描述

我正在尝试将数据从excel导入到sql，并且如果excel文件中没有数据(即，如果excel工作表为空)，则应显示为所选文件中没有可用数据"当我单击上传按钮时.谁能帮助我找到导入Excel之前的Excel长度.在此先谢谢您.

I''m trying to import the datas from excel to sql and if the datas are not available in excel file (ie) if the excel sheet is empty, it should display as "No datas are available in the selected file" when i click the upload button. Can anyone help me to find the length of the excel before it gets imported to sql. Thanks in advance.

推荐答案

使用任何一种对您方便的技术.
http://social.msdn.microsoft.com /Forums/zh-CN/vsto/thread/8e253c1b-2549-4bef-87bd-5940b02b8c36/ [ http://social.msdn.microsoft.com/论坛/pl-PL/adodotnetdataset/thread/cbbb2f39-a168-4666-b4a7-8055e2730acf [

Use whichever technic is convenient to you.
http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/8e253c1b-2549-4bef-87bd-5940b02b8c36/[^]
http://social.msdn.microsoft.com/Forums/pl-PL/adodotnetdataset/thread/cbbb2f39-a168-4666-b4a7-8055e2730acf[^]

尝试以下操作:

http://www.dotnetcurry.com/ShowArticle.aspx?ID=138 [ ^ ]

希望对您有所帮助:)

Try this:

http://www.dotnetcurry.com/ShowArticle.aspx?ID=138[^]

hope it helps :)

尝试
http://aspdotnetmatters.blogspot.com/2010/12/reading-excel- file-in-aspnet.html [ ^ ]

Try
http://aspdotnetmatters.blogspot.com/2010/12/reading-excel-file-in-aspnet.html[^]

这篇关于如何检查excel文件长度的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！