[COM Newbie] How to find out the # of cells and rows in an excel sheet

P

Peder Ydalus

Having a reference to an excel workbook and worksheet, how can I get the
width and height of the area with data without iterating through 65536
rows * 256 columns (which would take a small eternity)?

Does the excel COM interface return any such contants or variables?

- Peder -
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top