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

HiTry 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(Skillsreport[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 collectionstring 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(Skillsreport[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-Dispositionattachment;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