Excel file suffered damage

Excel file is damaged

1: Manual processing

1. Enter Word, select "All Files" in "File/Open/File Type", and specify the .xls file to be repaired. After opening, if Excel has only one worksheet, it will be automatically installed in the form of a table. When entering Word, if the file is composed of multiple worksheets, only one worksheet can be opened at a time.

2. Delete the damaged part of the data in the file.

3. Select the table with the mouse, select "Convert Table to Text" in the "Table" menu, and select the "," delimiter or other delimiter.

4. Save it as a text file .txt.

5. Open the text file directly in Excel and save it as an Excel file with another name.

Note: This repair method is implemented by using Word's function of directly reading Excel files. This method is more effective when the file header is not damaged, but the file content is damaged. If the file header is damaged, Excel file, this method may not be successful and other methods must be resorted to.

2: Use Excel Repair Tool

There are quite a few repair tools, such as excel recovery or office fix. You can come down and have a look.

How to delete damaged tables in IQ database

(1) Restart the server

start_asiq -n bad_db_server -x 'tcpip{port=xxx}' -gm 1 -gd dba bad_db.db

In this command line, -gm 1 only allows one user to connect, and -gd only allows DBA access. When an object is forcibly deleted, other users must be prohibited from connecting.

Explanation: bad_db_server is the damaged IQ Server, and its name is the engine name specified by the -n parameter in the .cfg file bad_db.db is the catalog db name of the damaged IQ database (2) Turn on the temporary option FORCE_DROP to ON:

set temporary option FORCE_DROP = 'ON'

(3) Delete all inconsistent objects

Use DROP TABLE to damage the table. Do not execute any other DDL or DML commands before restarting the server.

(4) Restart the server

You can restart the server with the -iqdroplks option to recover the leaked space and modify the allocation map to the correct state.

start_asiq -n bad_db_server -x 'tcpip{port=xxx}' -iqdroplks bad_db bad_db.db

You need to specify the database name twice. The former is used by the -iqdroplks option, and the latter specifies the database to be started.

(5) Run sp_iqcheckdb

sp_iqcheckdb 'allocation database'.

This step uses the calculated allocation map to reset the database allocation map.

If no errors occur during the execution of the above stored procedure, it will display the "Freelist Updated" message, indicating that the recovery of the leaked space has been completed

(6) Issue a checkpoint

That is, execute the checkpoint statement

(7) Use common method to stop the server

(8) Use the normal method to start the server, and normal operations can be performed after startup.

How to delete damaged table space in oracle

oracle10g has a recycle bin function. When we delete a table, we do not actually delete the table completely. Instead, we put the table into the recycle bin. Finally, a bunch of strange table names appear: BIN$2cMp4FjwQ2Cw3Lj BxLYTw==$0

The clearing method is as follows:

purge table original_tableName;

purge index original_indexName;

To query spam information, you can use the following SQL statement:

SELECT t.object_name,t.type ,t.original_name FROM user_recyclebin t;

Now I find that there is this command:

PURGE recyclebin;

It’s not as complicated as the above. hehe!

Another way to delete a Table without entering Recycle:

drop table tableName purge;

EXCEL file damage

1. In EXCEL, click the menu File >> Open >> Select this file >> The drop-down arrow next to the button "Open" >> Open and repair, give it a try

2. See if other repair tools such as EasyRecovery or EXCELFIX can repair it again

Concept Data Company provides a repair tool specifically designed to repair damaged Excel files

The recovery tool ExcelRecovery can recover Excel 5.0/97/2000 files

For complex processing, you can first download the free demo version of the software for trial use, which is only 674KB. soft

After the software is installed, the Excel repair program can be automatically added to the Excel application, in "

There is an additional "Recovery" option under the "File" menu. If there are damaged files, you can use

This option is repaired.

>>>>Usage is:

>>>>1. Open Excel;

>>>>2. Click the "Recover" option under the "File" menu, Excel Recovery will

The dialog box will open;

3. Specify the Excel file to be repaired, and then press the [Recover] button;

>>>>4. Automatic repair;

>>>>5. Save as a new file name to complete the file repair work.

>>>>Note: This demo version can only repair ordinary files and cannot repair files with Visual Basic

Code, charts and Excel files containing passwords. If you need to repair these files, you need to pay Mimi to register.

>>>>I have used it several times and it can basically be fixed.

3. If it still doesn’t work, you can use Notepad to open it and sort out the remaining data

If I can’t repair it, I really have no choice. I’ll pay more attention to backup in the future. Don’t force quit when operating the worksheet, such as when saving the worksheet.

The above is the detailed content of Excel file suffered damage. For more information, please follow other related articles on the PHP Chinese website!