Using Regular Expressions with The Microsoft. NET Framework. The Microsoft. NET Framework, which you can use with any. NET programming language such as C C sharp. Im using the following code to export selected sheets from Excel 2010 to a single pdf file. ThisWorkbook. SheetsArraySheet1, Sheet2, Sheet3. Select. VB. Net ListBox Control Learn VB. Net Programming in simple and easy steps starting from Environment setup, Basic Syntax, Data Types, Type Conversion, Variables. How to export datagridview to excel using vb. Excel Method. This method is different than many you will see. Others use a loop to write each cell and write the cells with text data type. This method creates an object array from a Data. Table or Data. Grid. View and then writes the array to Excel. This means I can write to Excel without a loop and retain data types. About-ASPX.png' alt='Get Pdf Page Count Vb.Net' title='Get Pdf Page Count Vb.Net' />I extracted this from my library and I think I changed it enough to work with this code only, but more minor tweaking might be necessary. If you get errors just let me know and Ill correct them for you. Normally, I create an instance of my class and call these methods. If you would like to use my library then use this link to download it and if you need help just let me know. Files. aspx IDz. Excel. After copying the code to your solution you will use it like this. In your button code add this and change the names to your controls. Write. Data. GridSheet. To open your file after exporting use this line System. Get Pdf Page Count Vb.Net' title='Get Pdf Page Count Vb.Net' />Diagnostics. Process. StartThe location and filename of your fileIn the Write. Array method youll want to change the line that saves the workbook to where you want to save it. Probably makes sense to add this as a parameter. Save. AsC My. Workbook. Public Function Write. ArraySheet As String, By. Ref Object. Array As Object, As String. Dim xl As Excel. Application New Excel. Application. Dim wb As Excel. Workbook xl. Workbooks. Add. Dim ws As Excel. Worksheet wb. Worksheets. Add. ws. Name Sheet. VB. NET PDF Create PDF from Microsoft Office Word in VB. NET. VB. NET Tutorial for Creating PDF document from MS Office Word in Visual Basic. NET Class. Dim range As Excel. Range ws. RangeA1. ResizeObject. Array. Get. Length0, Object. Array. Get. Length1. Title Keywords Stephens Visual Basic Programming 24Hour Trainer Visual Basic, VB, Visual Basic. NET, VB. NET, programming Stephens Visual Basic Programming 24. Is there any possibility to get the currently viewing pdf file page number in a text box. Which means when i am viewing 4th page of pdf file, my text box should show. Value Object. Array. RangeA1. Resize1, Object. Array. Get. Length1 1. Interior. Color RGB0, 7. Con way Blue. range. Font. Color RGBDrawing. Color. White. R, Drawing. Color. White. G, Drawing. Color. White. B. Font. Bold True. Wrap. Text True. Horizontal. Alignment Excel. Xl. HAlign. xl. HAlign. Center. range. Vertical. Alignment Excel. Xl. VAlign. xl. VAlign. Center. range. Application. Active. Window. Split. Column 0. range. Application. Active. Window. Split. Row 1. Application. Active. Window. Freeze. Panes True. Save. AsC My. Workbook. CLose. xl. Quit. Nothing. Nothing. Nothing. Nothing. Release. Com. Objectxl. Release. Com. Objectwb. Release. Com. Objectws. Release. Com. Objectrange. Return. Catch ex As Exception. Return Write. Array Environment. New. Line Environment. New. Line ex. Message. Public Function Write. Data. GridSheet. Name As String, By. Ref dt As Data. Grid. View As String. Dim ldt. Rows. Count 1, dt. Columns. Count As Object. For c As Integer 0 To dt. Columns. Count 1. Columnsc. Header. Text. Next. For r As Integer 1 To dt. Rows. Count. For c As Integer 0 To dt. Columns. Count 1. Rowsr 1. Cellsc. Next. Next. Dim errors As String Write. ArraySheet. Name, l. If errors lt Then. Return errors. End If. Return. Catch ex As Exception. Return Write. Data. Grid Environment. New. Line Environment. New. Line ex. Message. End Try. End Function. Public Function Write. Data. TableSheet. Name As String, By. Ref dt As Data. Table As String. Dim ldt. Rows. Count 1, dt. Columns. Count As Object. For c As Integer 0 To dt. Columns. Count 1. Columnsc. Column. Name. Next. For r As Integer 1 To dt. Rows. Count. For c As Integer 0 To dt. Columns. Count 1. Rowsr 1. Itemc. Next. Next. Dim errors As String Write. ArraySheet. Name, l. If errors lt Then. Return errors. End If. Return. Catch ex As Exception. Return Write. Data. Table Environment. New. Line Environment. New. Line ex. Message. End Try. End Function. I actually dont use this method in my Database program because its a slow method when you have a lot of rowscolumns. I instead create a CSV from the Data. Grid. View. Writing to Excel with Excel Automation is only useful if you need to format the data and cells otherwise you should use CSV. You can use the code after the image for CSV export. CSV Method. Private Sub Data. Grid. To. CSVBy. Ref dt As Data. Grid. View, Qualifier As String. Dim Temp. Directory As String A temp Directory. System. IO. Directory. Create. DirectoryTemp. Directory. Dim o. Write As System. IO. Stream. Writer. Dim file As String System. IO. Path. Get. Random. File. Name. Write IO. File. Create. TextTemp. Directory file. Dim CSV As String. Builder New String. Builder. Dim i As Integer 1. Dim CSVHeader As String. Builder New String. Builder. For Each c As Data. Grid. View. Column In dt. Columns. If i 1 Then. CSVHeader. AppendQualifier c. Header. Text. To. String Qualifier. Else. CSVHeader. Append, Qualifier c. Header. Text. To. String Qualifier. End If. i 1. CSV. Append. LineCSVHeader. To. String. o. Write. Write. LineCSVHeader. To. String. o. Write. Flush. For r As Integer 0 To dt. Rows. Count 1. Dim CSVLine As String. Builder New String. Builder. Dim s As String. For c As Integer 0 To dt. Columns. Count 1. If c 0 Then. CSVLine. AppendQualifier grid. Results. Rowsr. Cellsc. Value. To. String Qualifier. Qualifier grid. Results. Rowsr. Cellsc. Value. To. String Qualifier. Else. CSVLine. Append, Qualifier grid. Results. Rowsr. Cellsc. Value. To. String Qualifier. Qualifier grid. Results. Rowsr. Cellsc. Value. To. String Qualifier. End If. Next. o. Write. Write. Lines. o. Write. Flush. CSV. Append. LineCSVLine. To. String. CSVLine. Clear. o. Write. WriteCSV. To. String. Write. Close. Write Nothing. System. Diagnostics. Process. StartTemp. Directory file. How To Install Teradata On Vmware Player. ASP. NET,C. NET,VB. NET,JQuery,Java. Script,Gridview. C. net articles and tutorials,csharp dot net,asp. VB. NET Articles,Gridview articles,code examples of asp. AJAX,SQL Server Articles,examples of.