Visible Part of the embedded excel in the visio :-

%3CLINGO-SUB%20id%3D%22lingo-sub-1270901%22%20slang%3D%22en-US%22%3EVisible%20Part%20of%20the%20embedded%20excel%20in%20the%20visio%20%3A-%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1270901%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Team%2C%3CBR%20%2F%3EManually%20we%20tried%20the%20following%20steps%3A%3CBR%20%2F%3E1.We%20try%20to%20embed%20an%20excel%20in%20visio.%3CBR%20%2F%3E2.Initially%20the%20excel%20has%204%20columns%20from%20'A'%20to%20'D'%20with%204%20rows%20of%20data.%3CBR%20%2F%3E3.We%20have%20selected%20only%20the%20columns%20'A'%2C%20'B'%2C%20'C'%20with%204%20rows%20of%20data%2C%20to%20display%20initially.%3CBR%20%2F%3E4.It%20went%20through%20well.%3CBR%20%2F%3E5.Then%2C%20we%20tried%20to%20%22edit%22%20the%20excel%20from%20visio%20and%20made%20columns%20'B'%2C%20'C'%2C%20'D'%20to%20display.%3CBR%20%2F%3E6.That%20too%20went%20very%20well.%3C%2FP%3E%3CP%3ENow%2C%20we%20are%20trying%20to%20do%20the%20same%20in%20program%20(C%23%20Code)%20%3A%3CBR%20%2F%3EWe%20would%20like%20to%20know%2C%3CBR%20%2F%3E1.%20How%20you%20programmatically%20manipulate%20the%20%22Position%22%2C%20%22Height%22%2C%20%22Width%22%2C%20%22Columns%22%20%26amp%3B%20%22Rows%22%20of%20the%20excel%20(embedded%20-%20Foreign%20Object)%2C%20%26amp%3B%20and%20place%20it%20in%20the%20visio.%3CBR%20%2F%3E2.%20So%20that%2C%20at%20one%20point%20we%20can%20display%20the%20column%20'A'%2C%20'B'%2C%20'C'%20%26amp%3B%20at%20another%20point%20we%20can%20display%20the%20column%20'B'%2C%20'C'%2C%20'D'.%3CBR%20%2F%3E3.%20Also%2C%20we%20converted%20the%20'VSDX'%20file%20into%20'ZIP'%20file%20and%20examined%20the%20'XML'%20files.%3CBR%20%2F%3E4.%20But%2C%20we%20could%20not%20find%20the%20details%20about%20the%20%22Position%22%2C%20%22Height%22%2C%20%22Width%22%2C%20%22Columns%22%20%26amp%3B%20%22Rows%22%20of%20excel%20in%20the%20'XML'.%3CBR%20%2F%3E5.%20Could%20you%20share%20the%20intel%20where%20to%20find%20the%20abovesaid%205%20attributes%20in%20which%20'XML'.%3CBR%20%2F%3EPlease%20help%20us%20%26amp%3B%20provide%20a%20suitable%20answer.%3CBR%20%2F%3EWith%20this%20we%20have%20attached%20the%20visio%20%26amp%3B%20excel%20as%20a%20'Zip'%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1270901%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eembed%20excel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Dear Team,
Manually we tried the following steps:
1.We try to embed an excel in visio.
2.Initially the excel has 4 columns from 'A' to 'D' with 4 rows of data.
3.We have selected only the columns 'A', 'B', 'C' with 4 rows of data, to display initially.
4.It went through well.
5.Then, we tried to "edit" the excel from visio and made columns 'B', 'C', 'D' to display.
6.That too went very well.

Now, we are trying to do the same in program (C# Code) :
We would like to know,
1. How you programmatically manipulate the "Position", "Height", "Width", "Columns" & "Rows" of the excel (embedded - Foreign Object), & and place it in the visio.
2. So that, at one point we can display the column 'A', 'B', 'C' & at another point we can display the column 'B', 'C', 'D'.
3. Also, we converted the 'VSDX' file into 'ZIP' file and examined the 'XML' files.
4. But, we could not find the details about the "Position", "Height", "Width", "Columns" & "Rows" of excel in the 'XML'.
5. Could you share the intel where to find the abovesaid 5 attributes in which 'XML'.
Please help us & provide a suitable answer.
With this we have attached the visio & excel as a 'Zip' file.

0 Replies