Export DataTable with font size and format to Excel using OpenXml in ASP.Net

loraksa....

SOLVED CLOSED ACTIVE ANSWERED
User: loraksa.t
Posted: on Apr 18, 2018 12:03 AM
Forum: Data Controls
Replies: 3
Views: 4251

How to Export Excel font size and format Excel in XLWorkbook asp.net(VB)

Dim dt As New DataTable("Worktime")
		For Each cell As TableCell In gv_data.HeaderRow.Cells
			dt.Columns.Add(cell.Text)
		Next
		For Each row As GridViewRow In gv_data.Rows
			dt.Rows.Add()
			For i As Integer = 0 To row.Cells.Count - 1
				dt.Rows(dt.Rows.Count - 1)(i) = row.Cells(i).Text
			Next
		Next
		Using wb As New XLWorkbook()
			wb.Worksheets.Add(dt)
			
			Response.Clear()
			Response.Buffer = True
			Response.Charset = ""
			Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
			Response.AddHeader("content-disposition", "attachment;filename=ABCD.xlsx")
			Using MyMemoryStream As New MemoryStream()
				wb.SaveAs(MyMemoryStream)
				MyMemoryStream.WriteTo(Response.OutputStream)
				Response.Flush()
				Response.[End]()
			End Using
		End Using

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
User: dharmendr
Replied: on Apr 18, 2018 12:03 AM
Report

Hi loraksa.t,

Refer below link.

loraksa....

0 2

Reply
User: loraksa.t
Replied: on Apr 18, 2018 01:42 AM
Modified: on Apr 18, 2018 02:52 AM
Report

Hi dharmendr ,

row.cell(26) error?

----------------------------------------------------------------------------

Sequence contains no matching element

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.InvalidOperationException: Sequence contains no matching element Source Error:

Line 75: 				Dim columnIndex As Integer = 0
Line 76: 				For Each cell As TableCell In grid.HeaderRow.Cells
Line 77: 					ws.Cell(String.Format("{0}{1}", Char.ConvertFromUtf32(aCode + columnIndex), rowIndex)).Value = cell.Text
Line 78: 					ws.Cell(String.Format("{0}{1}", Char.ConvertFromUtf32(aCode + columnIndex), rowIndex)).Style.Border.OutsideBorder = XLBorderStyleValues.Thin
Line 79: 					columnIndex += 1

dharmend...

0 3

Reply
User: dharmendr
Replied: on Apr 18, 2018 04:49 AM
Report

You can't ask multiple queries within a question. This is against forum rules and necessary to maintain clean forum. It is requested Mark Answer the replies when question is answered and ask a new question as a responsible member to help fellow programmers around the world.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Export DataTable with font size and format to Excel using OpenXml in ASP.Net

Export multiple GridView to multiple Excel sheets with formatting using OpenXml in ASP.Net

Sequence contains no matching element

Company

Explore

Follow us

Contact Us