This code does work, the worksheet is set to Data worksheet, so when the code is run in there the code runs properly. This started breaking after I added file selection. The original code would create a new worksheet each time. 'OLEDB Provider=.1 Data Source=$Workbook$ Location= Extended Properties=''''' _ Dim my_file As StringĪ Name:='', Formula:= _

I tried setting the worksheet, but it seems to be ineffectual. We begin this adventure by starting Excel and creating a new, blank workbook. The data shows up in my query list but I still get this error. Open the PDF file, click on the Select button, select the content with the help of the. Let us begin with importing the following: import pandas as pd import tabula import xlsxwriter. The only caveat is, the pdf file must be machine-generated. The code works without using the button, but when I use the command button to get the pdf file instead of hardcoding the pdf file path, it gets this error. You may find it simple to copy the PDF table to the Excel spreadsheet. Today, we’ll tackle the task of extracting tabular data from a PDF and exporting it to Excel. I'm trying to import data from PDF to Excel.

Import pdf to excel