Discussion:
Export Viso Shapes to Excel
(too old to reply)
GregCrossan
2010-02-07 03:11:01 UTC
Permalink
I have a Visio 2007 drawing that I am trying to export to excel. I have 3
custom masters, i have created with custom shape data. For some reason 2 of
the shape types export fine, but one does not even show up in the list
ofcells/ fields to export.

please help.
AlEdlund
2010-02-07 04:52:56 UTC
Permalink
I'd check the name of the shape to make sure it doesn't start with an
underscore.
al
Post by GregCrossan
I have a Visio 2007 drawing that I am trying to export to excel. I have 3
custom masters, i have created with custom shape data. For some reason 2 of
the shape types export fine, but one does not even show up in the list
ofcells/ fields to export.
please help.
GregCrossan
2010-02-08 04:55:01 UTC
Permalink
Yep checked no _ names
Post by AlEdlund
I'd check the name of the shape to make sure it doesn't start with an
underscore.
al
Post by GregCrossan
I have a Visio 2007 drawing that I am trying to export to excel. I have 3
custom masters, i have created with custom shape data. For some reason 2 of
the shape types export fine, but one does not even show up in the list
ofcells/ fields to export.
please help.
AlEdlund
2010-02-08 12:34:14 UTC
Permalink
what is the name of the cell that isn't recognized?
Post by GregCrossan
Yep checked no _ names
Post by AlEdlund
I'd check the name of the shape to make sure it doesn't start with an
underscore.
al
Post by GregCrossan
I have a Visio 2007 drawing that I am trying to export to excel. I
have
3
custom masters, i have created with custom shape data. For some
reason 2
of
the shape types export fine, but one does not even show up in the list
ofcells/ fields to export.
please help.
GregCrossan
2010-02-08 17:22:01 UTC
Permalink
I have about 40 - 50 objects. 1/2 the otehr 1/2 on another, (and 2 minor
objects based on another master) (o know less than 1/2 for at least one)
based on one master, and within each master there are about 10 pieces of
shape data. one of the larger masters, not of ojects /shape data cells are
showing up on the export. I had this all working at one point. As far as i
can recall the only thing that has changes is that I entered data for every
shape.

Other things to know about this drawing.
1) there are 5 tabs, the data spreads accross all tabs (the ones that work
are spread accross as well)
2) I have a custom Shape Graphic that does some minor calculations on the
shape data and displays it in a call-out. The same calculations / call-outs
are in all 3 masters.

I can send you the vsd if that helps, but I do not want it posted to the
community.
Post by AlEdlund
what is the name of the cell that isn't recognized?
Post by GregCrossan
Yep checked no _ names
Post by AlEdlund
I'd check the name of the shape to make sure it doesn't start with an
underscore.
al
Post by GregCrossan
I have a Visio 2007 drawing that I am trying to export to excel. I
have
3
custom masters, i have created with custom shape data. For some
reason 2
of
the shape types export fine, but one does not even show up in the list
ofcells/ fields to export.
please help.
AlEdlund
2010-02-08 19:05:19 UTC
Permalink
you can find
edlund60014
over on the yahoo site
al
Post by GregCrossan
I have about 40 - 50 objects. 1/2 the otehr 1/2 on another, (and 2 minor
objects based on another master) (o know less than 1/2 for at least one)
based on one master, and within each master there are about 10 pieces of
shape data. one of the larger masters, not of ojects /shape data cells are
showing up on the export. I had this all working at one point. As far as i
can recall the only thing that has changes is that I entered data for every
shape.
Other things to know about this drawing.
1) there are 5 tabs, the data spreads accross all tabs (the ones that work
are spread accross as well)
2) I have a custom Shape Graphic that does some minor calculations on the
shape data and displays it in a call-out. The same calculations / call-outs
are in all 3 masters.
I can send you the vsd if that helps, but I do not want it posted to the
community.
Post by AlEdlund
what is the name of the cell that isn't recognized?
Post by GregCrossan
Yep checked no _ names
Post by AlEdlund
I'd check the name of the shape to make sure it doesn't start with an
underscore.
al
Post by GregCrossan
I have a Visio 2007 drawing that I am trying to export to excel. I
have
3
custom masters, i have created with custom shape data. For some
reason 2
of
the shape types export fine, but one does not even show up in the list
ofcells/ fields to export.
please help.
AlEdlund
2010-02-08 20:34:25 UTC
Permalink
Handled off-line
al
Post by AlEdlund
you can find
edlund60014
over on the yahoo site
al
Post by GregCrossan
I have about 40 - 50 objects. 1/2 the otehr 1/2 on another, (and 2 minor
objects based on another master) (o know less than 1/2 for at least one)
based on one master, and within each master there are about 10 pieces of
shape data. one of the larger masters, not of ojects /shape data cells are
showing up on the export. I had this all working at one point. As far as i
can recall the only thing that has changes is that I entered data for every
shape.
Other things to know about this drawing.
1) there are 5 tabs, the data spreads accross all tabs (the ones that work
are spread accross as well)
2) I have a custom Shape Graphic that does some minor calculations on the
shape data and displays it in a call-out. The same calculations / call-outs
are in all 3 masters.
I can send you the vsd if that helps, but I do not want it posted to the
community.
Post by AlEdlund
what is the name of the cell that isn't recognized?
Post by GregCrossan
Yep checked no _ names
Post by AlEdlund
I'd check the name of the shape to make sure it doesn't start with an
underscore.
al
Post by GregCrossan
I have a Visio 2007 drawing that I am trying to export to excel.
I
have
3
custom masters, i have created with custom shape data. For some
reason 2
of
the shape types export fine, but one does not even show up in the list
ofcells/ fields to export.
please help.
Loading...