Get datasheet row/column count and other datasheet informations

S

sanjay_sharma77

Hi,

I have a PPT/pptx file with chart embedded in some slides. I want to access
the chart value (Datasheet).
I have 2 queries.
1) I want to know the range of the datasheet for the particular chart in a
datasheet. For example If I have a data spanned accross the cell G12, I
should know that there are 7 columns and 12 rows in a datasheet.

2) Some of the rows or columns in the ppt graph datasheet are disabled. I
want to know which rows and which columns are disabled.

Are there any specific methods where in can get these informations?

I'm working on Visual Basic 2005.

Thanks,
 

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

Top