ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: ibizlink on September 26, 2021, 04:49:07 pm

Title: How to change sheet name when export excel with multiple tabs
Post by: ibizlink 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...

Title: Re: How to change sheet name when export excel with multiple tabs
Post by: paramvir 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.

Title: Re: How to change sheet name when export excel with multiple tabs
Post by: ibizlink 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,

Title: Re: How to change sheet name when export excel with multiple tabs
Post by: paramvir 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