Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to know an Excel spreadsheet is empty
Message
From
07/12/2002 17:17:43
 
 
To
07/12/2002 17:04:30
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00730656
Message ID:
00730658
Views:
8
You can check the .UsedRange.Address property of the sheet object. It will return $A$1 on an empty sheet or you can check cell by cell. Let me know if you need actual coding. I'm sure this is one of a dozen different methods. This one of the reasons I love UT, you get lots of responses with many different methods (hopefully at least one is new to "you").


>I'm working in an import wizard for one of our tables.
>
>I need to know if an Excel spreadsheet is empty, "empty" is simply defined for this work as the file having empty the first row of the first sheet.
>
>How can I programatically check it?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform