XLSX "[Content_Types].xml in zip"

See original GitHub issue

Hi, I was trying to update my alasql source file to the latest version so that I can use some of the new functions. However, something broke when I did that and I’m getting the following message in the console:

Uncaught Error: Cannot find file [Content_Types].xml in zip

I’ve found that the 0.2.3 is where something changed, as with 0.2.2 it is still working. I’m using the following code to load in an xlsx file (and this still works with 0.2.2):

alasql('SELECT * FROM XLSX("'+xlsxurl+'",{sheetid:"Sheet1", headers:true})', [],function(listing){

Am I missing something? Where could the problem be?

Issue Analytics

State:
Created 7 years ago
Comments:8 (4 by maintainers)

Top GitHub Comments

1reaction

tmrkcommented, Apr 2, 2016

@mathiasrw I tested it now, and it works perfectly! Thanks!

1reaction

mathiasrwcommented, Apr 1, 2016

@tmrk

You are awesome !

Its a tentative to solve another problem: https://github.com/agershun/alasql/commit/de88a650063d6f86950fc2d32ff1e8a694a809a5

Stop syntax errors I kept getting syntax errors loading csv files and xhr.responseType = “text”; fixed it. I haven’t actually loaded any Binary files but I’m guessing xhr.responseType = “blob”; should probably be go there. anyway thanks again for the library 😃

Soooo - looks like we introduced a new error. Hmm.

Ill remove it - but will have to look into the difference before we release…

Top Results From Across the Web

XML & ZIP: Explore Your Excel Workbooks File Structure

Excel files are actually ZIP files. You can easily unzip them and see all the underlying XML files and folders. Here is what...

Anatomy of an OOXML SpreadsheetML File - Office Open XML

A SpreadsheetML or .xlsx file is a zip file (a package) containing a number of "parts" (typically UTF-8 or UTF-16 encoded) or XML...

Error: Cannot find file [Content_Types].xml in zip

It seems xlsx@0.16.0 is NOT working with Angular 9 . Any help will be much appreciated. Please checkout the snip here - https://stackblitz.com/ ......

Excel: Edit the XML inside an XLSX file - Super User

An Excel XLSX file is a zip archive containing several XML files. I tried to extract all the XML files, and edit xl\connections.xml...

Zipping and unzipping Excel xlsx files - MoonPoint Support

zipped, XML-based file format developed by Microsoft for spreadsheets, charts, presentations and word processing documents.