none
Problème excel services : impossible de faire fonctionner une UDF simple !!!! RRS feed

  • Question

  • Bonjour,

    Je cherche à faire fonctionner une UDF excel services sur un serveur Sharepoint 2007, mais je n'y parviens pas.

    mais quand j'ouvre mon fichier excel depuis sharepoint (j'ai cliqué sur afficher le fichier dans le navigateur web), la fonction renvoit toujours #NAME

    Sharepoint semble etre configuré convenablement. Voici les étapes que j'ai suivies : 

    - ajout du chemin vers la dll et activation de celle-ci dans la liste des assemblies
    - activation des UDF dans la page de configuration de la trusted location où se trouve le workbook)

    Ci-dessous, voici le code de l'UDF en question.

    Toutes les idées sont bienvenues.

    Cheers !


    using System;
    using Microsoft.Office.Excel.Server.Udf;

    namespace SampleUdfLibrary
    {
        [UdfClass]
        class Class1
        {
            [UdfMethod]
            public string GetLastWord(string phrase)
            {
                int lastSpace = phrase.Trim().LastIndexOf(" ");
                if (lastSpace == -1)
                    return phrase;

                string result = phrase.Substring(lastSpace + 1);
                return result;
            }
        }
    }

    vendredi 12 février 2010 18:09

Réponses

