Product Ideas

Share your suggestions and ideas. Vote on ideas you find valuable.

Do you want to play a crucial role in shaping Jet Global products?

Have Jet Reports ignore an Excel Sheet

We need a way to have Jet Reports completely ignoring a Sheet in Excel?

We need to have data in column A and row 1 in a special format in order to be able to import data into Navision with RapidStart. Jet Report breaks this format when a new column A and row 1 is inserted. removing the new column and row is not an option since the Excel-sheet has already been "broken"

  • Guest
  • Apr 10 2019
  • Under Consideration
Designing & Running Reports
  • Attach files
  • Brendan Ryan commented
    08 Aug 03:07

    First thought is if the keyword +Exclude was in cell A1 to tell Jet to ignore a sheet, but you need cell A1 empty. Sounds like there needs to be a list (array) of sheets in the Options page telling Jet to Ignore certain sheets.

    It could be referenced either by the sheet name (RapidUpload for example), or the underlying codename, (Sheet11 for example).

    So on the Options sheet, A10: Exclude, and B10: RapidUpload|AR Report|AP Report|Sheet 2... etc

    Attachments Open full size

Related ideas