Saturday, 20 August 2011

How to create csv file in dot Net ?

 string filename = "";
            //----------------- File Name ----------
            string Day = DateTime.Now.Day.ToString();
            string Month = DateTime.Now.ToString("MMM");
            string Year = DateTime.Now.Year.ToString();
            string Hour = DateTime.Now.Hour.ToString();
            string Minute = DateTime.Now.Minute.ToString();
            string Second = DateTime.Now.Second.ToString();
            string strName = Day + "_" + Month + "_" + Year + "__" + Hour + "_" + Minute + "_" + Second + ".xls";
            filename = Server.MapPath("~/XLSFiles/" + strName);
            Session["AttachedFileName"] = filename;
            //--------------------------------------
            try
            {
                string sTableStart = @"<HTML><BODY><TABLE Border=1>";
                string sTableEnd = @"</TABLE></BODY></HTML>";
                StringBuilder sTableData = new StringBuilder();
                //----XLS Column Headings---------
                string sTHead = "<TR>";
                sTHead += @"<TH>S.No</TH>";
                sTHead += @"<TH>Name</TH>";
                sTHead += @"<TH>DOB</TH>";
                sTHead += @"<TH>App.Date</TH>";
                sTHead += @"<TH>Type</TH>";
                sTHead += @"<TH>Status</TH>";
                sTHead += @"</TR>";
                //------------- XLS Row asign ---------
                int SNOCounter = 1;
                string[] outerArray = hiddenIGAppointmentValuePair.Value.Split(':');
                for (int j = 0; j < gridAppointments.Rows.Count; j++)
                {
                    string[] innerArray = outerArray[j].Split(';');
                    if (innerArray[1].ToString() == "1")
                    {
                        sTableData.Append(@"<TR>");
                        sTableData.Append(@"<TD>" + SNOCounter.ToString() + @"</TD>"); // SNo
                        sTableData.Append(@"<TD>" + gridAppointments.Rows[j].Items[3].Text + @"</TD>"); // Name
                        sTableData.Append(@"<TD>" + gridAppointments.Rows[j].Items[4].Text + @"</TD>"); // DOB
                        sTableData.Append(@"<TD>" + gridAppointments.Rows[j].Items[5].Text + @"</TD>"); // AppDate
                        sTableData.Append(@"<TD>" + gridAppointments.Rows[j].Items[6].Text + @"</TD>"); // Type
                        sTableData.Append(@"<TD>" + gridAppointments.Rows[j].Items[7].Text + @"</TD>"); // Status
                        sTableData.Append(@"</TR>");
                        SNOCounter += 1;
                    }
                }
                //-------------------------------------
                string sTable = sTableStart + sTHead + sTableData.ToString() + sTableEnd;
                System.IO.StreamWriter oExcelWriter = System.IO.File.CreateText(filename);
                oExcelWriter.WriteLine(sTable);
                oExcelWriter.Close();
            }
            catch
            {
            }

No comments:

Post a Comment