Sign in
Microsoft.com
 
SharePoint Products TechCenter
 
 
 
SharePoint Products TechCenter > SharePoint Products and Technologies Forums > SharePoint - Workflow > why setting a value to an Excel sheet cell using Excel web service from inside sharepoint workflow is too slow?
Ask a questionAsk a question
Search Forums:
 

Questionwhy setting a value to an Excel sheet cell using Excel web service from inside sharepoint workflow is too slow?

  • Thursday, October 29, 2009 12:16 PMMohammadJizi Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    hi all i wish anyone could help me in this problem

    i developing a declerative sharepoint state machine workflow

    i have an asp page inside sharepoint that contains

    1- a drop down list that shows all the lists in the site collection i am working at
    2-a text box that i enters in it the name of my workflow
    3- an asp button

    when i press the button

    i create the declerative workflow recommended files:
    1-MyWorkflow.xoml
    2-MyWorkflow.xoml.rules
    3-MyWorkflow.xoml.config.xml

    then i create a folder called MyWorkflow

    then i add the above workflow folder with all the workflow files in it  to the built in document library in sharepoint called Workflows

    then i associate the workflow to a list

    every things works fine and the workflow runs perfectly on an item


    in my workflow i have a custom activity inherited from the base class Activity called CallExcelServiceActivity.

    at the execute function of this CallExcelServiceActivity i loop through all the fields of the item the workflow is running on, and add the field name as a key in a hashtable and the field value as the value in the same hashtable.


    then i create a new instance of a class called ExcelService found in another dll.
    this class take the hashtable and loop through every entry in the hashtable to fill the excel sheet with the keys and values of the hashtable

    my problem is that the performance of doing the above process is too slow

    while if i call the ExcelService  class from an asp page inside sharepoint and give it the hashtable it is very fast than from inside the workflow

    so is the problem is that when i try to call excel web serivce from inside workflow, it is  too slow
     

All Replies