public void ExportBudgetForPrimavera_GetDrawingLogMainByProjList(string saveLoc, string xml, int sortCode, int drwgSpec) { SqlDataReader dr; C1XLBook book = new C1XLBook(); XLSheet sheet = book.Sheets[0]; int indx; decimal tmpRate; // must be output with the following columns // code,blank,description,quantity,uom,hours,rate,cost // dr = CBBudgetLine.GetExportListByBudget(budgetID); dr = CBDrawingLog.GetExportListForDrawingLog_Proj(xml, sortCode, drwgSpec); indx = 0; tmpRate = 0; while (dr.Read()) { sheet[indx, 3].Value = dr["DrawingID"].ToString(); // code sheet[indx, 4].Value = ""; // blank sheet[indx, 5].Value = dr["Department"]; // description sheet[indx, 6].Value = dr["Project"].ToString(); // quantity sheet[indx, 7].Value = dr["ProjectNumber"]; // uom sheet[indx, 8].Value = dr["Title1"].ToString(); // hours sheet[indx, 9].Value = dr["RevisionNumber"].ToString(); sheet[indx, 10].Value = dr["IssueDate"].ToString(); // rate sheet[indx, 11].Value = dr["IssuedFor"].ToString(); // cost sheet[indx, 12].Value = dr["TransNo"].ToString(); indx++; } dr.Close(); book.Save(saveLoc); }