Author Topic: Issue with export as Excel  (Read 2431 times)

TeeJT

  • Pro Ultimate
  • Jr. Member
  • *
  • Posts: 88
    • View Profile
Issue with export as Excel
« 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

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6298
    • View Profile
Re: Issue with export as Excel
« Reply #1 on: June 23, 2017, 11:59:38 am »
That is a known issue.

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

TeeJT

  • Pro Ultimate
  • Jr. Member
  • *
  • Posts: 88
    • View Profile
Re: Issue with export as Excel
« Reply #2 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"/>


paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6298
    • View Profile
Re: Issue with export as Excel
« Reply #3 on: June 26, 2017, 10:38:57 am »
"That command cannot be used on multiple selections" issue is fixed in v3.4.1

TeeJT

  • Pro Ultimate
  • Jr. Member
  • *
  • Posts: 88
    • View Profile
Re: Issue with export as Excel
« Reply #4 on: July 04, 2017, 02:36:48 pm »
Thank you very much for resolving the problem.