quinta-feira, 10 de dezembro de 2009

]] XL-mania [[ cara edit (hapus / save / update ) file XML lewat makro excel

<chart caption='LE HARIAN' subcaption='Senin, 26 Oktober 2009'
lineThickness='5' showValues='1' formatNumberScale='0' anchorRadius='2'
divLineAlpha='20' divLineColor='CC3300' divLineIsDashed='1' showAlternateHGridColor='1'
alternateHGridColor='CC3300' shadowAlpha='40' labelStep="1" numvdivlines='7'
chartRightMargin="35" bgColor='FFFFFF,CC3300' bgAngle='270' bgAlpha='10,10'
xAxisName='Jam Ke' yAxisName='Nilai' outCnvBaseFontSize='14' bgSWF='slideshow.jpg'
canvasBgAlpha='70' yAxisMinValue='75' yAxisMaxValue='110' setAdaptiveYMin='0'
rotateValues='1' >

<categories>
<category label="1" />
<category label="2" />
<category label="3" />
<category label="4" />
<category label="5" />
<category label="6" />
<category label="7" />
<category label="8" />
<category label="9" />
</categories>
<dataset seriesname="Formasi A">
<set value="90.86" anchorSides='10' anchorBgColor='ff4800' anchorRadius='6' />
<set value="90.87" anchorSides='10' anchorBgColor='ff4800' anchorRadius='6' />
<set value="92.03" anchorSides='10' anchorBgColor='ff4800' anchorRadius='6'/>
<set value="95.85" anchorSides='10' anchorBgColor='ff4800' anchorRadius='6'/>
<set value="100.01" anchorSides='10' anchorBgColor='ff4800' anchorRadius='6'/>
<set value="93.56" anchorSides='10' anchorBgColor='ff4800' anchorRadius='6'/>
<set value="85.98" anchorSides='10' anchorBgColor='ff4800' anchorRadius='6'/>
<set value="100.97" anchorSides='10' anchorBgColor='ff4800' anchorRadius='6'/>

</dataset>

<trendLines>
<line startValue='90' color='ff4800' displayvalue='Target' Thickness='4' dashed='1' valueOnRight='1' />
</trendLines>

<styles>

<definition>
<style name='myBevel' type='bevel' distance='6' />
<style name='myGlow' type='glow' color='999999' />
<style name='myFont' type='font' isHTML='1' bold='1' size='16' color='FFFFFF' />
<style name='fontku' type='font' color='ff4800' size='14' />
<style name='myShadow' type='shadow' color='333333' angle='45' strength='3'/>
<style name='CanvasAnim' type='animation' param='_xScale' start='0' duration='1' />
</definition>

<application>
<apply toObject='ANCHORS' styles='bevel' />
<apply toObject='ANCHORS' styles='myglow' />
<apply toObject='Canvas' styles='CanvasAnim' />
<apply toObject='DataValues' styles='fontku' />
<apply toObject='YAxisName' styles='myFont,myShadow' />
<apply toObject='XAxisName' styles='myFont,myShadow' />
<apply toObject='Caption' styles='myFont,myShadow' />
<apply toObject='Subcaption' styles='myFont,myShadow' />
</application>

</styles>

</chart>
 

dear xl master,
saya ada beberapa masalah nich. gimana caranya kita bisa edit file xml
lewat makro excel sebagai interfacenya. maklum biasanya sich saya edit
langsung lewat text editor. tapi kurang efisien mengingat kita harus
pilih tag xml satu-satu. Jika ada cara tolong donk !!!

Thx All

--
IMPORTANT NOTICE from ER1CK :
E-mail ini bisa berisi informasi yang bersifat rahasia atau untuk
kalangan tertentu dan/atau informasi yang dilindungi hak cipta.
Apabila e-mail ini diterima tanpa disengaja, dengan ini diinformasikan
bahwa dilarang keras untuk menyebarkan, menyalurkan, menyingkapkan,
atau menggandakan e-mail ini, ataupun bagian manapun dari e-mail ini.

__._,_.___
+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Momods belum sarapan nih... Huhuhuhu...                           |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf          |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau...  |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+
.

__,_._,___

Nenhum comentário:

Postar um comentário