Visokio website     Downloads     Video tutorials     KnowledgeBase  
Batch Output for Excel - Specify Starting Row/Column - Visokio Forums
Batch Output for Excel - Specify Starting Row/Column
  •     OliverB February 3, 2016 11:11AM
    Hi,
    Last year we had a request to add some functionality to the batch config file so that when publishing to excel, we could use the Replace Data/Replace Worksheet/Overwrite data etc functionality that the individual data manager output blocks have . This was implemented and works very well.

    http://forums.visokio.com/discussion/2862/batch-publishing-output-excel-using-template-filess

    One other functionality that the data manager file output block has that doesn't appear to be available in the batch config files is to be able to specify a row or column to start inserting the data at. Would it be possible to add this functionality to the batch config file as well?
    Thanks

    Ollie.
  • 3 Comments
  •     bernardpi February 7, 2017 4:15AM
    Hi all, I would like to bump this thread. Is it at all possible to replicate the 'Specify Starting Row/Column' functionality contained in the Excel Output block to the Batch Configuration block? Thanks.
  •     chris February 7, 2017 9:32AM
    Hi,

    This has already been implemented:

    We have added two new fields to the batch configuration file:

    [Excel row insert position]
    [Excel column insert position]

    If you generate a new batch configuration file you should see these fields. For any existing batch configuration files, simply add two new fields with the names above.

    Apologies that we haven't reported this on the forum.

    Chris
  • zeropond March 22, 2017 2:04PM
    Hi
    Set objFS = CreateObject( "Scripting.FileSystemObject" )
    strFile = WScript.Arguments(0)
    Set objFile = objFS.OpenTextFile(strFile)
    Do Until objFile.AtEndOfStream
    strLine= objFile.ReadLine
    WScript.Echo strLine & " " & "test"
    Loop
    objFile.Close

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership