LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 516
Default Not able to write in published workbook using Excel Service SetRan

Hello,
I have a Windows application used to read a workbook (sheet1,
EmployeeListRange) through Excel Web Service and display the returned values
in a DataGridView. This part is working fine using Excel Web Service'
GetRangeA1() web method.

Next, I would like to add more enties in DataGridView and save all items in
the previous workbook using Excel Web Service' SetRangeA1() method but this
operation just does work. There is no SOAPException generated. Here is a
portion of the code used to submit the dataGridView data (employeeList array)

try
{
status = excelServ.SetRangeA1(sessionId, "Sheet1", "EmployeeListRange",
employeeList);
}
catch (SoapException ex)
{
Console.WriteLine("SOAP Exception Message: {0}", ex.Message);
}

Is there any additional setup I have to perform on my MOSS server?
Please help!
Matt
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fix Excel Protection so that it works as published Christopher Rath Excel Discussion (Misc queries) 8 July 4th 09 12:18 AM
Unshared workbook allowing write access to more than 1 user [email protected] Excel Discussion (Misc queries) 0 August 2nd 06 03:14 PM
Can a service account be embedded in Workbook so that by default the macros are run with service account credentials and not the user credentials??? Divya Sanam Excel Discussion (Misc queries) 0 July 20th 06 05:15 PM
Write Contents of TextBox to new Workbook Andy Tallent Excel Discussion (Misc queries) 0 February 21st 05 11:45 AM


All times are GMT +1. The time now is 02:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"