在电子表格中添加行(基于列表的供稿)，但行不通 [英] Add row in spreadsheet (List-based feed) but it not works

问题描述

我已经使用下面的代码在电子表格(基于列表的供稿)中添加行，但是它行不通...

I have used the bellow code to add row in spreadsheet (List-based feed) but it not works ...

NSMutableArray * array = [[NSMutableArray alloc] init];
GDataEntrySpreadsheetList *listEntry = [GDataEntrySpreadsheetList listEntry];
GDataSpreadsheetCustomElement *serialNo = [GDataSpreadsheetCustomElement elementWithName:@"SNo" stringValue:@"1"];
[array addObject:serialNo];
[listEntry setCustomElements:array];    
//then after finding the worksheet
GDataServiceGoogleSpreadsheet *service = [self spreadsheetService];
NSURL *feedURL = [addedWorkSheet listFeedURL];
[service fetchEntryByInsertingEntry:listEntry 
         forFeedURL:feedURL 
             delegate:self 
                  didFinishSelector:@selector(addEntry:finishedWithFeed:error:)];

上面的代码给出如下错误:

The above code gives error like:

error ::-Error Domain = com.google.HTTPStatus Code = 400该操作无法完成.(很抱歉，发生服务器错误.请稍等一下，然后尝试重新加载电子表格.)" UserInfo = 0x5fe2de0 {NSLocalizedFailureReason =(很抱歉，发生服务器错误.请稍等一下，然后尝试重新加载电子表格.)，error =很抱歉，发生服务器错误.请稍等，然后尝试重新加载电子表格.}

error::-Error Domain=com.google.HTTPStatus Code=400 "The operation couldn’t be completed. (We're sorry, a server error occurred. Please wait a bit and try reloading your spreadsheet.)" UserInfo=0x5fe2de0 {NSLocalizedFailureReason=(We're sorry, a server error occurred. Please wait a bit and try reloading your spreadsheet.), error=We're sorry, a server error occurred. Please wait a bit and try reloading your spreadsheet.}

请帮助我解决此错误.

谢谢.

推荐答案

如果您要插入的GDataEntrySpreadsheetList不包含与工作表相关的GDataSpreadsheetCustomElements，则可能会产生非常误导性的错误.

This very misleading error can occur if the GDataEntrySpreadsheetList you're trying to insert contains no GDataSpreadsheetCustomElements that are relevant to the worksheet.

创建GDataSpreadsheetCustomElement时，用于名称"的字符串必须与您感兴趣的列在电子表格的第一行中的值匹配，除了必须将其转换为所有小写字母并删除所有空格.

When creating a GDataSpreadsheetCustomElement, the string you use for "name" must match the value in the first row of the spreadsheet for the column you're interested in, EXCEPT that it must be converted to all lower-case and have all spaces removed.

尝试将elementWithName:@"SNo"替换为elementWithName:@"sno"

Try replacing elementWithName:@"SNo" with elementWithName:@"sno"

这篇关于在电子表格中添加行(基于列表的供稿)，但行不通的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！