Rename Excel Template Worksheets

Campbell Fuller

• March 15, 2022 05:14

Hi

 

Does anyone know of a way to rename the Excel Template Worksheets after generation? Specifically when using the OneWorksheetPerDataRow option? I am producing a Sales per Region by Product Category with each Region being written to it's own worksheet. Ideally I would like to rename the worksheet to the Region Name. 

Basically, if the sheet name is Sheet 1 the template creates Sheet 1(1), Sheet 1 (2), Sheet 1 (3).....

TIA

Campbell

0

• 

  VISUI

  • Logi Info Ninja
  • March 16, 2022 14:37

  I submitted a response, but it is "pending approval" most likely because of a link or word that the forum does not like.  
  
  Unfortunately, I don't think there is a way to do this within Logi, however, you should be able to set up your Excel Template file so that the Worksheet's name is programmatically changed based on a value within a specific cell.

   

  0
• 

  Campbell Fuller

  • March 28, 2022 08:59

  Hi,

  It can be done using a macro but, of course, Logi does not allow the use of Macro enabled templates! The only other option is to write a program that changes the name once generated.

  0
• 

  VISUI

  • Logi Info Ninja
  • March 28, 2022 16:48

  GAH!  It figures.  I wonder what the reason is for that.  Maybe Logi doesn't have the ability to acknowledge any prompts when macros are enabled.

  0

Please sign in to leave a comment.