private static ES.RangeCoordinates GetRangeCoordinates(ES.ExcelService es, string sessionId, string[] pos, string primaryKeyValue, string sheetName, ES.Status[] outStatus)
{
int startCol = ToIndex(pos[0]);
int startRow = int.Parse(pos[1]) - 1;
ES.RangeCoordinates range = new ES.RangeCoordinates();
range.Column = startCol;
range.Row = startRow;
range.Width = GetExcelCols(es, sessionId, startRow, sheetName, outStatus);
range.Height = GetExcelRows(es, sessionId, primaryKeyValue, sheetName, outStatus);
return range;
}
/// <remarks/>
public void SetRangeAsync(string sessionId, string sheetName, RangeCoordinates rangeCoordinates, object[] rangeValues) {
this.SetRangeAsync(sessionId, sheetName, rangeCoordinates, rangeValues, null);
}
/// <remarks/>
public void SetRangeAsync(string sessionId, string sheetName, RangeCoordinates rangeCoordinates, object[] rangeValues, object userState) {
if ((this.SetRangeOperationCompleted == null)) {
this.SetRangeOperationCompleted = new System.Threading.SendOrPostCallback(this.OnSetRangeOperationCompleted);
}
this.InvokeAsync("SetRange", new object[] {
sessionId,
sheetName,
rangeCoordinates,
rangeValues}, this.SetRangeOperationCompleted, userState);
}
public Status[] SetRange(string sessionId, string sheetName, RangeCoordinates rangeCoordinates, object[] rangeValues) {
object[] results = this.Invoke("SetRange", new object[] {
sessionId,
sheetName,
rangeCoordinates,
rangeValues});
return ((Status[])(results[0]));
}
/// <remarks/>
public void GetRangeAsync(string sessionId, string sheetName, RangeCoordinates rangeCoordinates, bool formatted) {
this.GetRangeAsync(sessionId, sheetName, rangeCoordinates, formatted, null);
}
public object[] GetRange(string sessionId, string sheetName, RangeCoordinates rangeCoordinates, bool formatted, out Status[] status) {
object[] results = this.Invoke("GetRange", new object[] {
sessionId,
sheetName,
rangeCoordinates,
formatted});
status = ((Status[])(results[1]));
return ((object[])(results[0]));
}
/// <remarks/>
public void CalculateAsync(string sessionId, string sheetName, RangeCoordinates rangeCoordinates) {
this.CalculateAsync(sessionId, sheetName, rangeCoordinates, null);
}
public Status[] Calculate(string sessionId, string sheetName, RangeCoordinates rangeCoordinates) {
object[] results = this.Invoke("Calculate", new object[] {
sessionId,
sheetName,
rangeCoordinates});
return ((Status[])(results[0]));
}