API tools faq
paste
Guest User

Untitled

a guest
Oct 10th, 2019
432
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
XML 7.89 KB | None | 0 0
raw download clone embed print report
  1. <process name="__selection__Excel Extended AIKUDINO" type="object">
  2.   <subsheet subsheetid="13412551-003d-4e8e-9b6e-98881ebe6fc4" type="Normal" published="True">
  3.     <name>Range.Autofill</name>
  4.     <view>
  5.       <camerax>-38</camerax>
  6.       <cameray>0</cameray>
  7.       <zoom version="2">1.25</zoom>
  8.     </view>
  9.   </subsheet>
  10.   <stage stageid="700b0c1c-6589-4b21-86da-8eeff3508836" name="Range.Autofill" type="SubSheetInfo">
  11.     <subsheetid>13412551-003d-4e8e-9b6e-98881ebe6fc4</subsheetid>
  12.     <narrative></narrative>
  13.     <displayx>-195</displayx>
  14.     <displayy>-105</displayy>
  15.     <displaywidth>150</displaywidth>
  16.     <displayheight>90</displayheight>
  17.     <font family="Segoe UI" size="10" style="Regular" color="000000" />
  18.   </stage>
  19.   <stage stageid="0b97dbdc-ed5b-4e5b-94f5-3a2d24486182" name="Start" type="Start">
  20.     <subsheetid>13412551-003d-4e8e-9b6e-98881ebe6fc4</subsheetid>
  21.     <loginhibit />
  22.     <narrative></narrative>
  23.     <displayx>-45</displayx>
  24.     <displayy>-135</displayy>
  25.     <displaywidth>60</displaywidth>
  26.     <displayheight>30</displayheight>
  27.     <font family="Segoe UI" size="10" style="Regular" color="000000" />
  28.     <inputs>
  29.       <input type="number" name="handle" narrative="Excel handle" stage="handle" />
  30.       <input type="text" name="Workbook Name" narrative="Workbook Name" stage="workbookname" />
  31.       <input type="text" name="Worksheet Name" narrative="Worksheet Name" stage="worksheetname" />
  32.       <input type="number" name="Worksheet Index" narrative="or Worksheet index" stage="worksheetidx" />
  33.       <input type="text" name="SelectionRange" narrative="Source range" stage="srcRange" />
  34.       <input type="text" name="DestinationRange" narrative="Autofill range. Uses CurrentRegion when blank" stage="dstRange" />
  35.       <input type="number" name="xlAutoFillType" narrative="Default is 0 (xlFillDefault). https://docs.microsoft.com/en-us/dotnet/api/microsoft.office.interop.excel.xlautofilltype" stage="xlAutoFillType" />
  36.     </inputs>
  37.     <onsuccess>245151b3-fbdf-4e4d-b3a0-20d43372e87e</onsuccess>
  38.   </stage>
  39.   <stage stageid="7b7eba00-b2e3-4ed4-885a-403e3bb5ec80" name="End" type="End">
  40.     <subsheetid>13412551-003d-4e8e-9b6e-98881ebe6fc4</subsheetid>
  41.     <loginhibit />
  42.     <narrative></narrative>
  43.     <displayx>-45</displayx>
  44.     <displayy>-45</displayy>
  45.     <displaywidth>60</displaywidth>
  46.     <displayheight>30</displayheight>
  47.     <font family="Segoe UI" size="10" style="Regular" color="000000" />
  48.   </stage>
  49.   <stage stageid="245151b3-fbdf-4e4d-b3a0-20d43372e87e" name="Range.Autofill" type="Code">
  50.     <subsheetid>13412551-003d-4e8e-9b6e-98881ebe6fc4</subsheetid>
  51.     <loginhibit />
  52.     <narrative></narrative>
  53.     <displayx>-45</displayx>
  54.     <displayy>-90</displayy>
  55.     <displaywidth>120</displaywidth>
  56.     <displayheight>30</displayheight>
  57.     <font family="Tahoma" size="10" style="Regular" color="000000" />
  58.     <inputs>
  59.       <input type="number" name="handle" expr="[handle]" />
  60.       <input type="text" name="workbookname" expr="[workbookname]" />
  61.       <input type="text" name="worksheetname" expr="[worksheetname]" />
  62.       <input type="number" name="worksheetidx" expr="[worksheetidx]" />
  63.       <input type="text" name="srcRange" expr="[srcRange]" />
  64.       <input type="text" name="dstRange" expr="[dstRange]" />
  65.       <input type="number" name="xlAutoFillType" expr="[xlAutoFillType]" />
  66.     </inputs>
  67.     <outputs>
  68.       <output type="text" name="dstRangeDbg" stage="dstRange" />
  69.     </outputs>
  70.     <onsuccess>7b7eba00-b2e3-4ed4-885a-403e3bb5ec80</onsuccess>
  71.     <code><![CDATA[Dim xlInstance = GetInstance(handle)
  72. Dim xlWorkbook As Object = GetWorkbook(handle, workbookname)
  73. Dim xlSrcSheet As Object   
  74. If worksheetname <> "" then
  75.     xlSrcSheet = GetWorksheet(handle, workbookname, worksheetname,False)
  76. Elseif worksheetidx > 0 then
  77.     xlSrcSheet = xlWorkbook.Sheets(worksheetidx)
  78. Else
  79.     xlSrcSheet = xlWorkbook.ActiveSheet
  80. End if
  81.  
  82. if dstRange = "" then
  83. 'Normally Autofill works up to a non-empty cell, but it is too complicated, so we just fill up to the end of CurrentRegion.
  84. dstRange = xlSrcSheet.Range(
  85.             xlSrcSheet.Range(srcRange).Cells(1),
  86.             xlSrcSheet.Cells(xlSrcSheet.Range(srcRange).CurrentRegion.Cells(1).Row + xlSrcSheet.Range(srcRange).CurrentRegion.Rows.Count-1,
  87.                              xlSrcSheet.Range(srcRange).Cells(1).Column + xlSrcSheet.Range(srcRange).Columns.Count-1)).Address
  88. End if
  89.  
  90. dstRangeDbg = dstRange
  91. xlSrcSheet.Range(srcRange).Autofill(xlSrcSheet.Range(dstRange),xlAutoFillType)]]></code>
  92.   </stage>
  93.   <stage stageid="414593e2-f8e6-4c3b-93c8-725a7971b712" name="handle" type="Data">
  94.     <subsheetid>13412551-003d-4e8e-9b6e-98881ebe6fc4</subsheetid>
  95.     <narrative></narrative>
  96.     <displayx>105</displayx>
  97.     <displayy>-135</displayy>
  98.     <displaywidth>90</displaywidth>
  99.     <displayheight>30</displayheight>
  100.     <font family="Tahoma" size="10" style="Regular" color="000000" />
  101.     <datatype>number</datatype>
  102.     <initialvalue>0</initialvalue>
  103.     <private />
  104.     <alwaysinit />
  105.   </stage>
  106.   <stage stageid="fbfbfb61-9aba-448d-8012-363865eb5737" name="worksheetname" type="Data">
  107.     <subsheetid>13412551-003d-4e8e-9b6e-98881ebe6fc4</subsheetid>
  108.     <narrative></narrative>
  109.     <displayx>90</displayx>
  110.     <displayy>-45</displayy>
  111.     <displaywidth>60</displaywidth>
  112.     <displayheight>30</displayheight>
  113.     <font family="Tahoma" size="10" style="Regular" color="000000" />
  114.     <datatype>text</datatype>
  115.     <initialvalue />
  116.     <private />
  117.     <alwaysinit />
  118.   </stage>
  119.   <stage stageid="5324e6b8-0790-4eab-a15e-8081afe61e1e" name="workbookname" type="Data">
  120.     <subsheetid>13412551-003d-4e8e-9b6e-98881ebe6fc4</subsheetid>
  121.     <narrative></narrative>
  122.     <displayx>120</displayx>
  123.     <displayy>-90</displayy>
  124.     <displaywidth>120</displaywidth>
  125.     <displayheight>30</displayheight>
  126.     <font family="Tahoma" size="10" style="Regular" color="000000" />
  127.     <datatype>text</datatype>
  128.     <initialvalue />
  129.     <private />
  130.     <alwaysinit />
  131.   </stage>
  132.   <stage stageid="bf18e8d9-1672-4d58-a51e-1c06ea8661fb" name="worksheetidx" type="Data">
  133.     <subsheetid>13412551-003d-4e8e-9b6e-98881ebe6fc4</subsheetid>
  134.     <narrative></narrative>
  135.     <displayx>150</displayx>
  136.     <displayy>-45</displayy>
  137.     <displaywidth>60</displaywidth>
  138.     <displayheight>30</displayheight>
  139.     <font family="Segoe UI" size="10" style="Regular" color="000000" />
  140.     <datatype>number</datatype>
  141.     <initialvalue>0</initialvalue>
  142.     <private />
  143.     <alwaysinit />
  144.   </stage>
  145.   <stage stageid="a947e0ce-6275-42f0-b34c-02cd29d59a6c" name="srcRange" type="Data">
  146.     <subsheetid>13412551-003d-4e8e-9b6e-98881ebe6fc4</subsheetid>
  147.     <narrative></narrative>
  148.     <displayx>90</displayx>
  149.     <displayy>0</displayy>
  150.     <displaywidth>60</displaywidth>
  151.     <displayheight>30</displayheight>
  152.     <font family="Segoe UI" size="10" style="Regular" color="000000" />
  153.     <datatype>text</datatype>
  154.     <initialvalue />
  155.     <private />
  156.     <alwaysinit />
  157.   </stage>
  158.   <stage stageid="c3d15b6a-317a-4465-bd73-bebc51a72918" name="dstRange" type="Data">
  159.     <subsheetid>13412551-003d-4e8e-9b6e-98881ebe6fc4</subsheetid>
  160.     <narrative></narrative>
  161.     <displayx>150</displayx>
  162.     <displayy>0</displayy>
  163.     <displaywidth>60</displaywidth>
  164.     <displayheight>30</displayheight>
  165.     <font family="Segoe UI" size="10" style="Regular" color="000000" />
  166.     <datatype>text</datatype>
  167.     <initialvalue />
  168.     <private />
  169.     <alwaysinit />
  170.   </stage>
  171.   <stage stageid="1caa68d2-921f-449c-87cd-9b0e1368391e" name="xlAutoFillType" type="Data">
  172.     <subsheetid>13412551-003d-4e8e-9b6e-98881ebe6fc4</subsheetid>
  173.     <narrative></narrative>
  174.     <displayx>210</displayx>
  175.     <displayy>0</displayy>
  176.     <displaywidth>60</displaywidth>
  177.     <displayheight>30</displayheight>
  178.     <font family="Segoe UI" size="10" style="Regular" color="000000" />
  179.     <datatype>number</datatype>
  180.     <initialvalue>0</initialvalue>
  181.     <private />
  182.     <alwaysinit />
  183.   </stage>
  184. </process>
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!