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();
}
}
