private void refreshButton_Click(object sender, EventArgs e) { try { Worksheet ws = Globals.ThisAddIn.Application.ActiveWorkbook.ActiveSheet; var columnCount = ws.UsedRange.Columns.Count; var rowCount = ws.UsedRange.Rows.Count; var lists = DataTableExt.RangeToLists(ws.UsedRange, columnCount); Account.ColumnIndexMapper = new Dictionary <string, int>(); for (int i = 0; i < lists[0].Count; i++) { Account.ColumnIndexMapper.Add(lists[0][i], i); } for (var i = 1; i < lists.Count; i++) { var login = lists[i][Account.ColumnIndexMapper["login"]]; if (login.ToLower() == "y") { ws.Cells[i + 1, Account.ColumnIndexMapper["login"] + 1].Value = "r"; } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void LoadSetting() { Worksheet ws = Globals.ThisAddIn.Application.ActiveWorkbook.Sheets["setting"]; var columnCount = ws.UsedRange.Columns.Count; var rowCount = ws.UsedRange.Rows.Count; var lists = DataTableExt.RangeToLists(ws.UsedRange, columnCount); ExePath = lists[0][1]; ArgsPath = lists[1][1]; TaskPath = lists[2][1]; PayeePath = lists[3][1]; StatusPath = lists[4][1]; //MessageBox.Show(String.Join(",", lists[0])); }
private List <Account> LoadAccounts() { try { Worksheet ws = Globals.ThisAddIn.Application.ActiveWorkbook.ActiveSheet; var columnCount = ws.UsedRange.Columns.Count; var rowCount = ws.UsedRange.Rows.Count; var lists = DataTableExt.RangeToLists(ws.UsedRange, columnCount); Account.ColumnIndexMapper = new Dictionary <string, int>(); for (int i = 0; i < lists[0].Count; i++) { Account.ColumnIndexMapper.Add(lists[0][i], i); } var accounts = new List <Account>(); for (var i = 1; i < lists.Count; i++) { var account = new Account { email = lists[i][Account.ColumnIndexMapper["email"]], phone = lists[i][Account.ColumnIndexMapper["phone"]], password = lists[i][Account.ColumnIndexMapper["password"]], mode = lists[i][Account.ColumnIndexMapper["mode"]], pages = lists[i][Account.ColumnIndexMapper["pages"]], category = lists[i][Account.ColumnIndexMapper["category"]], login = lists[i][Account.ColumnIndexMapper["login"]], //StatusFilePath = textBox3.Text, discountRate = Double.Parse(lists[i][Account.ColumnIndexMapper["discount rate"]]), RowIndex = i }; accounts.Add(account); } return(accounts); } catch (System.Runtime.InteropServices.COMException) { MessageBox.Show("无权限"); } return(null); }