Question:
I am converting a PDF to Excel and I want to control whether the output is a single sheet or a sheet per page or a sheet per table.
Answer:
By default, PDF to Excel will convert each table within the PDF into it’s own sheet.
If you wish to include non-table content you’ll want to set Convert.ExcelOutputOptions.SetNonTableContent() to True.
If you want each PDF page to be 1 sheet in the output Excel, you’ll want to set Convert.ExcelOutputOptions.SetPageSingleSheet() to True.
If you want the entire output to be contained in 1 sheet (regardless of the number of pages), you’ll want to set
Convert.ExcelOutputOptions.SetSingleSheet() to True. Important to note that SetPageSingleSheet takes precedence over SetSingleSheet so if you set both to True, then the output will have 1 sheet per page of the input PDF.