The following code snippet for ByteScout PDF Suite works best when you need to quickly convert pdf to csv (merge multiline text to table cell) with pdf extractor sdk in your VB.NET application. IF you want to implement the functionality, just copy and paste this code for VB.NET below into your code editor with your app, compile and run your application. Want to see how it works with your data then code testing will allow the function to be tested and work properly.
Trial version of ByteScout PDF Suite is available for free. Source code samples are included to help you with your VB.NET app.
Imports System Imports System.Collections.Generic Imports System.Text Imports Bytescout.PDFExtractor Imports System.Diagnostics Namespace ConsoleApplication1 Class Program Shared Sub Main(ByVal args As String()) ' Create Bytescout.PDFExtractor.CSVExtractor instance Dim extractor As New CSVExtractor() extractor.RegistrationName = "demo" extractor.RegistrationKey = "demo" ' Load sample PDF document extractor.LoadDocumentFromFile("sample3_multiline.pdf") ' You can change CSV separator symbol (if needed) from "," symbol to another if needed for non-US locales 'extractor.CSVSeparatorSymbol = "," ' For multiline cell join extracted cell text into single line extractor.LineGroupingMode = LineGroupingMode.GroupByRows extractor.Unwrap = True ' Save extracted CSV data to file extractor.SaveCSVToFile("output.csv") ' Cleanup extractor.Dispose() Console.WriteLine() Console.WriteLine("Data has been extracted to 'output.csv' file.") Console.WriteLine() Console.WriteLine("Press any key to continue and open CSV in default CSV viewer (or Excel)...") Console.ReadKey() ' Open result file in default associated application (for demo purposes) Process.Start("output.csv") End Sub End Class End Namespace