Data table to excel In Vb.net

Help
1

Hi all, am trying to send the data from to excel using vb.net, here is my code.

My issue is not able to see any data in excel, please help me in solving it!.

8130-3_RK_2.pdf (32.5 KB) (this is the pdf I wanted to convert into excel)

Main.xaml (14.8 KB)

image
image1366×768 72.7 KB
-Empty excel.

Thanks in advance!

2

Hi,

You can use a tool to convert pdf to excel file.
I prefer the easiest ways for solving any problems. And when I need to convert PDF file into Excel format I always use a tool on https://www.altoconvertpdftoexcel.com/

3

Hi @sushmithaelluru,

There are a couple of ways to convert pdf into excel file.

  • If have a licensed PDF Acrobat DC Pro, you can directly convert your pdfs into excel file.
  • You can use .net DLLs like PDF Focus .net or pdf sharp
  • If you are good at string manipulation then convert your pdf into text using read pdf text activity > use string manipulation > store into excel.

Hope, It will help you. Good Luck!!

4

hello @vikaskulhari

how the below one is obtained…??

If you are good at string manipulation then convert your pdf into text using read pdf text activity > use string manipulation > store into excel.

I have extracted the PDF tabular data into string and written in excel …the whole data is present in single column how to manipulate it??

5

@Janga_Shiva_Raj , you need to use string manipulation (split / substring) or regex to get the desired data.

#HappyRobotics

6

Can u Please give an example xaml File so i could understand easily.
@vikaskulhari

7

@Janga_Shiva_Raj,

  1. Convert String into an array using Environment.NewLine
  2. Loop through array
  3. You split / substring commands or regex pattern to get the desired value

#HappyRobotics