ParamQuery grid support forum

General Category => ParamQuery Pro Evaluation Support => Topic started by: Punit on January 29, 2022, 07:11:46 pm

Title: Invalid XML Error while binding programmatically edited .xlsx Excel Sheet
Post by: Punit on January 29, 2022, 07:11:46 pm

.XLSX excel sheet binding working fine but after making some changes through c# to the physical file we received an invalid XML error.

Error Message :

Uncaught Error: Invalid XML: <?xml version="1.0" encoding="utf-8"?><Types xmlns="http://schemas.openxmlformats.org/package/2006/content-types"><Default Extension="rels" ContentType="application/vnd.openxmlformats-package.relationships+xml" /><Default Extension="xml" ContentType="application/xml" /><Override PartName="/xl/workbook.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml" /><Override PartName="/xl/worksheets/sheet1.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml" /><Override PartName="/xl/theme/theme1.xml" ContentType="application/vnd.openxmlformats-officedocument.theme+xml" /><Override PartName="/xl/styles.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml" /><Override PartName="/docProps/core.xml" ContentType="application/vnd.openxmlformats-package.core-properties+xml" /><Override PartName="/docProps/app.xml" ContentType="application/vnd.openxmlformats-officedocument.extended-properties+xml" /><Override PartName="/xl/sharedStrings.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sharedStrings+xml" /></Types>

Title: Re: Invalid XML Error while binding programmatically edited .xlsx Excel Sheet
Post by: paramvir on February 02, 2022, 10:36:25 am

How are you making changes directly to physical xlsx file?

To make any changes in xlsx file, use javascript workbook:  https://paramquery.com/pro/api/excel-workbook