Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
WCrihfield
in reply to: WCrihfield

After messing around with this scenario a bit more, I have some updates.

  • I went into the options of my Excel application and set the default number of sheets to include to 3, then retested the rule.  That theory didn't work.  Same results as before...the resulting Excel file still just contained just the one tab/sheet, and it was still the second set of data.
  • I then got thinking about the 'Template' option available in that export method, and maybe creating more tabs/sheets in it (originally had just one).  I found out that the 'Template' file you specify in the oOption can't be an actual template (.xltx) file, it must be a regular excel file (.xlsx).  So I created a new empty regular Excel file, named it "Excel Template", stored in in C:\Temp\, just to have something to work with, for testing.  Then made sure it had 3 tabs, just to be sure.  IT WORKED!  The resulting Excel file had 6 tabs/sheets (two of which were the correct results).  So, figuring the extra tabs/sheets were not necessary, I deleted 2 of the tabs (leaving just 1) in the template file, then retested.  Now the results look normal or as expected, at least in my tests.  Doesn't seem like specifying a template would have this effect, but apparently it is the KEY in this situation.

Wesley Crihfield

EESignature

(Not an Autodesk Employee)