I’m trying to figure out why App/Excel/Append Range is behaving markedly different than System/File/Workbook/Append Range - but I’m coming up empty.
Building on the knowledge from my previous post, where I scraped an HTML table across multiple pages (one page at a time, using the page-by-page method as in the Yearly Report exercise) in the Acme work items system… I have gotten that bulk data set and filtered it down to a data table with only the records I need. Now I want to get those records into Excel. Using the Excel method works fine. Using the Workbook method works fine for the first page of data, but then each additional page that is appended gets an extra blank column preceding the data:
On the left is the Workbook method, on the right is the Excel method. I’m sure I could do fun things with dropping empty columns, but should I have to do that? Any idea what could be causing my data to shift?
Looping through the rows:
Writing the current page’s data table to an xlsx file using the direct and excel methods: