Export Aspx To Pdf In Asp.Net

ASP. NET is an opensource serverside web application framework designed for web development to produce dynamic web pages. It was developed by Microsoft to allow. UploadFile/fa9d0d/forms-authentication-in-Asp-Net/Images/login%20page.png' alt='Export Aspx To Pdf In Asp.Net' title='Export Aspx To Pdf In Asp.Net' />How can we export datatable to PDF using i. Text. Sharp Each month, over 5. Stack Overflow to learn, share their knowledge, and build their careers. Join the worlds largest developer community. RadTreeList examples will guide you how to combine treeview and grid in a hybrid control to represent data in a treeviewlike style and multiple columns. In this article we will learn how to export a Gridview to Access. Explains how to use Crystal Reports in ASP. NET Web aplication. Here Mudassar Ahmed Khan has explained how to export ASP. Net Web Page with images to PDF using ITextsharp PDF conversion library. Export Aspx To Pdf In Asp.Net' title='Export Aspx To Pdf In Asp.Net' />In this article, I will explain how to export GridView to Word, Excel, PDF and CSV formats. Exporting to Word, Excel and CSV can be easily achieved using ASP. Net. How to export gridview data to PDF using asp. Export gridview data to PDF using asp. Export Grid. View To Word Excel PDF CSV Formats in ASP. Net. In this article, I will explain how to export Grid. View to Word, Excel, PDF and CSV formats. Exporting to Word, Excel and CSV can be easily achieved using ASP. Net without any third party tools, but for exporting Grid. View to PDF I am using i. Text. Sharp which is a free library for exporting html to PDF. UploadFile/a20beb/get-data-from-single-sheet-of-excel-file-in-Asp-Net991/Images/DOCTYPE%20html.jpg' alt='Export Aspx To Pdf In Asp.Net' title='Export Aspx To Pdf In Asp.Net' />To start with I have a Grid. View in which I am showing Customers records from the North. Wind Database. The HTML markup of the Grid. View is as shown belowlt asp Grid. View. IDGrid. View. Auto. Generate. ColumnsfalseFont NamesArial    Font Size1. Alternating. Row. Style Back. ColorC2. D6. 9B      Header. Style Back. ColorgreenAllow. Pagingtrue       On. Page. Index. ChangingOn. Paging   lt Columns    lt asp Bound. Field. Item. Style Width1. Data. FieldCustomer. ID    Header. TextCustomer. ID    lt asp Bound. Field. Item. Style Width1. Data. FieldCity    Header. TextCity    lt asp Bound. Field. Item. Style Width1. Data. FieldCountry    Header. TextCountry    lt asp Bound. Field. Item. Style Width1. Data. FieldPostal. Code    Header. TextPostal. Code   lt Columns lt asp Grid. View In the figure below the Grid. View is shown with four buttons. Export To Word. 2. Export To Excel. Export To PDF4. Export To CSVExport to Microsoft Word Format. Cprotectedvoid btn. Export. WordClickobject sender, Event. Args e    Response. Clear    Response. Buffer true    Response. Add. Headercontent disposition,    attachment filenameGrid. View. Export. doc    Response. Charset     Response. Content. Type applicationvnd. String. Writer sw new. String. Writer    Html. Text. Writer hw new. Html. Text. Writersw    Grid. View. 1. Allow. Paging false    Grid. View. 1. Data. Bind     Grid. View. 1. Render. Controlhw    Response. Output. Writesw. To. String    Response. Flush    Response. End VB. Net. Protected. Sub btn. Export. WordClickBy. Val sender As. Object,     By. Val e As Event. Args        Response. Clear        Response. Buffer True        Response. Add. Headercontent disposition,         attachment filenameGrid. View. Export. doc        Response. Charset         Response. Content. Type applicationvnd. Dim sw As. New String. Writer        Dim hw As. New Html. Text. Writersw        Grid. View. 1. Allow. Paging False        Grid. View. 1. Data. Bind        Grid. View. 1. Render. Controlhw        Response. Output. Writesw. To. String        Response. Flush        Response. End    End. Sub. The above function renders the Grid. View contents as Microsoft Word format. You will notice I have disabled paging before exporting, so that all the pages are exported. The Output Exported File. Export to Microsoft Excel Format. For exporting the document to Excel if you do it directly as done in case of word the row background color is applied throughout to all the columns in the Excel Sheet hence in order to avoid it. I have done a workaround below. First I am changing the background color of each row back to white. Then I am applying the background color to each individual cell rather than the whole row. Thus when you export now you will notice that the formatting is applied only to the Grid. View cells and not all. Also I am applying textmode style class to all cells and then adding the style CSS class to the Grid. View before rendering it, this ensures that all the contents of Grid. View are rendered as text. Export. ExcelClickobject sender, Event. Args eResponse. Clear Response. Buffer true Response. Add. Headercontent disposition, attachment filenameGrid. View. Export. xls Response. Charset Response. Content. Type applicationvnd. String. Writer sw new. String. Writer Html. Text. Writer hw new. Html. Text. Writersw Grid. View. 1. Allow. Paging false Grid. View. 1. Data. Bind Change the Header Row back to white color. Grid. View. 1. Header. Row. Style. Addbackground color, FFFFFF Apply style to Individual Cells. Grid. View. 1. Header. Row. Cells0. Style. Addbackground color, green Grid. View. 1. Header. Row. Cells1. Style. Addbackground color, green Grid. View. 1. Header. Row. Cells2. Style. Addbackground color, green Grid. View. 1. Header. Row. Cells3. Style. Addbackground color, green   for int i 0 i lt Grid. View. 1. Rows. Count i     Grid. View. Row row Grid. View. 1. Rowsi    Change Color back to white    row. Back. Color System. Drawing. Color. White    Apply text style to each Row    row. Attributes. Addclass, textmode    Apply style to Individual Cells of Alternating Row    if i 2 0            row. Cells0. Style. Addbackground color, C2. D6. 9B        row. Cells1. Style. Addbackground color, C2. D6. 9B        row. Cells2. Style. Addbackground color, C2. D6. 9B        row. Cells3. Style. Addbackground color, C2. D6. 9B       Grid. View. 1. Render. Controlhw style to format numbers to stringstring style lt style. Response. Writestyle Response. Output. Writesw. To. String Response. Flush Response. End VB. Net. Protected. Sub btn. Export. ExcelClickBy. Val sender As. Object, By. Val e As Event. Args  Response. Clear  Response. Buffer True  Response. Add. Headercontent disposition,   attachment filenameGrid. View. Export. xls  Response. Charset   Response. Content. Type applicationvnd. Dim sw As. New String. Writer  Dim hw As. New Html. Text. Writersw  Grid. View. 1. Allow. Paging False  Grid. View. 1. Data. Bind  Change the Header Row back to white color   Grid. View. 1. Header. Row. Style. Addbackground color, FFFFFF  Apply style to Individual Cells   Grid. View. 1. Header. Row. Cells0. Style. Addbackground color, green  Grid. View. 1. Header. Row. Cells1. Style. Addbackground color, green  Grid. View. 1. Header. Row. Cells2. Style. Addbackground color, green  Grid. Style Xp New Themes'>Style Xp New Themes. View. 1. Header. Row. Cells3. Style. Addbackground color, green  For i As. Integer 0 To Grid. View. 1. Rows. Count 1   Dim row As Grid. View. Row Grid. View. Rowsi   Change Color back to white    row. Back. Color System. Drawing. Color. White   Apply text style to each Row    row. Attributes. Addclass, textmode   Apply style to Individual Cells of Alternating Row    If i Mod 2 lt 0 Then    row. Cells0. Style. Addbackground color, C2. D6. 9B    row. Cells1. Style. Addbackground color, C2. D6. 9B    row. Cells2. Style. Addbackground color, C2. D6. 9B    row. Cells3. Style. Addbackground color, C2. D6. 9B   End. If  Next  Grid. View. 1. Render. Controlhw  style to format numbers to string   Dim style As. String lt style. Response. Writestyle  Response. Output. Writesw. To. String  Response. Flush  Response. EndEnd. Sub. The Output Exported File. Export to Portable Document Format. For exporting the Grid. View to PDF I am using the i. Text. Sharp Library. You will need to Add Reference for the i. Text. Sharp Library in your Website. Then import the following Namespaces. Cusing i. Text. Sharp. Text. Sharp. text. Text. Sharp. text. Text. Sharp. text. VB. Net. Imports i. Text. Sharp. text. Imports i. Text. Sharp. Imports i. Text. Sharp. Imports i. Text. Sharp. By default the i. Ie8 Install Stuck On Checking For Malicious Software.