/// <summary>
/// Retrieves and prints a list feed of the specified worksheet.
/// </summary>
/// <param name="service">an authenticated SpreadsheetsService object</param>
/// <param name="entry">the worksheet to retrieve</param>
/// <param name="reverseRows">true if the rows in the worksheet should
/// be reversed when returned from the server</param>
private static void RetrieveListFeed(SpreadsheetsService service, WorksheetEntry entry,
bool reverseRows)
{
AtomLink listFeedLink = entry.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
Console.WriteLine();
Console.WriteLine("This worksheet's list feed URL is:");
Console.WriteLine(listFeedLink.HRef);
ListQuery query = new ListQuery(listFeedLink.HRef.ToString());
if (reverseRows)
{
query.OrderByPosition = true;
query.Reverse = true;
}
ListFeed feed = service.Query(query);
Console.WriteLine();
Console.WriteLine("Worksheet has {0} rows:", feed.Entries.Count);
foreach (ListEntry worksheetRow in feed.Entries)
{
ListEntry.CustomElementCollection elements = worksheetRow.Elements;
foreach (ListEntry.Custom element in elements)
{
Console.Write(element.Value + "\t");
}
Console.WriteLine();
}
}
public GoogleWorksheet(WorksheetEntry worksheet)
{
Service = (SpreadsheetsService)worksheet.Service;
// Fetch the cell feed of the worksheet.
CellQuery cellQuery = new CellQuery(worksheet.CellFeedLink);
CellFeed cellFeed = Service.Query(cellQuery);
this.Columns = cellFeed.RowCount.IntegerValue;
this.Rows = cellFeed.ColCount.IntegerValue;
// Iterate through each cell, printing its value.
foreach (CellEntry cell in cellFeed.Entries)
{
Console.WriteLine(cell.Edited.DateValue);
// Print the cell's address in A1 notation
Console.WriteLine(cell.Title.Text);
// Print the cell's address in R1C1 notation
Console.WriteLine(cell.Id.Uri.Content.Substring(cell.Id.Uri.Content.LastIndexOf("/") + 1));
// Print the cell's formula or text value
Console.WriteLine(cell.InputValue);
// Print the cell's calculated value if the cell's value is numeric
// Prints empty string if cell's value is not numeric
Console.WriteLine(cell.NumericValue);
// Print the cell's displayed value (useful if the cell has a formula)
Console.WriteLine(cell.Value);
Console.ReadLine();
}
}
public bool Process()
{
Debug.WriteLine("start AddMaterialChangeEntry");
WorksheetEntry sheet = GetWorksheet("Materials");
if (sheet == null)
{
_finishCallback(false);
return(false);
}
sheet = CheckColumns(sheet, LogData.MaterialChangeInfo.SpreadsheetColumnTitle());
ListFeed listFeed = _wrapper.Query(sheet);
//ListEntry listRow = new ListEntry();
ListEntry row = (ListEntry)listFeed.CreateFeedEntry();
foreach (var it in _info.KeyValue)
{
row.Add(it);
}
listFeed.Insert(row);
_finishCallback(true);
return(true);
}
/// <summary>
/// Inserts a new row in the specified worksheet.
/// </summary>
/// <param name="service">an authenticated SpreadsheetsService object</param>
/// <param name="entry">the worksheet into which the row will be inserted</param>
/// <returns>the inserted ListEntry object, representing the new row</returns>
private static ListEntry InsertRow(SpreadsheetsService service, WorksheetEntry entry)
{
AtomLink listFeedLink = entry.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
ListQuery query = new ListQuery(listFeedLink.HRef.ToString());
ListFeed feed = service.Query(query);
ListEntry firstRow = feed.Entries[0] as ListEntry;
ListEntry newRow = new ListEntry();
Console.WriteLine();
Console.WriteLine("Inserting a new row...");
foreach (ListEntry.Custom element in firstRow.Elements)
{
Console.Write("Enter the value of column \"{0}\": ", element.LocalName);
String elementValue = Console.ReadLine();
ListEntry.Custom curElement = new ListEntry.Custom();
curElement.LocalName = element.LocalName;
curElement.Value = elementValue;
newRow.Elements.Add(curElement);
}
ListEntry insertedRow = feed.Insert(newRow);
Console.WriteLine("Successfully inserted new row: \"{0}\"",
insertedRow.Content.Content);
return(insertedRow);
}
/// <summary>
/// Updates a single cell in the specified worksheet.
/// </summary>
/// <param name="service">an authenticated SpreadsheetsService object</param>
/// <param name="entry">the worksheet to update</param>
private static void UpdateCell(SpreadsheetsService service, WorksheetEntry entry)
{
AtomLink cellFeedLink = entry.Links.FindService(GDataSpreadsheetsNameTable.CellRel, null);
CellQuery query = new CellQuery(cellFeedLink.HRef.ToString());
Console.WriteLine();
Console.Write("Row of cell to update? ");
string row = Console.ReadLine();
Console.Write("Column of cell to update? ");
string column = Console.ReadLine();
query.MinimumRow = query.MaximumRow = uint.Parse(row);
query.MinimumColumn = query.MaximumColumn = uint.Parse(column);
CellFeed feed = service.Query(query);
CellEntry cell = feed.Entries[0] as CellEntry;
Console.WriteLine();
Console.WriteLine("Current cell value: {0}", cell.Cell.Value);
Console.Write("Enter a new value: ");
string newValue = Console.ReadLine();
cell.Cell.InputValue = newValue;
AtomEntry updatedCell = cell.Update();
Console.WriteLine("Successfully updated cell: {0}", updatedCell.Content.Content);
}
public DictionaryTable Download(string sheetName)
{
var service = new SpreadsheetsService(applicationName);
WorksheetEntry worksheet = GetWorksheetEntres(service).FirstOrDefault(e => e.Title.Text == sheetName) as WorksheetEntry;
if (worksheet == null)
{
return(null);
}
List <DictionaryItem> retval = new List <DictionaryItem>();
// Fetch the cell feed of the worksheet.
CellQuery cellQuery = new CellQuery(worksheet.CellFeedLink);
cellQuery.MaximumColumn = 2;
CellFeed cellFeed = service.Query(cellQuery);
for (int i = 0; i < cellFeed.Entries.Count; i = i + 2)
{
retval.Add(
new DictionaryItem(new string[]
{ ((CellEntry)cellFeed.Entries[i]).Value, ((CellEntry)cellFeed.Entries[i + 1]).Value }));
}
return(new DictionaryTable(sheetName, retval.ToArray()));
}
public Google2uWorksheet(WorksheetEntry in_entry, Service in_service, WorkbookBase in_base)
{
WorksheetEntry = in_entry;
MyWorkbook = in_base;
WorksheetName = WorksheetEntry.Title.Text;
Prefix = "worksheet" + WorksheetName.Replace(' ', '_');
MyService = in_service;
MyCleanupQuery = new CellQuery(in_entry.CellFeedLink);
MyCellQuery = new CellQuery(in_entry.CellFeedLink)
{
ReturnEmpty = ReturnEmptyCells.yes
};
_ComboBoxList = new GUIContent[Convert.ToInt32(SupportedType.Unrecognized)];
var iter = 0;
foreach (var enumval in Enum.GetValues(typeof(SupportedType)))
{
if ((SupportedType)enumval == SupportedType.Unrecognized)
{
break;
}
_ComboBoxList[iter] = new GUIContent(Convert.ToString(enumval));
iter++;
}
}
private string ToGoogleTable()
{
WorksheetFeed wsFeed = TargetTable.Worksheets;
WorksheetEntry worksheet = (WorksheetEntry)wsFeed.Entries[0];
// Define the URL to request the list feed of the worksheet.
AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
// Fetch the list feed of the worksheet.
ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString());
ListFeed listFeed = service.Query(listQuery);
CellQuery cellQuery = new CellQuery(worksheet.CellFeedLink);
CellFeed cellFeed = service.Query(cellQuery);
CellEntry cellEntry = new CellEntry(1, 1, "oid");
cellFeed.Insert(cellEntry);
cellEntry = new CellEntry(1, 2, "value");
cellFeed.Insert(cellEntry);
cellEntry = new CellEntry(1, 3, "type");
cellFeed.Insert(cellEntry);
ProgressBarSetStartParams(progressBar1, ListData[ListData.Count - 1].Count);
tabControlShow(progressBar1);
tabControlShow(label3);
for (int i = 0; i < ListData[ListData.Count - 1].Count; i++)
{
IncrementProgressbar(progressBar1);
IncrementGeneralLabel(string.Format("Выполнено {0}/{1}", i + 1, ListData[ListData.Count - 1].Count));
service.Insert(listFeed, ListData[ListData.Count - 1].GetCustom(i));
}
tabControlShow(progressBar1, false);
tabControlShow(label3, false);
return("Данные записаны");
}
private static WorksheetEntry GetWorkSheetEntry(string sheetId)
{
WorksheetEntry wsEntry = null;
try
{
if (null == sheetsService)
{
sheetsService = GetUserCredential();
}
if (null != sheetsService)
{
WorksheetQuery worksheetquery = new WorksheetQuery("https://spreadsheets.google.com/feeds/worksheets/" + sheetId + "/private/full");
WorksheetFeed wsFeed = sheetsService.Query(worksheetquery);
if (wsFeed.Entries.Count > 0)
{
wsEntry = (WorksheetEntry)wsFeed.Entries[0];
}
if (null != wsEntry)
{
//create headers if missing
bool updatedHeaders = UpdateHeaders(wsEntry);
}
}
}
catch (Exception ex)
{
MessageBox.Show("Failed to get Google Worksheet.\n" + ex.Message, "Get Work Sheet Entry", MessageBoxButton.OK, MessageBoxImage.Warning);
}
return(wsEntry);
}
public bool Process()
{
Debug.WriteLine("start LoadMissionResultEntry");
WorksheetEntry sheet = GetWorksheet("Mission");
if (sheet == null)
{
_finishCallback(false);
return(false);
}
var list = Query(sheet);
lock (((ICollection)_missionResultLog).SyncRoot)
{
foreach (var row in list)
{
var it = new LogData.MissionResultInfo(row);
it.MemberID = _memberId;
it.Number = _missionResultLog.Count + 1;
_missionResultLog.Add(it);
}
}
_finishCallback(true);
return(true);
}
private static void AddNewLocalisation(string key, string text)
{
WorksheetEntry worksheet = GetWorksheet();
uint row = ++worksheet.Rows;
worksheet.Update();
CellQuery cellQuery = new CellQuery(worksheet.CellFeedLink);
cellQuery.MinimumRow = row;
cellQuery.ReturnEmpty = ReturnEmptyCells.yes;
cellQuery.MinimumColumn = 1;
cellQuery.MaximumColumn = 2;
CellFeed cellFeed = ss.Query(cellQuery);
foreach (CellEntry cell in cellFeed.Entries)
{
switch (cell.Column)
{
case 1:
cell.InputValue = key;
break;
case 2:
cell.InputValue = text;
break;
}
cell.Update();
}
}
private Dictionary <string, JobInfo> getGoogleDocsJobs()
{
Dictionary <string, JobInfo> jobs = new Dictionary <string, JobInfo>();
WorksheetEntry ws = this.getDataWorksheet();
AtomLink feedLink = ws.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
ListQuery listQuery = new ListQuery(feedLink.HRef.ToString());
ListFeed feed = this.service.Query(listQuery);
foreach (ListEntry row in feed.Entries)
{
string key = null;
string col1 = null;
string col2 = null;
foreach (ListEntry.Custom element in row.Elements)
{
if (key == null)
{
key = element.Value;
}
else if (col1 == null)
{
col1 = element.Value;
}
else if (col2 == null)
{
col2 = element.Value;
}
}
jobs.Add(key, new JobInfo(key, col1, col2));
}
return(jobs);
}
public bool Process()
{
Debug.WriteLine("start LoadMaterialChangeEntry");
WorksheetEntry sheet = GetWorksheet("Materials");
if (sheet == null)
{
_finishCallback(false);
return(false);
}
sheet = CheckColumns(sheet, LogData.MaterialChangeInfo.SpreadsheetColumnTitle());
var list = Query(sheet);
lock (((ICollection)_materialsChangeLog).SyncRoot)
{
foreach (var row in list)
{
var it = new LogData.MaterialChangeInfo(row);
it.MemberID = _memberId;
it.Number = _materialsChangeLog.Count + 1;
if (_materialsChangeLog.Count > 0)
{
it.PrevItem = _materialsChangeLog.Last();
}
_materialsChangeLog.Add(it);
_postCallback(it);
}
}
_finishCallback(true);
return(true);
}
public void CellQuery(WorksheetEntry worksheet)
{
// Fetch the cell feed of the worksheet.
CellQuery cellQuery = new CellQuery(worksheet.CellFeedLink);
//cellQuery.ModifiedSince = new DateTime(2013, 9, 1);
//cellQuery.StartDate = new DateTime(2013, 9, 18);
//cellQuery.MinPublication = new DateTime(2013, 9, 18);
CellFeed cellFeed = this.Service.Query(cellQuery);
// Iterate through each cell, printing its value.
foreach (CellEntry cell in cellFeed.Entries)
{
Console.WriteLine(cell.Edited.DateValue);
// Print the cell's address in A1 notation
Console.WriteLine(cell.Title.Text);
// Print the cell's address in R1C1 notation
Console.WriteLine(cell.Id.Uri.Content.Substring(cell.Id.Uri.Content.LastIndexOf("/") + 1));
// Print the cell's formula or text value
Console.WriteLine(cell.InputValue);
// Print the cell's calculated value if the cell's value is numeric
// Prints empty string if cell's value is not numeric
Console.WriteLine(cell.NumericValue);
// Print the cell's displayed value (useful if the cell has a formula)
Console.WriteLine(cell.Value);
Console.ReadLine();
}
}
public void ListQuery(WorksheetEntry worksheet)
{
// Define the URL to request the list feed of the worksheet.
AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
// Fetch the list feed of the worksheet.
ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString());
//listQuery.MinPublication = new DateTime(2013, 9, 18);
//listQuery.ModifiedSince = new DateTime(2013, 9, 18);
listQuery.StartDate = new DateTime(2013, 9, 18);
ListFeed listFeed = this.Service.Query(listQuery);
Console.WriteLine("Results {0}", listFeed.Entries.Count);
for (int rowIdx = 0; rowIdx < 10; rowIdx++)
{
// TODO: Choose a row more intelligently based on your app's needs.
ListEntry row = (ListEntry)listFeed.Entries[rowIdx];
// Update the row's data.
foreach (ListEntry.Custom element in row.Elements)
{
Console.WriteLine(element.LocalName + " : " + element.Value);
Console.ReadLine();
}
}
}
static void Main(string[] args)
{
Environment.CurrentDirectory = Environment.CurrentDirectory.Substring(0, Environment.CurrentDirectory.LastIndexOf("osum", StringComparison.Ordinal)) + @"\osum\osum\Localisation\";
ss.setUserCredentials("*****@*****.**", "osumisawsum");
SpreadsheetFeed feed = ss.Query(new SpreadsheetQuery());
SpreadsheetEntry sheet = null;
//get spreadsheet
foreach (var entry in feed.Entries.OfType <SpreadsheetEntry>())
{
if (entry.Title.Text == "osu!stream localisation")
{
sheet = entry;
break;
}
}
if (sheet == null)
{
Console.WriteLine("failed to get spreadsheet");
Console.ReadLine();
}
//get worksheet
AtomLink link = sheet.Links.FindService(GDataSpreadsheetsNameTable.WorksheetRel, null);
WorksheetQuery query = new WorksheetQuery(link.HRef.ToString());
WorksheetFeed wfeed = ss.Query(query);
WorksheetEntry worksheet = wfeed.Entries[0] as WorksheetEntry;
ProcessWorksheet(worksheet);
}
public DictionaryTable Download(string sheetName)
{
SpreadsheetsService service = new SpreadsheetsService(applicationName);
service.setUserCredentials(userName, password);
WorksheetEntry worksheet = this.GetWorksheetEntrees(service).FirstOrDefault(e => e.Title.Text == sheetName);
if (worksheet == null)
{
return(null);
}
CellQuery cellQuery = new CellQuery(worksheet.CellFeedLink);
cellQuery.MaximumColumn = 2;
CellFeed cellFeed = service.Query(cellQuery);
List <DictionaryItem> retval = new List <DictionaryItem>();
for (int i = 0; i < cellFeed.Entries.Count; i = i + 2)
{
retval.Add(
new DictionaryItem(new string[] { ((CellEntry)cellFeed.Entries[i]).Value, ((CellEntry)cellFeed.Entries[i + 1]).Value }));
}
return(new DictionaryTable(sheetName, retval.ToArray()));
}
/// <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 WorksheetEntry GetWorksheetEntry(string name)
{
/*
* var link = entry.Links.FindService(GDataSpreadsheetsNameTable.WorksheetRel, null);
* var wsFeed = (WorksheetFeed) client.SpreadsheetService.Query(new WorksheetQuery(link.HRef.ToString()) {Title = name, Exact = true});
* if (wsFeed.Entries.Count == 0)
* return null;
*
* return (WorksheetEntry)wsFeed.Entries [0];
*/
SpreadsheetEntry spreadsheet = this.entry as SpreadsheetEntry;
WorksheetFeed wsFeed = spreadsheet.Worksheets;
// Iterate through each worksheet in the spreadsheet.
WorksheetEntry worksheetEntry = null;
foreach (WorksheetEntry entry in wsFeed.Entries)
{
// Retrieve worksheet with the given name.
if (entry.Title.Text == name)
{
worksheetEntry = entry;
}
}
return(worksheetEntry);
}
public bool Process()
{
Debug.WriteLine("start AddMissionResultEntry");
WorksheetEntry sheet = GetWorksheet("Mission");
if (sheet == null)
{
_finishCallback(false);
return(false);
}
ListFeed listFeed = _wrapper.Query(sheet);
//ListEntry listRow = new ListEntry();
ListEntry row = (ListEntry)listFeed.CreateFeedEntry();
foreach (var it in _info.KeyValue)
{
row.Add(it);
}
listFeed.Insert(row);
_finishCallback(true);
return(true);
}
private void UpdateListFeed()
{
WorksheetEntry worksheet = (WorksheetEntry)worksheetFeed.Entries[0];
AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString());
listFeed = spreadsheetsService.Query(listQuery);
}
private ListFeed GetWorksheetFeed(WorksheetEntry pWorksheetEntry)
{
AtomLink wListFeedLink = pWorksheetEntry.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
ListQuery wquery = new ListQuery(wListFeedLink.HRef.ToString());
ListFeed w2feed = tService.Query(wquery);
return(w2feed);
}
public ListFeed Query(WorksheetEntry wsEntry)
{
Debug.WriteLine("Try WorksheetQuery");
AtomLink listFeedLink = wsEntry.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString());
return(Service.Query(listQuery));
}
/// <summary>
/// Selects a worksheet.
/// </summary>
/// <param name="entry">The <typeparamref name="Google.GData.Spreadsheets.WorksheetEntry" /> which should be selected.</param>
/// <exception cref="System.ArgumentNullException"><paramref name="entry"/> is null.</exception>
public void SelectWorksheet(WorksheetEntry entry)
{
if (entry == null)
{
throw new ArgumentNullException("entry");
}
this.currentWorksheet = entry;
}
protected TranslationModule FromWorksheet(string project, WorksheetEntry worksheet)
{
// Define the URL to request the list feed of the worksheet.
AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
// Fetch the list feed of the worksheet.
ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString());
ListFeed listFeed = this.Service.Query(listQuery);
Console.WriteLine("Results {0}", listFeed.Entries.Count);
List <string> languages = new List <string>();
var dicts = new Dictionary <string, Dictionary <string, string> >();
var comments = new Dictionary <string, string>();
//language information is in first row
var firstRow = (ListEntry)listFeed.Entries[0];
for (int column = 1; column < firstRow.Elements.Count; column++)
{
var lang = firstRow.Elements[column].LocalName;
languages.Add(lang);
dicts.Add(lang, new Dictionary <string, string>());
}
var tp = new TranslationModule(project, "en", languages.ToArray());
for (int rowIdx = 1; rowIdx < listFeed.Entries.Count; rowIdx++)
{
ListEntry row = (ListEntry)listFeed.Entries[rowIdx];
string comment = null;
string key = row.Elements[0].Value; // first column is the key
// Update the row's data.
for (int column = 1; column < row.Elements.Count; column++)
{
var element = row.Elements[column];
//in list based feeds localname always correponds to first row
if (element.LocalName.ToLower() == "comment")
{
comment = element.Value;
}
else
{
tp.Add(new Segment(element.LocalName, key, element.Value));
}
}
foreach (var seg in tp.ByKey[key])
{
seg.Comment = comment;
}
}
return(tp);
}
public CellFeed GetCellFeed(int sheetNum)
{
WorksheetFeed wsFeed = spreadSheetEntry.Worksheets;
WorksheetEntry worksheet = (WorksheetEntry)wsFeed.Entries[sheetNum];
CellQuery cellQuery = new CellQuery(worksheet.CellFeedLink);
CellFeed cellFeed = service.Query(cellQuery);
return(cellFeed);
}
public WorksheetEntry getDataWorksheet()
{
WorksheetEntry found = searchForSpreadsheet(this.googleAppName);
if (found == null)
{
found = createSpreadSheet(this.googleAppName);
}
return(found);
}
public void getValues(string sheetName, DataSet dataSet)
{
var tableName = sheetName;
if (dataSet.Tables[tableName] == null)
{
tableName = sheetName + "_";
}
if (dataSet.Tables[tableName] == null)
{
throw new ArgumentException("Neither " + sheetName + " nor " + sheetName + "_ tables could be found in the passed dataset!!!");
}
DataColumnCollection columnNames = dataSet.Tables[tableName].Columns;
WorksheetEntry entry = (WorksheetEntry)m_worksheets[sheetName];
if (entry == null)
{
string message = sheetName + " not found in " + m_spreadsheetName;
Trace.WriteLine(message);
throw new ArgumentNullException(message);
}
AtomLink listFeedLink = entry.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
ListQuery query = new ListQuery(listFeedLink.HRef.ToString());
ListFeed feed = m_service.Query(query);
Trace.WriteLine("Found " + feed.Entries.Count + " rows of data in " + sheetName);
if (feed.Entries.Count > 0)
{
ListEntry worksheetRow = (ListEntry)feed.Entries[0];
ListEntry.CustomElementCollection elements = worksheetRow.Elements;
for (int j = 0; j < feed.Entries.Count; ++j)
{
worksheetRow = (ListEntry)feed.Entries[j];
elements = worksheetRow.Elements;
DataRow workRow = dataSet.Tables[tableName].NewRow();
for (int i = 0; i < elements.Count; ++i)
{
string value = "" + elements[i].Value;
Type type = columnNames[i].DataType;
if (type == System.Type.GetType("System.Double") && string.IsNullOrWhiteSpace(value))
{
value = "0";
}
if (type == System.Type.GetType("System.Int32") && string.IsNullOrWhiteSpace(value))
{
value = "0";
}
workRow[columnNames[i].ColumnName] = value;
}
dataSet.Tables[tableName].Rows.Add(workRow);
}
}
return;
}
public ListFeed GetListFeed(int sheetNum)
{
WorksheetFeed wsFeed = spreadSheetEntry.Worksheets;
WorksheetEntry worksheet = (WorksheetEntry)wsFeed.Entries[sheetNum];
AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString());
return(service.Query(listQuery));
}
/// <summary>
/// Get Worksheets in the given <paramref name="spreadsheet"/>.
/// </summary>
/// <param name="spreadsheet">The <typeparamref name="Google.GData.Spreadsheets.SpreadsheetEntry" /> from which the worksheets should be returned.</param>
/// <returns>Returns a <typeparamref name="Google.GData.Spreadsheets.WorksheetEntry" /> array.</returns>
public virtual WorksheetEntry[] GetWorksheets(SpreadsheetEntry spreadsheet)
{
if (spreadsheet == null)
{
spreadsheet = GetSpreadsheets()[0];
}
var result = new WorksheetEntry[spreadsheet.Worksheets.Entries.Count];
spreadsheet.Worksheets.Entries.CopyTo(result, 0);
return(result);
}
public void Init()
{
entry = new WorksheetEntry();
}
