Web Scraper and Web Macros FAQs

Page History: Using Excel as input to a package.


Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2009/01/02 18:28


  • Make sure to add a column header to the Excel file and that the sheet's name is SHEET1.
  • In your package properties -> Steps tab, click the New... button to create a new task.
  • Click through to the Build a List of Urls step and select the Excel Spreadsheet option.
  • Choose the bottom radio button to connect to an existing spreadsheet.
  • Check the box "The existing file's first row is column headers."
  • Complete the wizard and open up the new task's properties.
  • Go to the File List or Form List tab and change the query:
SELECT F1 FROM SHEET1$
to
SELECT TheColumnHeaderYouChose FROM SHEET1$
PoweredBy
Create a Page | Administration | File Management | Login/Logout | Language Selection | Your Profile |Create Account