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:22:30
 
 
To
07/12/2002 17:17:43
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00730656
Message ID:
00730659
Views:
8
David,
Yes, a short code example will help me greatly.
I'm really short of time now, it will great if you can spare me digging on the object model of Excel.

TIA

>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?
Maria E. Zambrano
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform