alignment string format in c#

Question

Hi All, Actually my problem is i have these skill set( Android(0 Months), Java(0 Months), IOS(0 Months), C++(0 Months)) in grid it is showing single line. now i am downloading this grid in Excel. after that i am not getting these skills in single line . i am getting one by one line like Android(0 Months) Java(0 Months) IOS(0 Months) C++(0 Months) please help me . how to display in single line

Raja T · Answer

Hi padmapriya, Please check your code. I am not sure where your mistake. share your code fully what you tried.. (Please confirm are you using windowsform/WebApp) http://www.aspdotnet-suresh.com/2014/11/create-and-download-excel-file-in-aspnet-csharp.html

padmapriya patruni · Answer

byte[] fileBytes = System.IO.File.ReadAllLines(path); this one is showing error cannot implicitly convert type string[] to byte[]

Raja T · Answer

Hi,Try like.. I think missing one more method File(parameters) return File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, fileName); Please share method and also check out below code public FileResult ExcelForNotallocatedemployeeDetails() { change bellow line byte[] fileBytes = System.IO.File.ReadAllBytes(path); to byte[] fileBytes = System.IO.File.ReadAllLines(path); var fileName = "NotallocatedEmployeeDetails.xlsx"; return File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, fileName); }

padmapriya patruni · Answer

hi raja i am sharing my code public FileResult ExcelForNotallocatedemployeeDetails() { var path = repositoryObject.ExcelForNotallocatedemployeeDetails(); System.Web.HttpResponse response = System.Web.HttpContext.Current.Response; response.ClearContent(); response.Clear(); byte[] fileBytes = System.IO.File.ReadAllBytes(path); var fileName = "NotallocatedEmployeeDetails.xlsx"; return File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, fileName); } this is for excelfornotallocatedeemloyeedetails public string ExcelForNotallocatedemployeeDetails() { try { string path = string.Empty; string title = "Not allocated Employee Details"; DownloadExcelRepository repository = new DownloadExcelRepository(); var report = rmsServiceClient.GetNotallocatedemployeeDetails().ToList(); if (report != null) { NameValueCollection collection = new NameValueCollection(); int slNo = 0; for (int i = 0; i { DateTime CurrentDate = DateTime.Now; DateTime cd = DateTime.Now; DateTime dateOfJoin = (DateTime)report[i].DateOfJoin; TimeSpan ts = CurrentDate - dateOfJoin; double months = Math.Round(ts.Days / (365.25 / 12)); slNo = slNo + 1; collection.Add("Sl No", Convert.ToString(slNo)); collection.Add("Employee No", report[i].EmployeeId); collection.Add("Employee Name", report[i].EmployeeName); collection.Add("Role", report[i].Role); collection.Add("Bench From", @String.Format("{0:MMM d yyyy}", report[i].BenchFrom)); collection.Add("Base Location", report[i].BaseLocation); collection.Add("Total Experience(In Months)", Convert.ToString(report[i].TotalExperience)); collection.Add("Exp in Rapid Value(In Months)", months.ToString()); collection.Add("Reporting Manager", report[i].ReportingManager); collection.Add("Skills",report[i].Skills); //collection.Add("Skills", string.Join(",", report[i].Skills)); collection.Add("Next Allocated Project", report[i].NextAllocatedProject); collection.Add("Next Allocation From", @String.Format("{0:MMM d yyyy}", report[i].NextAllocationFrom)); collection.Add("Next Project PM", report[i].NextProjectPM); } path = repository.DownloadExcel(collection, title); } return path; } catch (Exception ex) { throw new Exception(ex.Message); } } this is for download excel public string DownloadExcel(NameValueCollection collection,string title) { String path = string.Empty; try { path = AppDomain.CurrentDomain.BaseDirectory + "ExcelTemplate\" + "ExcelTemplate.xlsx"; FileInfo templateFile = new FileInfo(path); string SendExcellFiles = AppDomain.CurrentDomain.BaseDirectory + "ExcelTemplate\SendExcellFiles\"; if (!System.IO.Directory.Exists(SendExcellFiles)) { System.IO.Directory.CreateDirectory(SendExcellFiles); } //string newFilePath = SendExcellFiles + Guid.NewGuid() + ".xlsx"; string newFilePath = SendExcellFiles + title + ".xlsx"; FileInfo newFile = new FileInfo(newFilePath); if (newFile.Exists) { newFile.Delete(); newFile = new FileInfo(newFilePath); } using (ExcelPackage package = new ExcelPackage(newFile, templateFile)) { ExcelWorksheet worksheet = package.Workbook.Worksheets[1]; worksheet.Cells["A4"].Value = title; worksheet.Cells["C6"].Value = DateTime.UtcNow; int rowvalue = 10; int headerCount = collection.AllKeys.Distinct().Count(); int i = 1; foreach (string key in collection.AllKeys.Distinct()) { worksheet.Cells[rowvalue, i].Value = key; i++; } i = 1; foreach (string key in collection.AllKeys) { var Exelrowvalue = rowvalue + 1; var keyvalue = collection[key].Split(','); foreach (var item in keyvalue) { worksheet.Cells[Exelrowvalue, i].Value = item; Exelrowvalue++; } i++; } package.Save(); } return newFilePath; } catch (Exception ex) { _logger.LogError(Log4NetLogger.Category.Exception, "DownloadExcel Failed.. " + ex.Message); return path; } }

Raja T · Answer

Hi, Please share your code fully... How to Create and Download Excel File in Asp.net C# checkout below link http://www.aspdotnet-suresh.com/2014/11/create-and-download-excel-file-in-aspnet-csharp.html

padmapriya patruni · Answer

hi raja, i am using normal table not gridview. this is my code . in my code i have skill set please help me how to apply that one. var report = rmsServiceClient.GetNotallocatedemployeeDetails().ToList(); if (report != null) { NameValueCollection collection = new NameValueCollection(); for (int i = 0; i { collection.Add("Skills",report[i].Skills); } path = repository.DownloadExcel(collection, title); } return path;

Raja T · Answer

Hi PadmaPriya, private void ExportGridToExcel() { Response.Clear(); Response.Buffer = true; Response.ClearContent(); Response.ClearHeaders(); Response.Charset = ""; string FileName ="Vithal"+DateTime.Now+".xls"; StringWriter strwritter = new StringWriter(); HtmlTextWriter htmltextwrtter = new HtmlTextWriter(strwritter); Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType ="application/vnd.ms-excel"; Response.AddHeader("Content-Disposition","attachment;filename=" + FileName); GridView1.GridLines = GridLines.Both; GridView1.HeaderStyle.Font.Bold = true; GridView1.RenderControl(htmltextwrtter); Response.Write(strwritter.ToString()); //Please check this line in your code Response.Write() or Response.WriteLine () Response.End(); } more details checkout http://www.c-sharpcorner.com/UploadFile/0c1bb2/export-gridview-to-excel/ http://www.aspsnippets.com/Articles/Export-GridView-to-Excel-in-ASPNet-with-Formatting-using-C-and-VBNet.aspx

alignment string format in c#

Answers (7)