Toutes les réponses

  • Bonjour,

    que disent le journal d'événement et les logs SharePoint ?
    http://blogs.developpeur.org/anouvel
    Merci de valider les réponses qui correspondent à votre problème afin qu'il apparaisse comme résolu.
    samedi 13 février 2010 11:30
  • Bonjour,

    je n'ai rien vu de particulier dans les logs. Aucune erreur en tout cas. En voici un extrait : 

    02/15/2010 11:01:50.59 	w3wp.exe (0x1E48)                       	0x1E88	Excel Services                	Excel Services Session        	5pbu	Medium  	SessionManager.BeginRequest: There are 1 active users	 
    02/15/2010 11:01:50.59 	w3wp.exe (0x1E48)                       	0x1E88	Excel Services                	Excel Services Session        	1sxs	Medium  	SessionManager.BeginRequest: Created Session id=21.4KqlwBYVucOxUsY7AkNyX90.5.fr-FR5.fr-FR73.-0060#0000-10-00-05T03:00:00:0000#+0000#0000-03-00-05T02:00:00:0000#-0060, caller=fe80::90ef:bac0:b197:d857%10	 
    02/15/2010 11:01:50.62 	w3wp.exe (0x1E48)                       	0x18F4	Excel Services                	Excel Services Cache          	4n14	Medium  	UserWorkbook.CreateWorkbookJob: Starting to create a UserWorkbook for BaseWorkbook http://192.168.254.4:8081/Documents partages/testUdf.xlsx	00000006-8bd9-96b3-0000-000050f7b00b
    02/15/2010 11:01:50.62 	w3wp.exe (0x1E48)                       	0x0260	Excel Services                	Excel Calculation Services    	2m5e	Information	Session opened with workbook http://192.168.254.4:8081/Documents partages/testUdf.xlsx. [Session: 21.4KqlwBYVucOxUsY7AkNyX90.5.fr-FR5.fr-FR73.-0060#0000-10-00-05T03:00:00:0000#+0000#0000-03-00-05T02:00:00:0000#-0060 User: SHAREPOINT\system]	00000006-8bd9-96b3-0000-000050f7b00b
    02/15/2010 11:01:50.62 	w3wp.exe (0x1E48)                       	0x18F4	Excel Services                	Excel Services Cache          	4n15	Medium  	UserWorkbook.CreateWorkbookJob: Successfully created a UserWorkbook for BaseWorkbook http://192.168.254.4:8081/Documents partages/testUdf.xlsx	00000006-8bd9-96b3-0000-000050f7b00b
    02/15/2010 11:01:50.63 	w3wp.exe (0x1E48)                       	0x0260	Excel Services                	Excel Calculation Services    	5cag	Medium  	ExcelService.PostProcessRequest: finished request of type OpenWorkbook	00000006-8bd9-96b3-0000-000050f7b00b
    02/15/2010 11:01:50.63 	w3wp.exe (0x1580)                       	0x1D50	Excel Services                	Excel Services Web Front End  	6k39	Medium  	ExcelServerProxy.ExecuteWebMethod: request of type OpenWorkbook succeeded, from server=http://sharepoint:56737/SharedServices1/ExcelCalculationServer/ExcelService.asmx, session=21.4KqlwBYVucOxUsY7AkNyX90.5.fr-FR5.fr-FR73.-0060#0000-10-00-05T03:00:00:0000#+0000#0000-03-00-05T02:00:00:0000#-0060, new state id=1	 
    02/15/2010 11:01:50.63 	w3wp.exe (0x1580)                       	0x1D50	Excel Services                	Excel Services Web Front End  	6k30	Medium  	ExcelServerProxy.SetReachable: server: http://SHAREPOINT:56737/SharedServices1/ExcelCalculationServer/ExcelService.asmx.	 
    02/15/2010 11:01:50.63 	w3wp.exe (0x1580)                       	0x1D50	Excel Services                	Excel Web Access              	5cbj	Medium  	InternalEwr.RenderWebPart: Finished rendering internal EWR	 
    02/15/2010 11:01:51.88 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task ExcelServerApp.PerformThreadPoolProcess	 
    02/15/2010 11:01:51.88 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task ExcelServerApp.PerformThreadPoolProcess	 
    02/15/2010 11:01:51.88 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task SessionManager.PerformSessionTimeouts	 
    02/15/2010 11:01:51.88 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task SessionManager.PerformSessionTimeouts	 
    02/15/2010 11:01:51.88 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/15/2010 11:01:51.88 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/15/2010 11:01:51.88 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task Disk Manager.PerformCleanup	 
    02/15/2010 11:01:51.88 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jg2	Medium  	ResourceManager.PerformCleanup: Disk Manager: CurrentSize=17354.	 
    02/15/2010 11:01:51.88 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Services Cache          	767i	Medium  	UnusedItemManager.Evict: Start eviction of Unused Disk Item Manager, Total Unused Items Size: 2722, mode = EvictAll	 
    02/15/2010 11:01:51.88 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task Disk Manager.PerformCleanup	 
    lundi 15 février 2010 09:58
  • Bonjour,

    Vos logs montrent que la publication de votre classeur se passe bien. Je ne vois pas les logs concernant la consultation du classeur en ligne par contre...

    A tout hasard, sachez qu'il est "normal" que vous ayez #NAME d'indiquer sur votre classeur Excel car aucun lien n'est reellement fait avec les services Excel de SharePoint... donc vos UDF ne sont pas reconnues depuis le classeur Excel (des workarounds existent).

    En revanche, lorsque vous consultez le classeur en ligne après publication le #NAME ne doit pas apparaître.

    Vous confirmez que votre problème concerne bien l'affichage en ligne, pas uniquement depuis Excel ?

    Sébastien PICAMELOT - http://blogs.developpeur.org/gribouillon/
    mardi 16 février 2010 10:21
    Modérateur
  • Bonjour

    oui j'accède bien au classeur depuis l'interface web, et c'est là que j'ai ce message...

    Merci de votre aide en tout cas !

    Terence
    mardi 16 février 2010 11:26
  • Pouvez vous montrer les logs SharePoint au moment ou vous accéder au classeur avec l'interface Web ?

    Pouvez vous montrer la formule du classeur Excel qui affiche #NAME ?

    http://blogs.developpeur.org/gribouillon/
    mercredi 17 février 2010 10:48
    Modérateur
  • Donc, dans le classeur excel :

    A1=toto va a la mer
    A2=GetLastWord(A1)

    Le nom de la methode est GetLastWord

    voici les logs sharepoint à l'heure de l'accès au classeur via l'interface web :

    02/17/2010 12:07:03.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:07:03.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:07:04.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:07:04.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:07:04.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:07:04.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:07:04.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task Memory Manager.PerformCleanup	 
    02/17/2010 12:07:04.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jg2	Medium  	ResourceManager.PerformCleanup: Memory Manager: CurrentSize=157085696.	 
    02/17/2010 12:07:04.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task Memory Manager.PerformCleanup	 
    02/17/2010 12:07:08.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:07:08.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:07:09.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task Disk Manager.PerformCleanup	 
    02/17/2010 12:07:09.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jg2	Medium  	ResourceManager.PerformCleanup: Disk Manager: CurrentSize=923567.	 
    02/17/2010 12:07:09.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task Disk Manager.PerformCleanup	 
    02/17/2010 12:07:09.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:07:09.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:07:09.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:07:09.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:07:09.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task Memory Manager.PerformCleanup	 
    02/17/2010 12:07:09.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jg2	Medium  	ResourceManager.PerformCleanup: Memory Manager: CurrentSize=157106176.	 
    02/17/2010 12:07:09.92 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task Memory Manager.PerformCleanup	 
    02/17/2010 12:07:13.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:07:13.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:07:14.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:07:14.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:07:14.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:07:14.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:07:14.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task Memory Manager.PerformCleanup	 
    02/17/2010 12:07:14.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jg2	Medium  	ResourceManager.PerformCleanup: Memory Manager: CurrentSize=157106176.	 
    02/17/2010 12:07:14.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task Memory Manager.PerformCleanup	 
    02/17/2010 12:07:18.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task ConnectionManager.PerformPoolsCleanUp	 
    02/17/2010 12:07:18.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task ConnectionManager.PerformPoolsCleanUp	 
    02/17/2010 12:07:18.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:07:18.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:07:19.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task Disk Manager.PerformCleanup	 
    02/17/2010 12:07:19.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jg2	Medium  	ResourceManager.PerformCleanup: Disk Manager: CurrentSize=923567.	 
    02/17/2010 12:07:19.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task Disk Manager.PerformCleanup	 
    02/17/2010 12:07:19.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:07:19.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:07:19.55 	w3wp.exe (0x1BCC)                       	0x1A1C	Excel Services                	Excel Web Access              	5cbf	Medium  	ExcelWebRenderer.OnLoad: Starting loading external EWR	 
    02/17/2010 12:07:19.59 	w3wp.exe (0x1BCC)                       	0x1A1C	Excel Services                	Excel Web Access              	5cbg	Medium  	ExcelWebRenderer.RenderWebPart: Finished rendering external EWR	 
    02/17/2010 12:07:19.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:07:19.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:07:19.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task Memory Manager.PerformCleanup	 
    02/17/2010 12:07:19.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jg2	Medium  	ResourceManager.PerformCleanup: Memory Manager: CurrentSize=157106176.	 
    02/17/2010 12:07:19.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	5pbr	Medium  	ResourceManager.EvictUnusedItems: Memory Manager: Going to evict unused items. CurrentSize: 157106176.	 
    02/17/2010 12:07:19.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Services Cache          	767i	Medium  	UnusedItemManager.Evict: Start eviction of Unused Memory Item Manager, Total Unused Items Size: 1224140, mode = EvictStale	 
    02/17/2010 12:07:19.92 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	5pbs	Medium  	ResourceManager.EvictUnusedItems: Memory Manager: After unused items eviction. CurrentSize: 157106176  Diff:0.	 
    02/17/2010 12:07:19.92 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task Memory Manager.PerformCleanup	 
    02/17/2010 12:07:20.07 	w3wp.exe (0x1BCC)                       	0x1EB8	Excel Services                	Excel Web Access              	5cbi	Medium  	InternalEwr.OnInit: Starting loading external EWR	 
    02/17/2010 12:07:20.12 	w3wp.exe (0x1BCC)                       	0x1EB8	Excel Services                	Excel Services Web Front End  	6k38	Medium  	ExcelServerProxy.ExecuteWebMethod: sending request of type OpenWorkbook, to server=http://sharepoint:56737/SharedServices1/ExcelCalculationServer/ExcelService.asmx, session=(null), state id=0	 
    02/17/2010 12:07:20.13 	w3wp.exe (0x1E48)                       	0x18A4	Excel Services                	Excel Calculation Services    	766u	Medium  	ExcelService.LogRequest: starting request of type OpenWorkbook	 
    02/17/2010 12:07:20.13 	w3wp.exe (0x1E48)                       	0x18A4	Excel Services                	Excel Services Session        	5pbu	Medium  	SessionManager.BeginRequest: There are 1 active users	 
    02/17/2010 12:07:20.13 	w3wp.exe (0x1E48)                       	0x18A4	Excel Services                	Excel Services Session        	1sxs	Medium  	SessionManager.BeginRequest: Created Session id=23.221ucRqD/Xz+G9J0W5AI+CI90.5.fr-FR5.fr-FR73.-0060#0000-10-00-05T03:00:00:0000#+0000#0000-03-00-05T02:00:00:0000#-0060, caller=fe80::90ef:bac0:b197:d857%10	 
    02/17/2010 12:07:20.15 	w3wp.exe (0x1E48)                       	0x18A4	Excel Services                	Excel Calculation Services    	5pam	Medium  	BaseWorkbookManager.BeginGetBaseWorkbookAndMarkUsed: There are 2 Base Workbooks in the Base Workbook Manager	0000030f-8bd9-96b3-0000-000050f7b00b
    02/17/2010 12:07:20.15 	w3wp.exe (0x1E48)                       	0x18A4	Excel Services                	Excel Services Cache          	27e7	Medium  	BaseWorkbookManager.BeginGetBaseWorkbookAndMarkUsed: Spawning BaseWorkbook job to load the file.	0000030f-8bd9-96b3-0000-000050f7b00b
    02/17/2010 12:07:20.15 	w3wp.exe (0x1E48)                       	0x18A4	Excel Services                	Excel Services Cache          	5c9o	Medium  	BaseWorkbook.CacheStream: Fetching "http://192.168.254.4:8081/Documents partages/testUdf.xlsx" to local disk cache as "C:\Windows\TEMP\Excel Server\FileCache\SharedServices1-1481727773\561155d8-0fae-422c-b253-875da850c175.xlsx.xlserver"	0000030f-8bd9-96b3-0000-000050f7b00b
    02/17/2010 12:07:20.15 	w3wp.exe (0x1E48)                       	0x18F4	Excel Services                	Excel Services Cache          	1swc	Medium  	BaseWorkbook.LoadWorkbookJob: Asking cache for workbook file http://192.168.254.4:8081/Documents partages/testUdf.xlsx.	0000030f-8bd9-96b3-0000-000050f7b00b
    02/17/2010 12:07:20.15 	w3wp.exe (0x1E48)                       	0x18F4	Excel Services                	Excel Services Cache          	1swd	Medium  	BaseWorkbook.LoadWorkbookJob: Loading BaseWorkbook from disk - starting from file C:\Windows\TEMP\Excel Server\FileCache\SharedServices1-1481727773\561155d8-0fae-422c-b253-875da850c175.xlsx.xlserver.	0000030f-8bd9-96b3-0000-000050f7b00b
    02/17/2010 12:07:20.16 	w3wp.exe (0x1E48)                       	0x1E88	Excel Services                	Excel Services Cache          	4n14	Medium  	UserWorkbook.CreateWorkbookJob: Starting to create a UserWorkbook for BaseWorkbook http://192.168.254.4:8081/Documents partages/testUdf.xlsx	0000030f-8bd9-96b3-0000-000050f7b00b
    02/17/2010 12:07:20.16 	w3wp.exe (0x1E48)                       	0x18F4	Excel Services                	Excel Services Cache          	2ooo	Medium  	BaseWorkbook.LoadWorkbookJob: Loading BaseWorkbook from disk - completed successfully	0000030f-8bd9-96b3-0000-000050f7b00b
    02/17/2010 12:07:20.17 	w3wp.exe (0x1E48)                       	0x0260	Excel Services                	Excel Calculation Services    	2m5e	Information	Session opened with workbook http://192.168.254.4:8081/Documents partages/testUdf.xlsx. [Session: 23.221ucRqD/Xz+G9J0W5AI+CI90.5.fr-FR5.fr-FR73.-0060#0000-10-00-05T03:00:00:0000#+0000#0000-03-00-05T02:00:00:0000#-0060 User: SHAREPOINT\system]	0000030f-8bd9-96b3-0000-000050f7b00b
    02/17/2010 12:07:20.17 	w3wp.exe (0x1E48)                       	0x1E88	Excel Services                	Excel Services Cache          	4n15	Medium  	UserWorkbook.CreateWorkbookJob: Successfully created a UserWorkbook for BaseWorkbook http://192.168.254.4:8081/Documents partages/testUdf.xlsx	0000030f-8bd9-96b3-0000-000050f7b00b
    02/17/2010 12:07:20.17 	w3wp.exe (0x1E48)                       	0x0260	Excel Services                	Excel Calculation Services    	5cag	Medium  	ExcelService.PostProcessRequest: finished request of type OpenWorkbook	0000030f-8bd9-96b3-0000-000050f7b00b
    02/17/2010 12:07:20.17 	w3wp.exe (0x1BCC)                       	0x1EB8	Excel Services                	Excel Services Web Front End  	6k39	Medium  	ExcelServerProxy.ExecuteWebMethod: request of type OpenWorkbook succeeded, from server=http://sharepoint:56737/SharedServices1/ExcelCalculationServer/ExcelService.asmx, session=23.221ucRqD/Xz+G9J0W5AI+CI90.5.fr-FR5.fr-FR73.-0060#0000-10-00-05T03:00:00:0000#+0000#0000-03-00-05T02:00:00:0000#-0060, new state id=1	 
    02/17/2010 12:07:20.17 	w3wp.exe (0x1BCC)                       	0x1EB8	Excel Services                	Excel Services Web Front End  	6k30	Medium  	ExcelServerProxy.SetReachable: server: http://SHAREPOINT:56737/SharedServices1/ExcelCalculationServer/ExcelService.asmx.	 
    02/17/2010 12:07:20.39 	w3wp.exe (0x1BCC)                       	0x1EB8	Excel Services                	Excel Web Access              	5cbj	Medium  	InternalEwr.RenderWebPart: Finished rendering internal EWR	 
    02/17/2010 12:07:23.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:07:23.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:07:24.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:07:24.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:07:24.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:07:24.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:07:24.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task Memory Manager.PerformCleanup	 
    02/17/2010 12:07:24.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jg2	Medium  	ResourceManager.PerformCleanup: Memory Manager: CurrentSize=157962240.	 
    02/17/2010 12:07:24.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task Memory Manager.PerformCleanup	 
    02/17/2010 12:07:28.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:07:28.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:07:29.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task Disk Manager.PerformCleanup	 
    02/17/2010 12:07:29.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jg2	Medium  	ResourceManager.PerformCleanup: Disk Manager: CurrentSize=940921.	 
    02/17/2010 12:07:29.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Services Cache          	767i	Medium  	UnusedItemManager.Evict: Start eviction of Unused Disk Item Manager, Total Unused Items Size: 2722, mode = EvictAll	 
    02/17/2010 12:07:29.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task Disk Manager.PerformCleanup	 
    02/17/2010 12:07:29.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:07:29.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:07:29.84 	w3wp.exe (0x1BCC)                       	0x1A1C	SharePoint Portal Server      	Runtime                       	8gp7	Medium  	Topology cache updated. (AppDomain: /LM/W3SVC/1406660870/ROOT-1-129108713360150000)	 
    02/17/2010 12:07:29.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:07:29.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:07:29.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task Memory Manager.PerformCleanup	 
    02/17/2010 12:07:29.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jg2	Medium  	ResourceManager.PerformCleanup: Memory Manager: CurrentSize=158203904.	 
    02/17/2010 12:07:29.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task Memory Manager.PerformCleanup	 
    02/17/2010 12:07:33.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:07:33.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:07:34.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:07:34.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:07:34.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:07:34.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:07:34.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task Memory Manager.PerformCleanup	 
    02/17/2010 12:07:34.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jg2	Medium  	ResourceManager.PerformCleanup: Memory Manager: CurrentSize=158466048.	 
    02/17/2010 12:07:34.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task Memory Manager.PerformCleanup	 
    02/17/2010 12:07:38.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:07:38.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:07:39.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task Disk Manager.PerformCleanup	 
    02/17/2010 12:07:39.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jg2	Medium  	ResourceManager.PerformCleanup: Disk Manager: CurrentSize=938199.	 
    02/17/2010 12:07:39.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Services Cache          	767i	Medium  	UnusedItemManager.Evict: Start eviction of Unused Disk Item Manager, Total Unused Items Size: 0, mode = EvictAll	 
    02/17/2010 12:07:39.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task Disk Manager.PerformCleanup	 
    02/17/2010 12:07:39.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:07:39.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:07:39.90 	w3wp.exe (0x1E48)                       	0x0134	Windows SharePoint Services   	General                       	0	Medium  	Entering MRU trim routine.	 
    02/17/2010 12:07:39.90 	w3wp.exe (0x1E48)                       	0x0134	Windows SharePoint Services   	General                       	0	Medium  	Initial table size: 13255913 in 112 entries	 
    02/17/2010 12:07:39.90 	w3wp.exe (0x1E48)                       	0x0134	Windows SharePoint Services   	General                       	0	Medium  	Final table size: 13255913 in 112 entries	 
    02/17/2010 12:07:39.90 	w3wp.exe (0x1E48)                       	0x0134	Windows SharePoint Services   	General                       	0	Medium  	Exiting MRU trim routine.	 
    02/17/2010 12:07:39.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:07:39.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:07:39.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task Memory Manager.PerformCleanup	 
    02/17/2010 12:07:39.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jg2	Medium  	ResourceManager.PerformCleanup: Memory Manager: CurrentSize=158748672.	 
    02/17/2010 12:07:39.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task Memory Manager.PerformCleanup	 
    02/17/2010 12:07:43.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:07:43.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:07:44.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:07:44.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:07:44.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:07:44.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:07:44.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task Memory Manager.PerformCleanup	 
    02/17/2010 12:07:44.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jg2	Medium  	ResourceManager.PerformCleanup: Memory Manager: CurrentSize=159010816.	 
    02/17/2010 12:07:44.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task Memory Manager.PerformCleanup	 
    02/17/2010 12:07:48.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:07:48.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:07:49.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task Disk Manager.PerformCleanup	 
    02/17/2010 12:07:49.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jg2	Medium  	ResourceManager.PerformCleanup: Disk Manager: CurrentSize=938199.	 
    02/17/2010 12:07:49.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task Disk Manager.PerformCleanup	 
    02/17/2010 12:07:49.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:07:49.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:07:49.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:07:49.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:07:49.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task Memory Manager.PerformCleanup	 
    02/17/2010 12:07:49.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jg2	Medium  	ResourceManager.PerformCleanup: Memory Manager: CurrentSize=159272960.	 
    02/17/2010 12:07:49.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task Memory Manager.PerformCleanup	 
    02/17/2010 12:07:53.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:07:53.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:07:54.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:07:54.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:07:54.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:07:54.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:07:54.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task Memory Manager.PerformCleanup	 
    02/17/2010 12:07:54.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jg2	Medium  	ResourceManager.PerformCleanup: Memory Manager: CurrentSize=159535104.	 
    02/17/2010 12:07:54.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task Memory Manager.PerformCleanup	 
    02/17/2010 12:07:54.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task ConnectionManager.PerformPoolsCleanUp	 
    02/17/2010 12:07:54.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task ConnectionManager.PerformPoolsCleanUp	 
    02/17/2010 12:07:58.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:07:58.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:07:59.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task Disk Manager.PerformCleanup	 
    02/17/2010 12:07:59.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jg2	Medium  	ResourceManager.PerformCleanup: Disk Manager: CurrentSize=938199.	 
    02/17/2010 12:07:59.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task Disk Manager.PerformCleanup	 
    02/17/2010 12:07:59.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:07:59.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:07:59.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:07:59.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:07:59.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task Memory Manager.PerformCleanup	 
    02/17/2010 12:07:59.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jg2	Medium  	ResourceManager.PerformCleanup: Memory Manager: CurrentSize=159776768.	 
    02/17/2010 12:07:59.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task Memory Manager.PerformCleanup	 
    02/17/2010 12:08:03.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:08:03.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:08:04.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:08:04.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:08:04.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:08:04.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:08:04.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task Memory Manager.PerformCleanup	 
    02/17/2010 12:08:04.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jg2	Medium  	ResourceManager.PerformCleanup: Memory Manager: CurrentSize=159776768.	 
    02/17/2010 12:08:04.92 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task Memory Manager.PerformCleanup	 
    02/17/2010 12:08:08.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:08:08.96 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task ExcelServerApp.PerformThreadPoolProcess	 
    02/17/2010 12:08:09.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task Disk Manager.PerformCleanup	 
    02/17/2010 12:08:09.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jg2	Medium  	ResourceManager.PerformCleanup: Disk Manager: CurrentSize=938199.	 
    02/17/2010 12:08:09.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task Disk Manager.PerformCleanup	 
    02/17/2010 12:08:09.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:08:09.09 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task RequestManager.RequestTimeoutCleanupPollInterval	 
    02/17/2010 12:08:09.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:08:09.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task SessionManager.PerformSessionTimeouts	 
    02/17/2010 12:08:09.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfd	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Starting task Memory Manager.PerformCleanup	 
    02/17/2010 12:08:09.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jg2	Medium  	ResourceManager.PerformCleanup: Memory Manager: CurrentSize=159797248.	 
    02/17/2010 12:08:09.91 	w3wp.exe (0x1E48)                       	0x1BD8	Excel Services                	Excel Calculation Services    	8jfe	Medium  	BackgroundTaskManager.ExecuteBackgroundTasks: Finished task Memory Manager.PerformCleanup	 

    mercredi 17 février 2010 11:03
  • Pas d'erreur dans les logs, ce qui écarte :
    • tout problème durant l'exécution
    • le fait que la DLL ne soit pas trouvée
    L'appel et la déclaration sont OK également.

    Par élimination j'aurai pensé à un problème de configuration si vous n'aviez pas déjà vérifié (à tout hasard, la procédure est ici : http://msdn.microsoft.com/en-us/library/ms498462.aspx)

    Il faut forcer l'appel à cette méthode pour être sûr de ce qui se passe. Pouvez vous passer par l'API Excel Services pour lire votre classeur ? Vous trouverez un exemple de code (à adapter pour appeler lire la cellule contenant la formule GetLastWord) ici : http://msdn.microsoft.com/en-us/magazine/cc163374.aspx



    http://blogs.developpeur.org/gribouillon/
    mercredi 17 février 2010 13:20
    Modérateur
  • J'ai vérifié les points de configuration plusieurs fois, et je ne trouve toujours rien qui cloche...

    J'ai également essayé de passer par l'API Excel Services comme vous me l'aviez demandé, et le résultat est le même.

    Dans une page ASP.Net j'ai utilisé le code ci-dessous et la variable toto me renvoit toujours "NAME"...
        protected void Page_Load(object sender, EventArgs e)
        {
            string WorkbookName = "http://xxx.xxx.xxx.xxx/Documents partages/testUdf.xlsx";
    
            ES.ExcelService excelService = new ES.ExcelService();
            System.Net.NetworkCredential cred = new System.Net.NetworkCredential("administrateur", "password", "domain");
            excelService.Credentials = cred;
            string sessionId = excelService.OpenWorkbook(WorkbookName, String.Empty, String.Empty, out ES.Status[]);
    
            excelService.SetCellA1(sessionId, "Feuil1", "A1", "toto va a la mer");
            object toto = excelService.GetCellA1(sessionId, "Feuil1", "A2", false, out status);
    
            excelService.CloseWorkbook(sessionId);
        }


    jeudi 18 février 2010 13:15
  • Ok, j'ai rajouté l'attribut public à la classe et l'udf est maintenant accessible
    • Marqué comme réponse tpats lundi 22 février 2010 10:18
    lundi 22 février 2010 10:18