private void SaveData(ref Excel.Worksheet sheet) { int skipCount = 0; int row; MakeHeader(ref sheet); for (int i = 1; i <= ItemsCount(); i++) { BalanceItem balanceItem = GetItem(i - 1); if ((balanceItem.Count == 0) || (balanceItem.Rest == 0)) { skipCount++; continue; } row = i + 1 - skipCount; sheet.Cells[row, Helper.A_FIELD].NumberFormat = "@"; sheet.Cells[row, Helper.A_FIELD] = balanceItem.Bill; sheet.Cells[row, Helper.B_FIELD] = balanceItem.Name; sheet.Cells[row, Helper.C_FIELD] = balanceItem.Rest; sheet.Cells[row, Helper.D_FIELD] = balanceItem.Count; sheet.Cells[row, Helper.E_FIELD] = balanceItem.Description; sheet.Cells[row, Helper.F_FIELD] = balanceItem.Document; sheet.Cells[row, Helper.G_FIELD] = BalanceItem.GetStatus(balanceItem); sheet.Cells[row, Helper.G_FIELD].Interior.Color = BalanceItem.GetStatusColor(balanceItem); sheet.Cells[row, Helper.H_FIELD] = balanceItem.Comment; } sheet.Columns[Helper.A_FIELD + ":" + Helper.H_FIELD].AutoFit(); }
private bool LoadFromXLS() { try { Excel.Worksheet objWorksheet; objWorksheet = GetActiveSheet(application, fileName); int row = FindRow(objWorksheet); if (row == -1) { return(false); } int iBill = FindField(Helper.BILL, row, objWorksheet); if (iBill == -1) { return(false); } int iName = FindField(Helper.NAME, row, objWorksheet); if (iName == -1) { return(false); } int iCount = FindField(Helper.COUNT + " " + Helper.PER_END, row, objWorksheet); if (iCount == -1) { return(false); } int iDesc = FindField(Helper.DESC, row, objWorksheet); if (iDesc == -1) { return(false); } int iRest = FindField(Helper.REST + " " + Helper.PER_END, row, objWorksheet); if (iRest == -1) { return(false); } int i = 0; while (i < Helper.TRY_COUNT) { row++; BalanceItem BI = new BalanceItem { Bill = objWorksheet.Cells[row, iBill].Text.ToString() }; if (BI.Bill.Equals("")) { i++; } else { BI.Description = objWorksheet.Cells[row, iDesc].Text.ToString(); if (BI.Description.Equals("")) { i++; continue; } BI.Name = objWorksheet.Cells[row, iName].Text.ToString(); if (BI.Name.Equals("")) { i++; continue; } try { BI.Count = int.Parse(objWorksheet.Cells[row, iCount].Text.ToString()); } catch (FormatException) { i++; continue; } try { BI.Rest = double.Parse(objWorksheet.Cells[row, iRest].Text.ToString()); } catch (FormatException) { i++; continue; } items.Add(BI); i = 1; } } if (items.Count > 0) { return(true); } else { return(false); } } finally { application.Workbooks.Close(); } }