ParamQuery grid support forum

General Category => Bug Report => Topic started by: Punit on January 31, 2022, 10:00:31 am

Title: Invalid XML Error while binding programmatically edited .xlsx Excel Sheet
Post by: Punit on January 31, 2022, 10:00:31 am

.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:37:28 am

How are you making changes directly to physical xlsx file?

Title: Re: Invalid XML Error while binding programmatically edited .xlsx Excel Sheet
Post by: Punit on February 02, 2022, 11:03:23 am

First I made ajax call with cell address to c# mvc and then later in c# I used third party dll like closedXML for edit physical XLSX and then try to load this edited bind excel but it gives error.

Title: Re: Invalid XML Error while binding programmatically edited .xlsx Excel Sheet
Post by: paramvir on February 02, 2022, 04:20:29 pm

I'm able to use closedXML in C# to manipulate pqgrid generated xlsx file and then save and then again open it without any issues.

Please share a complete test case reproducing the error along with mention of pqgrid version.

Title: Re: Invalid XML Error while binding programmatically edited .xlsx Excel Sheet
Post by: Punit on February 02, 2022, 06:22:25 pm

1. Code I Write in c# for change excel cell color.
string path = Server.MapPath("~/Excel/ExcelTagging.xlsx") ;
XLWorkbook wb = new XLWorkbook(path);
IXLWorksheet ws = wb.Worksheets.First();
ws.Cell(2, "A").Style.Fill.BackgroundColor = XLColor.Yellow;
wb.SaveAs(path);
wb.Dispose();

2. My code of paramquery for bind excel data
var excelPath = '../../Excel/ExcelTagging.xlsx";
pq.excel.importXl({ url: excelPath }, function (wb) {
grid.importWb({ workbook: wb, extraRows: 100, extraCols: 100 });
grid.hideLoading();
})


Second code give error if bind modfied excel sheet.

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>
    at Function.error (VM9 jquery.min.js:3:4022)
    at Function.parseXML (VM9 jquery.min.js:3:4787)
    at Object.readPaths (pqgrid.min.js:11890:25)
    at Object.getWorkBook (pqgrid.min.js:11775:105)
    at l (pqgrid.min.js:11839:54)
    at XMLHttpRequest.r.onload (pqgrid.min.js:663:17)

Title: Re: Invalid XML Error while binding programmatically edited .xlsx Excel Sheet
Post by: paramvir on February 06, 2022, 10:07:00 pm

Thanks for sharing the details. Closedxml / pqgrid interoperability would be released in the upcoming version.

Title: Re: Invalid XML Error while binding programmatically edited .xlsx Excel Sheet
Post by: Punit on February 07, 2022, 02:54:01 pm

could you please inform tentative Date of next release.

Title: Re: Invalid XML Error while binding programmatically edited .xlsx Excel Sheet
Post by: paramvir on February 08, 2022, 11:34:43 am

ETA: By end of Feb

Title: Re: Invalid XML Error while binding programmatically edited .xlsx Excel Sheet
Post by: Punit on February 21, 2022, 03:10:55 pm

Hello,

Did you fixed the bug?

Title: Re: Invalid XML Error while binding programmatically edited .xlsx Excel Sheet
Post by: Punit on March 15, 2022, 10:28:56 am

Hello Paramvir,

Have you fixed excel bug and released new version?

Title: Re: Invalid XML Error while binding programmatically edited .xlsx Excel Sheet
Post by: paramvir on March 15, 2022, 05:34:36 pm

It's fixed in v8.3.0