ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: TeeJT on June 23, 2017, 08:20:15 am

Title: Issue with export as Excel
Post by: TeeJT on June 23, 2017, 08:20:15 am

When I use the local export at https://paramquery.com/pro/demos/export_local
to export grid as xlsx, I cannot add a worksheet in the exported Excel file - it give me this error: "That command cannot be used on multiple selections"
I guess this has to do with the settings of the excel file. My user needs to insert worksheets, etc.

This same error exists in server export at https://paramquery.com/pro/demos/export

Title: Re: Issue with export as Excel
Post by: paramvir on June 23, 2017, 11:59:38 am

That is a known issue.

You would get the fix or patch for this by Monday.

Title: Re: Issue with export as Excel
Post by: TeeJT on June 23, 2017, 01:14:09 pm

I have checked this thoroughly and it looks like you need to use the new format with these files inside with the new folder convention:
1. /xl/workbook.xml
2. /xl/worksheets/sheet1.xml
3. /xl/theme/theme1.xml
4. /xl/styles.xml
5. /xl/sharedStrings.xml
6. /docProps/core.xml
7. /docProps/app.xml

I substituted the sheet1.xml the program created worksheet.xml and modified the sharedStrings.xml and it works.
I noticed for the worksheet - you used inlineStr format so I created an empty sharedStrings.xml file:

<?xml version="1.0" encoding="UTF-8" standalone="true"?>
<sst uniqueCount="0" count="0" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"/>

Title: Re: Issue with export as Excel
Post by: paramvir on June 26, 2017, 10:38:57 am

"That command cannot be used on multiple selections" issue is fixed in v3.4.1

Title: Re: Issue with export as Excel
Post by: TeeJT on July 04, 2017, 02:36:48 pm

Thank you very much for resolving the problem.