search

AlaSQL / alasql

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.
http://alasql.org
MIT License
7.04k stars 659 forks source link

Please , I need your help with a corrupted excel file #711

Closed muhanadbadee closed 8 years ago

muhanadbadee commented 8 years ago

We found a problem with some content in '....xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.

I have important info in this file.

I think that the problem in sheet number 10

Could you help me please ?

1111111111111

mathiasrw commented 8 years ago

Please try to click yes.

Please reopen the issue when you can provide a full code example replicating your problem.

muhanadbadee commented 8 years ago

Dear @mathiasrw

Please help me with this problem.

When I click Yes, the file is open but the repair operation deletes the most important sheet ( number 10 ).

1111111111

The code that I'v got it is :

Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded. Removed Part: Print options. Removed Part: Print options. Removed Part: Print options. Removed Part: Print options. Replaced Part: /xl/worksheets/sheet10.xml part with XML error. Whitespace expected. Line 2, column 113788. Removed Part: Print options. Removed Part: Print options. Removed Part: Print options. Removed Part: Print options. Removed Part: Print options. Removed Part: Data store. Removed Records: Worksheet properties from /xl/workbook.xml part (Workbook) Repaired Records: Cell information from /xl/worksheets/sheet1.xml part Repaired Records: Column information from /xl/worksheets/sheet1.xml part Repaired Records: Cell information from /xl/worksheets/sheet2.xml part Repaired Records: Column information from /xl/worksheets/sheet2.xml part Repaired Records: Cell information from /xl/worksheets/sheet3.xml part Repaired Records: Cell information from /xl/worksheets/sheet4.xml part Repaired Records: Column information from /xl/worksheets/sheet4.xml part Repaired Records: Cell information from /xl/worksheets/sheet5.xml part Repaired Records: Column information from /xl/worksheets/sheet5.xml part Repaired Records: Cell information from /xl/worksheets/sheet11.xml part Repaired Records: Column information from /xl/worksheets/sheet11.xml part Repaired Records: Cell information from /xl/worksheets/sheet12.xml part Repaired Records: Column information from /xl/worksheets/sheet12.xml part Repaired Records: Cell information from /xl/worksheets/sheet13.xml part Repaired Records: Column information from /xl/worksheets/sheet13.xml part Repaired Records: Cell information from /xl/worksheets/sheet14.xml part Repaired Records: Cell information from /xl/worksheets/sheet15.xml part Repaired Records: Column information from /xl/worksheets/sheet15.xml part Repaired Records: Cell information from /xl/worksheets/sheet16.xml part Repaired Records: Column information from /xl/worksheets/sheet16.xml part Repaired Records: Cell information from /xl/worksheets/sheet17.xml part

and the log is :

<?xml version="1.0" encoding="UTF-8" standalone="true"?>

-

error098960_01.xml Errors were detected in file 'C:\Users\simav\Downloads\30 - June - 2016 قوائم - Copy.xlsx'

-

Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.

-

Removed Part: Print options. Removed Part: Print options. Removed Part: Print options. Removed Part: Print options. Replaced Part: /xl/worksheets/sheet10.xml part with XML error. Whitespace expected. Line 2, column 113788. Removed Part: Print options. Removed Part: Print options. Removed Part: Print options. Removed Part: Print options. Removed Part: Print options. Removed Part: Data store.

-

Removed Records: Worksheet properties from /xl/workbook.xml part (Workbook)

-

Repaired Records: Cell information from /xl/worksheets/sheet1.xml part Repaired Records: Column information from /xl/worksheets/sheet1.xml part Repaired Records: Cell information from /xl/worksheets/sheet2.xml part Repaired Records: Column information from /xl/worksheets/sheet2.xml part Repaired Records: Cell information from /xl/worksheets/sheet3.xml part Repaired Records: Cell information from /xl/worksheets/sheet4.xml part Repaired Records: Column information from /xl/worksheets/sheet4.xml part Repaired Records: Cell information from /xl/worksheets/sheet5.xml part Repaired Records: Column information from /xl/worksheets/sheet5.xml part Repaired Records: Cell information from /xl/worksheets/sheet11.xml part Repaired Records: Column information from /xl/worksheets/sheet11.xml part Repaired Records: Cell information from /xl/worksheets/sheet12.xml part Repaired Records: Column information from /xl/worksheets/sheet12.xml part Repaired Records: Cell information from /xl/worksheets/sheet13.xml part Repaired Records: Column information from /xl/worksheets/sheet13.xml part Repaired Records: Cell information from /xl/worksheets/sheet14.xml part Repaired Records: Cell information from /xl/worksheets/sheet15.xml part Repaired Records: Column information from /xl/worksheets/sheet15.xml part Repaired Records: Cell information from /xl/worksheets/sheet16.xml part Repaired Records: Column information from /xl/worksheets/sheet16.xml part Repaired Records: Cell information from /xl/worksheets/sheet17.xml part

Best regards,

mathiasrw commented 8 years ago

How did you generate the file?

muhanadbadee commented 8 years ago

Thanks for your quick reply. @mathiasrw

This file is an old file and it didn't have a problem till yesterday morning.

mathiasrw commented 8 years ago

Have a feeling I cant help. Have a look at http://www.wikihow.com/Recover-a-Corrupt-Excel-File

Did you use AlaSQL to generate it at all?