Author Topic: How to change sheet name when export excel with multiple tabs  (Read 1245 times)

ibizlink

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 8
    • View Profile
How to change sheet name when export excel with multiple tabs
« on: September 26, 2021, 04:49:07 pm »
Hi,

I am trying to implement tabs with pivot and data (example : https://paramquery.com/pro/demos/pivot_tabs)

When I export to excel, I want to set sheetname as tabs but it only states as 'ParamQuery Eval 1'.. 'ParamQuery Eval 2'

sheetName does not work here and please help...
« Last Edit: September 26, 2021, 04:51:50 pm by ibizlink »

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: How to change sheet name when export excel with multiple tabs
« Reply #1 on: September 27, 2021, 08:49:04 am »
It means you are using ParamQuery grid evaluation version of the SDK.

Please download ultimate version of the SDK from your forum account and replace all the evaluation files in your development environment with ultimate version files.

ibizlink

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 8
    • View Profile
Re: How to change sheet name when export excel with multiple tabs
« Reply #2 on: September 28, 2021, 06:18:59 am »
Hi ,

I am using ultimate version of SDK correctly.

what I mean is that if I am using multiple tabs, how can I change sheename for each when I export it.

If I don't use tab and only using single table, sheetName works correctly but not sure how it can be applied to multiple tabs.

Thanks,

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: How to change sheet name when export excel with multiple tabs
« Reply #3 on: September 28, 2021, 09:29:08 am »
name of the tab becomes name of the corresponding sheet when exported to Excel.

In this example: https://paramquery.com/pro/demos/pivot_tabs , names of the tabs are defined in tabModel.tabs array.

API: https://paramquery.com/pro/api#option-tabModel