Hi all,
I've one excel sheet with custom formattation, I need to set the value in a specific range (ex: B5:G10) my sorce are one sql that retreive exactly 6 record with 6 fields.
can I do this with Cron?
I found the tasks Office/Excell/Set Cell but I don't understand how to set the source from sql and where I need to specific where I want to put the results value

Hi all,
I've one excel sheet with custom formattation, I need to set the value in a specific range (ex: B5:G10) my sorce are one sql that retreive exactly 6 record with 6 fields.
can I do this with Cron?
I found the tasks Office/Excell/Set Cell but I don't understand how to set the source from sql and where I need to specific where I want to put the results value

Hi Fabrizio,

You would need to use variables as the source. There are various SQL variables and the PrevTask Std out variable you can use to fetch the output of the sql query. Have you taken a look at the variables?

---

Hi Michael,
yes I know the {TASK(PrevTask|StdOut)} , I had already tried whit out result, this morning I looking for the problem and I found that the solution was on SQL connection.

SO, to answare at my thread post:

• create one SQL task with output Standard
  
• create on task Office Excel - Set cell and
  
• in the source Tab insert {TASK(PrevTask|StdOut)}
  
• in the Target Tab set Cell coordinates ( as you prefere by position or by reference)
  

thank
fabrizio

Hi Michael,
yes I know the {TASK(PrevTask|StdOut)} , I had already tried whit out result, this morning I looking for the problem and I found that the solution was on SQL connection.

SO, to answare at my thread post:

• create one SQL task with output Standard
  
• create on task Office Excel - Set cell and
  
• in the source Tab insert {TASK(PrevTask|StdOut)}
  
• in the Target Tab set Cell coordinates ( as you prefere by position or by reference)
  

thank
fabrizio

Thank you for the information, and i'm glad you found the solution!

---