//======================================================================
// spread sheet process
//======================================================================
public IEnumerator DoProcess(GoogleSpreadSheetWebRequest request)
{
if (MultiSheetConvertMode)
{
var list = new SpreadSheetAPIClass[EndSheetIndex - StartSheetIndex + 1];
for (int i = StartSheetIndex; i <= EndSheetIndex; i++)
{
var requestCo = request.GetSheetsAPI(CellRange.Replace("#NUM#", i.ToString()));
while (requestCo.MoveNext())
{
yield return(requestCo.Current);
}
var res = ( string )requestCo.Current;
list[i - 1] = new SpreadSheetAPIClass(res, SheetName);
}
Receive(list);
}
else
{
var requestCo = request.GetSheetsAPI(CellRange);
while (requestCo.MoveNext())
{
yield return(requestCo.Current);
}
var res = ( string )requestCo.Current;
var apiData = new SpreadSheetAPIClass(res, SheetName);
Receive(apiData);
}
}
public void Receive(SpreadSheetAPIClass data)
{
try {
if (data != null)
{
Convert(data);
}
}
catch (Exception ex) {
Debug.LogError("GoogleSpreadSheetConverter Error :" + ex);
}
}
protected override void Convert(SpreadSheetAPIClass data)
{
StringBuilder sb = new StringBuilder();
for (int i = 0; i < data.RowCount; i++)
{
for (int j = 0; j < data.ColCount; j++)
{
sb.Append(data.Data[i][j]);
if (j + 1 < data.ColCount)
{
sb.Append(",");
}
}
sb.Append("\n");
}
OnFinish(sb.ToString());
}
protected override void Convert(SpreadSheetAPIClass data)
{
StringBuilder sb = new StringBuilder();
for (int i = 0; i < data.RowCount; i++)
{
for (int j = 0; j < data.ColCount; j++)
{
sb.Append(data.Data[i][j]);
if (j + 1 < data.ColCount)
{
sb.Append(",");
}
}
sb.Append("\n");
}
// You can save your data with this method.
Save(sb.ToString());
}
//======================================================================
// abstract
//======================================================================
protected abstract void Convert(SpreadSheetAPIClass data);
