public void SendToWorksheet(Excel.Workbook targetBook, Excel.Worksheet targetSheet)
{
Globals.Program.Application.ScreenUpdating = false;
targetSheet.Activate();
// reel entries A5~E5, pay at M5
String col = "A";
int row = 5;
int stopCount = 0;
String cell = col + row.ToString();
String payCell = "N" + row.ToString();
int stopSet = m_freeLinePays[0].StopValues.Count - 1;
bool trim = true;
String val = "";
foreach (PaylineDescription line in m_freeLinePays)
{
if (line.Win <= 0)
continue;
if (line.IsFreegameSet || line.IsModifierSet || line.HasWild)
//continue;
if (line.IsFreegameSet || line.IsModifierSet)
trim = true;
col = "A";
stopCount = 0;
foreach (String stop in line.StopValues[stopSet].Values)
{
cell = col + row.ToString();
if (stopCount == 5)
break;
stopCount++;
if (trim)
val = line.StopValues[stopSet].TrimValue(stop);
else
val = stop;
outputCell(targetSheet, cell, val);
col = incrementColumn(col);
}
payCell = "N" + row.ToString();
outputCell(targetSheet, payCell, line.Win.ToString());
row++;
}
row = 5;
foreach (PaylineDescription line in m_freeLinePays)
{
if (line.Win <= 0)
continue;
if (line.IsFreegameSet || line.IsModifierSet || line.HasWild)
//continue;
if (line.IsFreegameSet || line.IsModifierSet)
trim = true;
col = "H";
stopCount = 0;
foreach (String stop in line.StopValues[stopSet].Values)
{
cell = col + row.ToString();
if (stopCount == 5)
break;
stopCount++;
if (trim)
val = line.StopValues[stopSet].TrimValue(stop);
else
val = stop;
outputCell(targetSheet, cell, val);
col = incrementColumn(col);
}
row++;
}
m_rowCount = row;
Globals.Program.Application.ScreenUpdating = true;
updatePayLinks(targetBook);
}
private void FreezePanes(Excel.Worksheet worksheet)
{
worksheet.Activate();
worksheet.Application.ActiveWindow.SplitColumn = 3;
worksheet.Application.ActiveWindow.FreezePanes = true;
}
/// <summary>
/// Excelシート各種情報取得
/// </summary>
private SheetInfo GetSheetInformation(Excel.Worksheet oSheet)
{
SheetInfo info = null;
Excel.Range oCells = null;
Excel.Worksheet oActiveSheet = null;
Excel.Window oActiveWindow = null;
Debug.Assert(oSheet != null);
try
{
if (oSheet == null)
{
return null;
}
// シートをアクティベートする
oActiveSheet = (Excel.Worksheet)this._app.ActiveSheet;
oSheet.Activate();
oActiveWindow = this._app.ActiveWindow;
oCells = oActiveWindow.ActiveCell;
// シート情報取得および格納
info = new SheetInfo();
{
info.Name = oSheet.Name;
info.Zoom = (double)oActiveWindow.Zoom;
info.Gridlines = oActiveWindow.DisplayGridlines;
info.View = oActiveWindow.View;
info.CellPosition = new Point((int)oCells.Column, (int)oCells.Row);
}
}
finally
{
if (oActiveSheet != null)
{
oActiveSheet.Activate();
Marshal.ReleaseComObject(oActiveSheet);
}
oActiveSheet = null;
if (oActiveWindow != null)
{
Marshal.ReleaseComObject(oActiveWindow);
}
oActiveWindow = null;
if (oCells != null)
{
Marshal.ReleaseComObject(oCells);
}
oCells = null;
}
return info;
}
public static void FreezePanes(Excel.Worksheet worksheet, int splitColumn, int splitRow)
{
worksheet.Activate();
worksheet.Application.ActiveWindow.SplitColumn = splitColumn;
worksheet.Application.ActiveWindow.SplitRow = splitRow;
worksheet.Application.ActiveWindow.FreezePanes = true;
}
private bool checkValue(Excel.Workbook book, Excel.Worksheet sheet, String cell)
{
book.Activate();
if (book.ActiveSheet != sheet)
sheet.Select();
Excel.Range test = sheet.get_Range(cell);
try
{
sheet.Select(test);
}
catch (Exception e)
{
// apparently, an empty cell is not valid for selection.
return true;
}
try
{
if (test.Value2 == "" || test.Value2 == null)
return false;
else
return true;
}
catch (Exception e)
{
return false;
}
}
