private void button2_Click(object sender, EventArgs e) { var cols = 10; var rows = 2; var objs = m_sheet.GetValues(rows, cols); for (var x = 1; x <= rows; x++) { for (var y = 1; y <= cols; y++) { objs[x, y] = x.ToString() + "|" + y.ToString(); } } m_sheet.SetValues(objs); }
public void SetSheet(string name) { m_sheetCtr = m_book.GetSheet(name); m_values = m_sheetCtr.GetValues(); }