/// <summary>
/// カラム数が変わっていたら表を拡張してカラム名を更新
/// </summary>
/// <param name="wsEntry"></param>
/// <param name="columns"></param>
/// <returns></returns>
protected WorksheetEntry CheckColumns(WorksheetEntry wsEntry, string[] columns)
{
if (columns.Length > wsEntry.Cols)
{
wsEntry.Cols = (uint)columns.Length;
WorksheetEntry newEntry = (WorksheetEntry)wsEntry.Update();
/*
* http://stackoverflow.com/questions/22719170/updating-cell-in-google-spreadsheets-returns-error-missing-resource-version-id
* http://stackoverflow.com/questions/20841411/google-spreadsheets-api-c-sharp-missing-resource-version-id-on-batch-update/23438381
*
* ETag:*をするとか、そもそもBatchよりPublishの方が分かりやすい、とか。
*/
CellFeed cellFeed = wsEntry.QueryCellFeed();
uint col = 1;
foreach (var it in columns)
{
CellEntry batchEntry = cellFeed[1, col++];
batchEntry.InputValue = it;
batchEntry.Etag = "*";
}
cellFeed.Publish();
return(newEntry);
}
return(wsEntry);
}
public void InsertWorksheetTest()
{
Tracing.TraceMsg("Entering InsertWorksheetTest");
SpreadsheetQuery query = new SpreadsheetQuery();
SpreadsheetsService service = new SpreadsheetsService(this.ApplicationName);
if (this.userName != null)
{
service.Credentials = new GDataCredentials(this.userName, this.passWord);
}
service.RequestFactory = this.factory;
SpreadsheetFeed feed = service.Query(query);
Assert.IsTrue(feed != null, "Need to have a spreadsheet feed");
Assert.IsTrue(feed.Entries != null && feed.Entries.Count > 0, "Need to have one spreadsheet in there");
SpreadsheetEntry entry = feed.Entries[0] as SpreadsheetEntry;
string wUri = entry.WorksheetsLink;
Assert.IsTrue(wUri != null, "Need to have a worksheet feed in the spreadsheet entry");
WorksheetFeed sheets = entry.Worksheets;
// kill all but the default before we start
foreach (WorksheetEntry w in sheets.Entries)
{
if (w.Title.Text != "DefaultSheet")
{
w.Delete();
}
}
WorksheetEntry defEntry = sheets.Entries[0] as WorksheetEntry;
Assert.IsTrue(defEntry != null, "There should be one default entry in this account/sheet");
Assert.IsTrue(defEntry.Title.Text == "DefaultSheet", "it should be the default sheet");
CellFeed defCells = defEntry.QueryCellFeed();
Assert.IsTrue(defCells != null, "There should be a cell feed for the worksheet");
CellEntry header = null;
foreach (CellEntry cell in defCells.Entries)
{
if (cell.Title.Text == "A1")
{
cell.Cell.InputValue = string.Empty;
cell.Update();
header = cell;
}
}
if (header != null)
{
header.InputValue = "HeaderA";
header.Update();
}
WorksheetEntry newEntry = sheets.Insert(new WorksheetEntry(10, 20, "New Worksheet"));
Assert.IsTrue(newEntry.ColCount.Count == 20, "Column count should be equal 20");
Assert.IsTrue(newEntry.RowCount.Count == 10, "Row count should be equal 10");
Assert.IsTrue(newEntry.Title.Text == "New Worksheet", "Titles should be identical");
CellFeed cells = newEntry.QueryCellFeed(ReturnEmptyCells.yes);
Assert.IsTrue(cells != null, "There should be a cell feed for the new worksheet");
Assert.IsTrue(cells.Entries.Count == 200, "There should be 200 cells");
for (uint row = 1; row <= 10; row++)
{
for (uint col = 1; col <= 20; col++)
{
cells[row, col].InputValue = "R" + row + "C" + col;
}
}
cells.Publish();
// try to update just one cell
cells[1, 1].InputValue = string.Empty;
cells[1, 1].Update();
for (uint row = 1; row <= 10; row++)
{
for (uint col = 1; col <= 20; col++)
{
cells[row, col].InputValue = string.Empty;
}
}
cells.Publish();
// cleanup the new worksheet at the end
newEntry.Delete();
}