/// <summary>
/// 返回指定單元格的值
/// </summary>
/// <param name="cellName">單元格位置</param>
/// <returns>單元格的值</returns>
public string GetRangeText(string cellName)
{
CellRange cell = Sheet.Range[cellName];
if (cell.HasFormula)
{
Object value = cell.FormulaValue;
cell.Clear(ExcelClearOptions.ClearContent);
cell.Value2 = value;
}
return(Sheet.Range[cellName].Value);
}
private void FillOrderDetails(C1FlexGrid grid)
{
Helper.FillAddress(label_orderNumberDetail, label_orderAddressDetail, c1FlexGrid_ListOfOrders.Rows[c1FlexGrid_ListOfOrders.RowSel], _countries);
_orderID = grid.GetData(c1FlexGrid_ListOfOrders.RowSel, "increment_id").ToString();
CellRange rng = c1FlexGrid_Items.GetCellRange(1, 0, c1FlexGrid_Items.Rows.Count - 1, c1FlexGrid_Items.Cols.Count - 1);
rng.Clear(ClearFlags.Content);
MagentoSoapAPI.salesOrderEntity orderData = _orderItemArray[_orderID.ToString()];
Helper.FillItems(orderData, c1FlexGrid_Items, _preparationWarehouse);
}
